Excel – Pivot Tables Dori Baldwin Computer Logic Group
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
About the Trainer… Dori • Member of CLG • Retired from education • 15 years • PowerSchool consultant/implementation • PowerSchool administrator • Teacher • Hobbies/Interests • Dogs • Travel • Lighthouses
Your turn…. • Who has created a pivot table? • Who can explain what a pivot table is?
Training Material Psugmi.com
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
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