by Nate Moore | Jan 19, 2010 | Pivot Tables
Excel Video 24 walks through the Display tab of the Pivot Table Options menu. There are a couple of highlights worth mentioning. Watch the video to learn what a contextual tooltip is and how to turn them on or off. For those of you who have used Pivot Tables before...
by Nate Moore | Jan 18, 2010 | Pivot Tables
Excel Video 23 is the second part of our coverage of the Pivot Table options menu. Most of the time, you’ll want to include grand totals in the rows and columns of a Pivot Table, but if you’ve got data like PSA scores, total PSA scores may not be meaningful. Here’s an...
by Nate Moore | Jan 14, 2010 | Pivot Tables
Excel Video 22 starts another set of videos. Part 1 shows you where the Pivot Table Options menu is and covers the first tab, Layout & Format. These formatting options are helpful when you’re formatting a Pivot Table to print, when you’ve got a lot of filters at...
by Nate Moore | Jan 12, 2010 | Pivot Tables
After the long Excel Video 20, here’s a short video to show how flexible the consolidation process is. I simply take the same data that we used before, where all three ranges had exactly the same Profit and Loss categories, and changed one of the categories in one of...
by Nate Moore | Jan 11, 2010 | Pivot Tables
First off let me apologize for the length and file size of Excel Video 20. I try to keep these videos just a couple minutes in length and a smaller file size that downloads relatively quickly. The formatting and design tricks in Excel Video 20 took a while, so Excel...
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...
