Microsoft Excel: What-If Analysis (Goal Seek & Scenarios)

Wishlist Share

About Course

Excel’s What-If Analysis tools let you test “what happens if” questions without rebuilding your spreadsheet. This course covers Goal Seek, Scenario Manager and data tables, with a break-even worked example and guidance on when to use Solver instead.

This course is general training. Menu names and features can differ between Excel for Microsoft 365, Excel 2021/2024, older versions, Mac and Excel for the web, so check Microsoft Support for your version. Tutwoo is independent and not affiliated with Microsoft. Worked examples are illustrations, not financial advice.

What Will You Learn?

  • Use Goal Seek to work backwards from a target result Save and compare best, expected and worst cases with Scenario Manager Build one- and two-variable data tables Choose the right what-if tool and avoid common set-up mistakes

Course Content

Course Lessons

  • Setting up a model for what-if analysis
  • Goal Seek: working backwards
  • Scenario Manager: comparing cases
  • Data tables and choosing the right tool

Sources & Further Reading
The official guidance this course is based on.

Final Assessment

Student Ratings & Reviews

No Review Yet
No Review Yet

Want to receive push notifications for all major on-site activities?

✕