When I spoke at the MGMA Annual Conference in Denver, several people asked me if there was a way to consolidate data in multiple ranges, either in different parts of the same spreadsheet, different tabs on the same spreadsheet, or in different spreadsheets altogether, into one Pivot Table. The answer is yes, but it’s a little complicated. Excel’s created a wizard to make the consolidation process easier, but the wizard’s not visible in Excel 2007 without a little work. This video shows you how to add the Pivot Table wizard to your Excel 2007 Quick Access Toolbar and sets up the profit and loss data we’ll be working with. Stay tuned. Lesson 19 will show you how to use the wizard and we’ll start consolidating data.
