In this 1-hour class, we look at the awesome power of What-If Analysis in Excel.

What If Analysis in Excel allows you to test out different scenarios without complex formulas. In this tutorial we cover Goal Seek, Scenario Manager, Data Tables, and Solver. Once again, this class was hosted by the excellent Deborah Ashby for Simon Sez IT.

*GET FOUR FREE COURSES ️ https://www.simonsezit.com/four-free-courses/

In this What-If Analysis tutorial, we teach you:

- What is WhatIf Analysis and why is it useful?
- The PMT function
- Three examples of Goal Seek in Excel
- How to work with Scenario Manager
- How to create a one-variable Data Table
- How to create a two-variable Data Table
- Introduction to the Solver add-in

To get the Excel file used in this video and follow along, go here: https://www.simonsezit.com/article/what-if-analysis-in-excel-excel-live-class/

This is a recording of a live training session held for Simon Sez IT members: https://www.simonsezit.com/membership/

To see more, free Advanced Excel tutorials, take a look at this 4.5 hour YouTube course: https://youtu.be/gjfjn8Lwa28

Get unlimited training with Simon Sez IT’s 150+ courses ⏩ https://www.simonsezit.com/courses/

Level up your skills with a free 30 day trial to our complete training library of 8,500+ videos ⏩ https://www.simonsezit.com/ssit-first-month-free

Check out our Excel 2021 tutorials for beginners playlist here
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jqRlmIaj6jb_X9EGQueMDb

Check out our FREE 300+ hour training course playlist here ️
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

Watch more popular tutorials from Simon Sez IT:

Microsoft Office 2021 and Office 365 Training Tutorials playlist
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j

Microsoft Office 2019 Training Tutorials for Beginners playlist
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3i2OE0G9fSMaVjcW4qi_z_7

PivotTable training here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3iJ5hWG_iZuIvFvnuJJ-mtc

Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining
LinkedIn: https://www.linkedin.com/company/simon-sez-it/

Subscribe to our channel:
https://www.youtube.com/simonsezittraining?sub_confirmation=1

If you enjoyed the video, please give a "thumbs up" and subscribe to the channel ;-)