Getting Started with Excel What-If Analysis

About this course

Build a solid foundation in excel what-if analysis from scratch.

• 5 lessons
• 30 min
• beginner

What you'll learn

• Define What-If Analysis and explain its role in spreadsheet modeling
• Identify common business scenarios where What-If Analysis adds value
• Recognize the three built-in Excel tools and their basic differences
• Explain how Goal Seek differs from other What-If tools by taking a result and finding the input
• Set up and run a Goal Seek analysis using the Data tab
• Interpret the results and apply Goal Seek to a practical business example

Finishing the course

• 20 knowledge-check questions along the way, so you know the ideas stuck before you move on.
• Watching is free and needs no account. Sign in to save your progress. Pass each lesson's quiz (60%+) to earn the certificate. Each certificate has its own public verification link to share, marked quiz-verified.

Created by