PSUG of Michigan
  • Home
  • PSUG Events
    • MI Events>
      • PSUG-MI Spring Conference
      • 2013 PSUG-MI Fall
      • 2012 Fall Conference>
        • Session Descriptions
        • Novi Schedule
    • National Conference>
      • 2013 National>
        • Why Las Vegas?
        • Vendor Expo!
        • Sponsor/Exhibitor info
        • 2013 Schedule
        • Airport Transportation
        • 2013 FAQ
        • Meet our Presenters!
        • New Page
        • Vegas Links
        • Freemont Street Experience
        • Downtown
        • Resorts
        • Resorts, Off Strip
        • Things to do in LV
        • Shows in Vegas!
        • All Stage Pass & Buffet of Buffets
    • Other PSUG Events>
      • PSUG-Southeast>
        • SE Documents
      • PSUG Colorado
      • European PSUG
      • PSUG New Jersey
    • Past Events>
      • Past MI Events>
        • Summer 2011>
          • Sessions
          • Session 1
          • Session 2
          • Session 3
          • Session 4
          • Session 5
          • Session 6
          • Session 7
          • Session 8
          • Secretarial Sessions
          • Call For Proposals-Fall
        • Summer 2010
        • Fall 2009
        • Sys Admin Fall 2009>
          • Schedule
        • Summer 2009
      • Past National Events>
        • 2012 National>
          • Vendors 2012
          • Course Catalog
          • 2012 Schedule
          • PRIZES & CONTESTS
          • Schedule
          • Coupons
          • 2012 National PSUG Blog
        • Vegas 2011>
          • Vegas 2011 Presentations
          • Exhibitors
          • Riviera Hotel
          • Call For Proposals
          • Vendors
          • Vegas Schedule
  • Training Material
    • PSUG-SE Files
    • Customization>
      • Customizations
      • Customizations - Must Have
    • Excel>
      • Excel - Beginning
      • Excel - Cool Tips and Tricks
      • Excel - Formulas
      • Excel - Functions
      • Excel - Pivot Tables
    • General>
      • End of Term Processes
      • I'm a Counselor - Where's my session
      • PowerSchool 101 - Intro to PowerSchool
      • Q & A for Newbies
      • Secretaries - A Day in the Life
      • Secretaries - A Year in the Life
    • Reporting>
      • Creating Standards Based Report Cards
      • Custom Reports Bundle
      • Custom Reports Made Easy Using the sqlReports Add-on
      • Intro to Object Reports
    • Scheduling>
      • Elementary Scheduling with Excel
    • State Reporting>
      • Understanding TSDL
      • Pupil Accounting - Tips and Tricks
    • SQL>
      • SQL Reports
      • SQL - Basic
    • Working with Data>
      • Data, Data, Data - What you can do with DDE...
      • Data Validation
      • DDE 101 - Exporting and Importing
      • Make your data work for you...
      • Tables - Where's the Data?
  • State PSUGs
    • PSUG Links
  • Our Partners
  • About Us
    • PSUG-MI Meetings
    • PSUG-MI Board
    • Discussion
    • Payment
    • Staff Files
    • 2012 Photos

Excel - Pivot Tables

Facilitator:  Dori Baldwin
Affiliation:  Kent ISD

Description:  In this session you will learn how to take data pulled from your own server and create meaningful pivot tables and charts.  To be successful in this course, you must have an understanding of DDE/DDA, exporting data from PowerSchool and basic Excel.  The focus will be on using Excel and NOT exporting data.

excel_-_pivot_tables.pptx
File Size: 3705 kb
File Type: pptx
Download File

pivot_tables_-_hands_on_activities.pdf
File Size: 827 kb
File Type: pdf
Download File

sample_pivot_table_data.xlsx
File Size: 183 kb
File Type: xlsx
Download File

enrollment-pivot.xlsx
File Size: 168 kb
File Type: xlsx
Download File

enrollment-pivot.xls
File Size: 480 kb
File Type: xls
Download File

©2012 PSUG of Michigan