Use of Microsoft Office 2003 Excel Pivot Tables

1. Use of Microsoft Office 2003 Excel Pivot Tables ASQ Milwaukee Pre-Meeting Clinic Monday, May 21, 2012 Presented by: Jeff Stumpe

2. Presentation Overview • Pivot Tables are Microsoft Excel’s premier analytical tool – the ideal feature for quickly creating summary information that can be easily manipulated with drag-and-drop techniques to show multiple levels of totals in a variety of layouts. • Microsoft Excel users who need to analyze database-like data can only go so far with sorting, filtering, and inserting subtotals. • Ways are needed to created multiple totals in columns and rows and have the capability to interchange these fields, add other fields and sort results without using lengthy command sequences and creating complicated formulas. • How much time do you waste analyzing and manipulating data in Microsoft Excel 2003? If you don’t know how to use Pivot Tables, a lot!!

3. Adding the Pivot Table Menu to the Toolbar

4. The Pivot Table Menu Options No Active Pivot Table Drop Down Active Pivot Table Drop Down

5. Creating the Pivot Table

6. Creating the Pivot Table Single Cell Column Titles!!!

7. Creating the Pivot Table Text or Number Data Columns Number Data Columns

8. Creating the Pivot Table – Pivot Table Field Settings Data Columns Only

9. Creating the Pivot Table – Pivot Table Field Settings Click Drop Down for Selection/De-selection

10. Creating the Pivot Table – Pivot Table Field Settings Click Sort Ascending to Re-order Column Data (Alpha-Numeric)

11. The Pivot Table Menu – Hiding Subtotals

12. The Pivot Table Menu – Hiding Detail

13. The Pivot Table Menu – Refresh Data Use When Changes Have Been Made to Source Data but No Changes Have Been Made to #Rows, #Columns

14. The Pivot Table Menu – Capture New Data

15. The Pivot Table Menu – Show Field List