Introduction to Excel Pivot Tables
October 12, 2021
Are you feeling overwhelmed by all the data you have on hand? Are you looking for an easy tool to help you analyze your data? Using a sample child outcomes data set and Excel’s built-in features, during this workshop you’ll learn:
- Basics of creating Pivot Tables
- How to prepare, format, and filter data
- How to analyze and disaggregate data
Participants can refer to the Excel sample data set below to practice activities during the session.
Intended Audience: Part C and Part B 619 Coordinators and Data Managers with basic familiarity with Excel.
Pivot Tables Introduction Slides
Sample Child-Outcomes Data Set for Participants
DaSy Pivot Table Resources
Developing Advanced Pivot Tables
October 14, 2021
Have you ever wondered what more you could do with pivot tables? Have you dabbled in pivot tables but want to unlock their full potential? Using a sample child outcomes data set, during this workshop you’ll learn to:
- How to use slicers and timelines
- How to use table designs and dashboard design
- How to use pivot charts, and more
Participants can refer to the Excel sample data set below to practice activities during the session.
Intended audience: Part C and Part B 619 Coordinators and Data Managers who have basic knowledge of Microsoft Excel, structuring a data set for pivot tables, and using the PivotTable feature in Excel.
Developing Advanced Pivot Tables Slides
Sample Child-Outcomes Data Set for Participants
DaSy Pivot Table Resources