Download
excel pivot tables n.
Skip this Video
Loading SlideShow in 5 Seconds..
Excel – Pivot Tables PowerPoint Presentation
Download Presentation
Excel – Pivot Tables

Excel – Pivot Tables

160 Views Download Presentation
Download Presentation

Excel – Pivot Tables

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

  1. Excel – Pivot Tables Dori Baldwin Computer Logic Group

  2. Agenda • All things Pivot Tables • Basic Design • Using Filters • Moving between Rows and Columns • Viewing Multiple Data Calculations • Grouping Data • Pivot Table Chart • Drilling into data • Formatting

  3. About the Trainer… Dori • Member of CLG • Retired from education • 15 years • PowerSchool consultant/implementation • PowerSchool administrator • Teacher • Hobbies/Interests • Dogs • Travel • Lighthouses

  4. Your turn…. • Who has created a pivot table? • Who can explain what a pivot table is?

  5. Training Material Psugmi.com

  6. What is a pivot table? • Wikipedia • A data summarization tool • Whatis • Reorganize and summarize selected columns and rows • Business Dictionary • Feature that allows data tables to be rearranged in many ways for different views

  7. The Real Answer

  8. Let’s go make some Information from data…

  9. Recap • Information in PowerSchool can be used to answer lots of questions • Pivot Tables can layout the data in a useable fashion • Charts and formatting will provide a quality product with little effort