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