by Nate Moore | Dec 19, 2012 | Pivot Tables
If you haven’t been frustrated by the Pivot Table behavior we’ll discuss in Excel Video 320, you probably will be at some point. If you’ve created the perfect Pivot Table and have it formatted to precisely fit one page, you might be frustrated when you refresh your...
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...
