Pivot Tables & Charts

1. Pivot Tables & Charts

2. When to use a Pivot Table?

3. How to structure your input data

4. How NOT to structure your input data

5. How NOT to structure your input data

6. How NOT to structure your input data

7. How to correctly structure the data (previous slide)

8. Anatomy of a Pivot Table

9. Limitations of Pivot Table Data

10. Creating a Pivot Table

11. Creating a Pivot Table

12. Creating a Pivot Table

13. Creating a Pivot Table:Select fields (top right) and then simply drag them into or out of the areas (below right)

15. Re-arranging the Pivot Table fields

16. Using the optional “filter” field

17. (1) Changing Data; and (2) Adding Data

18. (1) Changing Data; and (2) Adding Data

20. Cosmetic editing: Applying a style

21. Cosmetic editing: Number format

22. Cosmetic editing: Replacing blank cells (with zeros)

23. Cosmetic editing: Changing field names

24. Cosmetic editing: Layout

28. Cosmetic editing: Subtotals, blank lines, etc.

29. Cosmetic editing: Removing field headings