Pivot tables and charts

[24 minutes total]

The Pivot tables and chartsfeature in Excel lets educators begin disaggregating and analyzing data within seconds (literally) of receiving original data files from state departments, testing companies, and/or school districts. These ten tutorials show how to use what is perhaps the most powerful data analysis tool within Excel (note: dynamic pivot charts do not work in Macintosh versions of Excel, but pivot tables do!). Before viewing these tutorials, it is recommended that you view the Charts and Graphs tutorials if you do not already know how to use Excel's charting features.

After viewing the tutorial(s), use the back key in your browser to return to this web site.

• Introducing pivot tables (1:49)
• Setting up and formatting pivot table data fields (1:48)
• Setting up pivot table categories (2:46)
• Correcting common mistakes, like removing data fields and making the field list and pivot table toolbar reappear (2:02)
• Understanding your data and its suitability for a pivot table (1:21)
• Determining suitable categories for a pivot table and using page fields (4:28)
• Dragging in a category twice to break out the count by category (2:19)
• Creating pivot charts (2:09)
• Understanding the relationships between pivot charts and tables and hiding buttons during printing (1:07)
• Reviewing pivot tables and charts(2:46)

You may need to turn off your browser's pop-up blocker or install the latest Flash plug-in to view these tutorials.