
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...
Excel Video 3 Filtering a Pivot Table Video
Today’s video introduces the basic filtering options in a Pivot Table using the same sample medical...
Excel Video 4 Grouping Pivot Table Fields
Today’s video demonstrates how to group dates in Pivot Tables fields. As long as Excel sees the dates are...
Excel Video 5 Grouping Text in Pivot Tables
Excel Video 4 demonstrated the way Excel groups dates in a Pivot Table. Excel Video 5 demonstrates how to...
Excel Video 6 Drilling Down in Pivot Tables
If you’ve ever been challenged on whether a number in your report is correct, you need to know how to drill...
Excel Video 7 Multiple Rows and Columns in Pivot Tables
Pivot Tables have a clever feature that allows you to drag multiple rows and columns to the same Pivot Table...
Excel Video 8 Label Filters in Pivot Tables
Excel Video 8 demonstrates a cool new feature in Excel 2007, label filters. Label filters allow you to...
Excel Video 9 Value Filters in Pivot Tables
Excel Video 9 picks up where Excel Video 8 left off. Excel Video 8 showed how label filters can filter Pivot...
Excel Video 10 Multiple Pivot Table Value Fields
Excel Video 10 shows how to add calculations to a Pivot Table by dragging more than one field to the values...
Excel Video 11 Sum and Count Pivot Table Values
I’ve created new set of sample data to learn with, sample receivables data. My experience is that...