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 demonstrates how to refresh Pivot Table data. It’s critical to realize that once Excel...

In Excel Video 13 I showed how use GETPIVOTDATA to create formulas outside the Pivot Table based on Pivot...

Happy New Year! I hope you enjoyed the break. We’re starting 2010 with an easy example to get back into...

When I spoke at the MGMA Annual Conference in Denver, several people asked me if there was a way to...

Here’s part 2 of our series on consolidating multiple Excel ranges into a single Pivot Table. Lesson 18...

First off let me apologize for the length and file size of Excel Video 20. I try to keep these videos just a...

After the long Excel Video 20, here’s a short video to show how flexible the consolidation process is. I...

Excel Video 22 starts another set of videos. Part 1 shows you where the Pivot Table Options menu is and...

Excel Video 23 is the second part of our coverage of the Pivot Table options menu. Most of the time,...

Excel Video 24 walks through the Display tab of the Pivot Table Options menu. There are a couple of...

Excel Video 25 wraps up our discussion of the Pivot Table Options Menu by discussing the Printing tab and the...

We talked about grouping data in prior videos, but there’s another grouping trick that will come in handy. ...

I hope by now you’re a fan of the power and flexibility of Pivot Tables. Now that you’ve seen some of...

This is one of those videos that may take a minute to load. Excel Video 28 is an extended example of how to...

All of the Pivot Chart examples we’ve been through in prior videos involved creating a Pivot Chart and the...