
Excel 2007 Advanced Pivot Table Tricks Playlist
Excel Video 13 GETPIVOTDATA
The GETPIVOTDATA function is a pretty hairy looking formula in Pivot Tables. The idea behind GETPIVOTDATA is...
Excel Video 14 Pivot Table Formulas
Excel Video 14 demonstrates another, simpler way to create formulas based on Pivot Table data. When you want...
Excel Video 15 Refreshing Pivot Table Data
Excel Video 15 demonstrates how to refresh Pivot Table data. It’s critical to realize that once Excel...
Excel Video 16 Pivot Table Calculated Fields
In Excel Video 13 I showed how use GETPIVOTDATA to create formulas outside the Pivot Table based on Pivot...
Excel Video 17 Top x Value Filter
Happy New Year! I hope you enjoyed the break. We’re starting 2010 with an easy example to get back into...
Excel Video 18 Consolidating Multiple Ranges into One Pivot Table Part 1
When I spoke at the MGMA Annual Conference in Denver, several people asked me if there was a way to...
Excel Video 19 Using the Pivot Table Wizard to Consolidate Multiple Ranges
Here’s part 2 of our series on consolidating multiple Excel ranges into a single Pivot Table. Lesson 18...
Excel Video 20 Format and Design Tricks for Consolidated 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...
Excel Video 21 A Little More on Consolidating Pivot Tables
After the long Excel Video 20, here’s a short video to show how flexible the consolidation process is. I...
Excel Video 22 Pivot Table Options – Part 1
Excel Video 22 starts another set of videos. Part 1 shows you where the Pivot Table Options menu is and...
Excel Video 23 Grand Totals and Custom Lists
Excel Video 23 is the second part of our coverage of the Pivot Table options menu. Most of the time,...
Excel Video 24 Pivot Table Display Options
Excel Video 24 walks through the Display tab of the Pivot Table Options menu. There are a couple of...
Excel Video 25 Printing and Data Options
Excel Video 25 wraps up our discussion of the Pivot Table Options Menu by discussing the Printing tab and the...
Excel Video 26 Grouping Numbers in Pivot Tables
We talked about grouping data in prior videos, but there’s another grouping trick that will come in handy. ...
Excel Video 27 Introduction to Pivot Charts
I hope by now you’re a fan of the power and flexibility of Pivot Tables. Now that you’ve seen some of...
Excel Video 28 Pivot Chart Example
This is one of those videos that may take a minute to load. Excel Video 28 is an extended example of how to...