What-If Analysis (Goal Seek, Scenario Manager, Data Tables) - 1-hour Excel Tutorial
ฝัง
- เผยแพร่เมื่อ 24 มิ.ย. 2024
- 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 ➡️ www.simonsezit.com/four-free-...
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: 👉www.simonsezit.com/article/wh...
✅This is a recording of a live training session held for Simon Sez IT members: 👉www.simonsezit.com/membership/
✅To see more, free Advanced Excel tutorials, take a look at this 4.5 hour TH-cam course: 👉 • Advanced Excel Tutoria...
🌍 Get unlimited training with Simon Sez IT’s 150+ courses ⏩ www.simonsezit.com/courses/
🚀 Level up your skills with a free 30 day trial to our complete training library of 8,500+ videos ⏩ www.simonsezit.com/ssit-first...
Check out our Excel 2021 tutorials for beginners playlist here
✅ • Excel 2021/365 Trainin...
Check out our FREE 300+ hour training course playlist here ➡️
🔥 • Simon Sez IT Long Trai...
💻Watch more popular tutorials from Simon Sez IT:
✅Microsoft Office 2021 and Office 365 Training Tutorials playlist
👉 • Microsoft Office 2021 ...
✅Microsoft Office 2019 Training Tutorials for Beginners playlist
👉 • Microsoft Office 2019 ...
✅ PivotTable training here 👉 • Pivot Tables - All you...
💬Stay in touch!
✅SimonSezIT.com: 👉www.SimonSezIT.com/
✅StreamSkill.com: 👉StreamSkill.com/
✅TH-cam Channel: 👉 / simonsezittraining
✅LinkedIn: 👉 / simon-sez-it
🔔Subscribe to our channel:
th-cam.com/users/simonsezittra...
If you enjoyed the video, please give a "thumbs up" and subscribe to the channel 👍🏽 ;-) - วิทยาศาสตร์และเทคโนโลยี
Used these functions a lot when doing blends in chemistry work . Saved time and I could include results in reports. Thanks!
Fantastic Deb. Thanks for the knowledge
Deb, you are terrific, I have learned a ton from you. Thank you!!!
You are so welcome!
A big thank you Deb. This has been so insightful for me.
I’m so happy to hear that!
I'm so much in love with this content, quick, informative and straight to the point. Thanks a lot!👏
You're welcome and thank you as well!
My favorite English teacher, Deb.
I learned a lot from this. Thanks!!
Happy to help Jenny
Thanks Deb. I find your voice calming and I can actually concentrate. Amazing video!
Thank you so much for your kind words! I'm glad my voice helps you concentrate. 😊
🔥Check out our FREE 300+ hour training course playlist here 👉
th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
thank you for the video. really appreciate your effort
My pleasure!
I love your clarity. Thank you a bunch
You are so welcome!
Glad you enjoyed it. Thanks for watching! 🙂
We have additional free tutorials for various data analysis tools and services here 👉
th-cam.com/play/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
TH-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► th-cam.com/users/simonsezittraining
♥️ We appreciate your support!
Really thanks for your excel sharing . I am looking for seeing more your useful excel sharing from Myanmar.
Thank you so much for your efforts, it was really useful.
Thanks!
Thank you for a wonderful enjoyable session of Excel!
You're very welcome! Thanks for the nice comments :-)
This is so helpful. Thank you Deb. Thanks Adam.
You are very welcome! Thanks for watching 😊
thank you so much ,it was really useful
You are welcome Sandhya!
Thank you for a great lesson. Thank you.
You bet!
Thanks a lot for this video. I was just having problems with such issue. It helped me. Thank you.
You're welcome!
Thank you very much. great work
You are welcome!
This is really awesome, What-if analysis so simplified indeed.
I'd love more complex tutorial on this
Glad you enjoyed it. Thanks for watching! 🙂
We have additional free tutorials for various data analysis tools and services here 👉
th-cam.com/play/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
TH-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► th-cam.com/users/simonsezittraining
♥️ We appreciate your support!
Thank you Deb Ashby
The best webinar with the best expert in the world
Thank you for your great feedback !
Excellent!
Glad you liked it!
THANKS A TON
Very very useful. Thank you.
Thank you very much!
excellent presentation!
Thank you! Cheers!
big thanks
Thank you very good trainer good explanation
Glad you liked it
great video
This was helpful
Glad you think so! Thanks for leaving as comment ;-)
Hi great video. How do you make solver update automatically when you change a value that is used in the equation, not an input value that you are asking to calculate but a constant that you set manually. How you can get all of the solutions visible that will fulfill the constraints?
Great lesson...one quick question. In the "solver" section - while teaching the constraints, why wouldn't one just remove the price of the ticket from the changing cells choice, instead of putting in a constraint? The way I see it, if you remove the price as a variable by removing that cell from the option of changing cells, you have done the same thing as putting in a constraint. Am I missing something?
Excellent. Please do an in depth video on solver
Thanks Joshua, Delighted to hear you've enjoyed the tutorial and thanks for letting me know what you'd like to see next.
Thank u.. Thank U... thank U
You're most welcome :-)
Do you have any videos on future values and also depreciation?
I was expecting a complex to follow video, however I was pleasantly surprised as it was like following T beginner level, and it was very insightful Good job! THank YOU!!!!
Glad it was helpful! Thanks for dropping by.
@@SimonSezIT if there is part 2 or similar video you could recommend, please do :)
Adam should give you that promotion!, well done thanks
Haha Thank you Graeme!
Deb you are amazing, thanks a lot for that tutorial, but can you provide us with many examples that has a lot of data & has to many constrains related to solver.
Also, for scenario manager, it's only work on cells under 32 !! So if i have a lot of data what we can do.
Thanks!
Thanks so much for your support :-)
Thanks so much! We’re glad you enjoyed the video 😄
Which one is working best for purchasing order comparisons
When do you normally have live webinar?
The live webinars are for our SimonSezIT.com members, which we offer on the 4th Thursday of each month.
anyone else notice the conditional formatting? she said highest number in red, lowest number in blue. However it was the opposite, am i wrong?
Honestly everyone, just learn how to write formulas because it is more useful than these limited functions.
This is a great course.Please share with me your email address,I am interested in Power BI and more advance excel courses
ty