1 / 10

Excel – Pivot Tables

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.

ewan
Download Presentation

Excel – Pivot Tables

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

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

More Related