by Nate Moore | Jan 7, 2010 | Pivot Tables
Here’s part 2 of our series on consolidating multiple Excel ranges into a single Pivot Table. Lesson 18 added the Pivot Table Wizard to the Quick Access Toolbar and prepared the data to consolidate. This video goes through the Pivot Table Wizard to actually create the...
by Nate Moore | Jan 5, 2010 | Pivot Tables
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,...
by Nate Moore | Jan 4, 2010 | Pivot Tables
Happy New Year! I hope you enjoyed the break. We’re starting 2010 with an easy example to get back into Excel. There’s a cool feature under value filters that allows you to filter for the top or bottom x items, percentage, or sum of items in your table. If you want to...
by Nate Moore | Dec 17, 2009 | Pivot Tables
In Lesson 13 I showed how use GETPIVOTDATA to create formulas outside the Pivot Table based on Pivot Table data. In Lesson 14, I showed another way to create formulas using Pivot Table data. Both formulas were outside the Pivot Table looking into the data. Lesson 16...
by Nate Moore | Dec 16, 2009 | Pivot Tables
Lesson 15 demonstrates how to refresh Pivot Table data. It’s critical to realize that once Excel creates a Pivot Table, it doesn’t automatically go back to look at or refresh the data the Pivot Table is based on. Instead, Excel keeps the original data in the Pivot...