
Pivot Tables
One well designed Pivot Table can replace dozens and dozens of canned reports. Watch the Excel Videos in this initial playlist, read the Pivot Table article, and play with sample spreadsheet that accompanies the article. Once you’re comfortable with the basics of Pivot Tables, I’ve included links to several other Pivot Table playlists to really take your Pivot Table skills to the next level. I hope you find this Excel Mastery topic very helpful in your practice.

Excel Video 280 Create a Pivot Table
I’ve decided to go back and cover Pivot Tables again, starting in Excel Video...

Excel Video 281 Pivoting Rows and Columns in a Pivot Table
If you’ve wondered why Microsoft calls it a Pivot Table, watch Excel Video...

Excel Video 282 Sorting Pivot Table Data
Sorting Pivot Table data, as we’ll do in Excel Video 282, is much easier than...

Excel Video 283 Manually Sorting Pivot Table Data
When sorting A-Z or Z-A isn’t good enough, watch Excel Video 283. Today...

Excel Video 284 Manual Filters
Excel Video 284 shares an easy way to filter your Pivot Table data. There are...

Excel Video 285 Label Filters
Excel Video 285 adds some real power to your filtering skills by introducing...

Excel Video 286 Date Filters
Watch Excel Video 286 to see how Excel customizes your filter options based on...
Pivot Tables article
One well-designed Pivot Table can replace dozens and dozens of canned reports. Here are all of the tools you need to begin your mastery of Pivot Tables
Pivot Table Spreadsheet
Here’s the sample Pivot Table spreadsheet referenced in the article.