For those ready to go deeper, this session focuses on Excel’s powerful data tools. Participants will learn how to clean, analyze, and summarize complex datasets using PivotTables and lookup functions to support better decision-making.
Learning Outcomes
Use PivotTables and lookups
Clean large datasets
Summarize information
Support decisions with data
Recommended Prerequisite: Participants should be comfortable working with larger datasets in Excel, including using formulas (such as IF, SUMIFS, VLOOKUP or XLOOKUP), formatting tables, and creating basic charts. This course is best suited for those who have completed the Intermediate Excel: Analyze Data with Confidence course or regularly use Excel for analysis and reporting.