Download
pivot tables charts n.
Skip this Video
Loading SlideShow in 5 Seconds..
Pivot Tables & Charts PowerPoint Presentation
Download Presentation
Pivot Tables & Charts

Pivot Tables & Charts

93 Views Download Presentation
Download Presentation

Pivot Tables & Charts

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  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)

  14. Re-arranging the Pivot Table fields

  15. Using the optional “filter” field

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

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

  18. Cosmetic editing: Applying a style

  19. Cosmetic editing: Number format

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

  21. Cosmetic editing: Changing field names

  22. Cosmetic editing: Layout

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

  24. Cosmetic editing: Removing field headings