And so analysis in Excel allows you to test different scenarios without complex formulas. In this tutorial we cover Goal Search, Scenario Manager, Data Tables, and Solver. Once again, this course was led 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 Search 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 learn more about free advanced Excel tutorials, take a look at this 4.5 hour YouTube course: https://youtu.be/gjfjn8Lwa28
Benefit from unlimited training with Simon Sez IT's 150 courses https://www.simonsezit.com/courses/
Improve your skills with a 30-day free trial of our comprehensive training library of 8,500 videos https://www.simonsezit.com/ssit-first-month-free
Check out our playlist of Excel 2021 tutorials for beginners here
https://www.youtube.com/playlist?listPLzj7TwUeMQ3jqRlmIaj6jb_X9EGQueMDb
Discover our FREE 300 hour training playlist here ️
https://www.youtube.com/playlist?listPLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
Watch more popular tutorials from Simon Sez IT:
Microsoft Office 2021 and Office 365 Training Tutorials Playlist
https://www.youtube.com/playlist?listPLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j
Microsoft Office 2019 Training Tutorials Playlist for Beginners
https://www.youtube.com/playlist?listPLzj7TwUeMQ3i2OE0G9fSMaVjcW4qi_z_7
Pivot Table training here https://www.youtube.com/playlist?listPLzj7TwUeMQ3iJ5hWG_iZuIvFvnuJJ-mtc
Staying 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_confirmation1
If you enjoyed the video, don't hesitate to give a /"thumbs up/" and subscribe to the channel 😉
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
No Comments