🔍
Module 7: Data Analysis Tools
Advanced PivotTable techniques, What-If Analysis tools, and reference styles for deeper data analysis.
3
Lessons
60
Minutes
Practice
Files Included
Advanced
Level
Lessons
Complete each lesson in order. Watch the video, review the notes, and finish the challenge.
Lesson 1⏱ 10 min
🔍Doing More with PivotTables
Learn how to perform deeper analysis with PivotTables by filtering, grouping, and refreshing summarized data.
✔ Includes Practice File
Lesson 2⏱ 35 min
🔍What-If Analysis
Learn how to experiment with data using Excel’s What-If Analysis tools. In this lesson you will use Goal Seek to determine unknown values, explore Scenario Manager, and understand how Data Tables allow you to test multiple possibilities at once.
✔ Includes Practice File
Lesson 3⏱ 10 min
🔍What are Reference Styles?
Learn the difference between A1 and R1C1 reference styles in Excel and how to switch between them using the Excel Options menu.