Despite the power of refreshable Excel reports, there can be times where you can't get to the information you need. Maybe the information is there, but it isn't formatted in the way that you want. The beauty of Excel reports is that we have the power of Excel and SQL at our fingertips. In this section, we will look at some ways to reformat data in Excel and some options to get additional information into an Excel report.
It is common to want to reformat information after it arrives in Excel. For example, in the Account Summary worksheet that we've been working with, it can be helpful to combine Year and Period to make sorting and understanding data easier. Because Dynamics GP 2013 automatically puts Excel data into tables, this is easy to do using Excel formulas. Excel 2013 makes it even easier with its new Flash Fill feature. Let's look at how to do it both ways.
To combine Year and Period with a formula:
Open the TWO AccountSummary Report.
If...