Tips for watching these videos:

1. Look at our YouTube quick reference sheet first for tips on how to get the best viewing experience.
2. Make sure the sound on your computer is turned on (we recommend using headphones).
3. Have Excel open as you watch these videos. You can download a practice spreadsheet here. Pause the video as needed to switch to Excel and try out what you've just seen. Then, when you're ready to move on, play the video again.
4. You can also print the handout and use it as a reference while you work.

Tutorial Videos:

• Get started - Create your pivot table.
• Refine or re-define your table - Use filters and sorting, add a secondary criterion, display values as percentages.
• Advanced options - Add column labels, groups, report-wide filters.
• Slicers - A new feature in Office 2010 that lets you quickly filter data. (Video by Microsoft.)
• Final steps - Format numbers, pick a color scheme, copy a pivot table, "paste special" to paste values only.

View the YouTube playlist »