by Nate Moore | Dec 17, 2012 | Pivot Tables
Excel Video 319 has several ways to adjust the layout of your Pivot Table. If you have several columns in your Pivot Table and you’d like to center your column label over those columns, you need to spend a few minutes in the Pivot Table Options menu. That same Options...
by Nate Moore | Dec 12, 2012 | Pivot Tables
If you need to create a series of filtered Pivot Tables quickly, Excel Video 318 has a trick for you. If you’ve created a Pivot Table and now want to show a filtered Pivot Table to each of your 8 doctors or for each of your 3 practice locations, Show Report Filter...
by Nate Moore | Dec 10, 2012 | Pivot Tables
Excel Video 317 is a collection of several tips from the Pivot Table Options Menu to make your life easier. The first tip is how to quickly remove all filters. Be careful to clear filters, not clear all. Clear all will clear your entire Pivot Table without an undo...
by Nate Moore | Dec 5, 2012 | Pivot Tables
Excel Video 316 has one of the most important things to know about a Pivot Table. One of the reasons Pivot Tables can manipulate so much data so quickly is that once you set up a Pivot Table in Excel, Excel never goes back to the original data to see if the data has...
by Nate Moore | Dec 3, 2012 | Pivot Tables
Pivot Tables are easier to organize and manage if you know the tricks to using the Pivot Table Field List shown in Excel Video 315. Watch how to hide the Pivot Table Field List when you’re presenting your Pivot Table. We’ll also discuss several ways to display your...
