Use Pivot Tables to Summarize Dates
Summarizing dates in a pivot table can be a little tricky. The pivot table video linked to below from Danny Rocks gives a nice short pivot table tutorial on how to summarize dates. I especially like the fast pace and clear explanations in the pivot table video. Check it out.
Use Pivot Tables to Summarize by [...]
Add Running Totals to an Excel Pivot Table
Check out this short but easy to follow pivot table tutorial on how to add running totals to an excel pivot table.
Bookmark It
Pivot Table Tutorial Videos from Data Pig Technologies
Data Pig Technologies has some of the best pivot table tutorial videos that I have seen on the web. Check them out below.
- Create a Basic Pivot Table
- Sorting in a Pivot Table
- Create a Drill Down Effect with a Pivot Table
- Adding a Calculated Field in a Pivot Table
- Grouping in a Pivot [...]
Excel 2003 Pivot Table Tutorial
If you have ever been confused by the terminology that is used to describe pivot tables, then this video will help. It does a good job of explaining what the various parts of the pivot table and pivot table data are called. It covers items such as source data, data items, and fields.
Excel 2003 Pivot [...]
Building a Pivot Table in Excel 2007
For those of you that prefer video training, the following pivot table tutorial for excel 2007 from “The Missing Manuals” series will be of interest.
Bookmark It
How to Use Pivot Tables to show values and percentages side by side
I came across this very well done video of how to set up a pivot table in Excel 2007 to show the value and percent for the same item. This is a little used but valuable feature in Excel that will help you to easily show the relative importance of the various items.
Rikki’s Hints [...]
How To Use Pivot Tables to Impress Your Boss
An amusing look at how to use a pivot table at work to impress the boss.
Bookmark It
