Creating a Basic Pivot Table in Excel 2007
Posted February 1st, 2010 / 1 Comment
With the release of Microsoft Dynamics GP 2010 and Microsoft Office Excel 2010, see any naming correlation? You will have more options, more views and even more reporting power, right at your fingertips.
Without diving into the “What’s New” with Microsoft Dynamics GP 2010 or Microsoft Office Excel 2010 at present I would like to take this opportunity to talk about Microsoft Excel Pivot Tables in the 2007 version. Pivot Tables are an important piece to the end result and you will need to know a little more about them in order to get the best usage from your data extrapolated from Microsoft Dynamics GP, Analysis Services or Smartlist.
The learning approach here is going to be from an Excel perspective. We are going to cover the basics of Microsoft Excel 2007 Pivot Tables. We will learn some important terms, definitions and included as a link is the full article with practice example that you can use to create your own Pivot Table in Excel 2007.
Once you see how Basic Excel Pivot Tables work you will see the huge benefits you can gain from incorporating products like Analysis Cubes and future Excel versions.
To download the full article with step by step instructions to create a pivot table using Excel 2007 click the link http://www.box.net/shared/xts1xymlqk
To access the Excel spreadsheet used in the practice click the link http://www.box.net/shared/q9hchzc5br
