Excel 2007 Pivot Table Basics Playlist

Excel Video 1 Create a Pivot Table

It’s not Disney, folks, but I think you’ll find these videos very helpful. I hope you enjoy the latest...

Excel Video 2 Sorting a Pivot Table Video

Here’s another video I hope you’ll find helpful. Today’s video shows how to sort both values and...

Today’s video introduces the basic filtering options in a Pivot Table using the same sample medical...

Today’s video demonstrates how to group dates in Pivot Tables fields. As long as Excel sees the dates are...

Excel Video 4 demonstrated the way Excel groups dates in a Pivot Table. Excel Video 5 demonstrates how to...

If you’ve ever been challenged on whether a number in your report is correct, you need to know how to drill...

Pivot Tables have a clever feature that allows you to drag multiple rows and columns to the same Pivot Table...

Excel Video 8 demonstrates a cool new feature in Excel 2007, label filters. Label filters allow you to...

Excel Video 9 picks up where Excel Video 8 left off. Excel Video 8 showed how label filters can filter Pivot...

Excel Video 10 shows how to add calculations to a Pivot Table by dragging more than one field to the values...

I’ve created new set of sample data to learn with, sample receivables data. My experience is that...

Excel Video 12 demonstrates a couple of formatting tricks to make your Pivot Tables look really good. Excel...