🔍
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 110 min
Doing More with PivotTables
Learn how to perform deeper analysis with PivotTables by filtering, grouping, and refreshing summarized data.
âś” Includes Practice File
Lesson 235 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 310 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.