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 👉 ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
Glad you enjoyed it. Thanks for watching! 🙂 We have additional free tutorials for various data analysis tools and services here 👉 ruclips.net/p/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2 For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RUclips Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ruclips.net/user/simonsezittraining ♥️ We appreciate your support!
You are so welcome! Glad you enjoyed it. Thanks for watching! 🙂 We have additional free tutorials for various data analysis tools and services here 👉 ruclips.net/p/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2 For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RUclips Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ruclips.net/user/simonsezittraining ♥️ We appreciate your support!
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!!!!
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.
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?
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?
My favorite English teacher, Deb.
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 👉
ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
The best webinar with the best expert in the world
Thank you for your great feedback !
A big thank you Deb. This has been so insightful for me.
I’m so happy to hear that!
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 👉
ruclips.net/p/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
RUclips Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ruclips.net/user/simonsezittraining
♥️ We appreciate your support!
Deb, you are terrific, I have learned a ton from you. Thank you!!!
You are so welcome!
Used these functions a lot when doing blends in chemistry work . Saved time and I could include results in reports. Thanks!
This is so helpful. Thank you Deb. Thanks Adam.
You are very welcome! Thanks for watching 😊
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 👉
ruclips.net/p/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
RUclips Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ruclips.net/user/simonsezittraining
♥️ We appreciate your support!
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!
Fantastic Deb. Thanks for the knowledge
I learned a lot from this. Thanks!!
Happy to help Jenny
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 :)
Thanks a lot for this video. I was just having problems with such issue. It helped me. Thank you.
You're welcome!
Thank you Deb Ashby
Really thanks for your excel sharing . I am looking for seeing more your useful excel sharing from Myanmar.
Thank you for a wonderful enjoyable session of Excel!
You're very welcome! Thanks for the nice comments :-)
Very very useful. Thank you.
Thank you very much!
Excellent!
Glad you liked it!
thank you so much ,it was really useful
You are welcome Sandhya!
Thank you so much for your efforts, it was really useful.
Thanks!
thank you for the video. really appreciate your effort
My pleasure!
Thanks!
Thanks so much for your support :-)
Thanks so much! We’re glad you enjoyed the video 😄
Thank u.. Thank U... thank U
You're most welcome :-)
Thank you very much. great work
You are welcome!
Thank you for a great lesson. Thank you.
You bet!
Adam should give you that promotion!, well done thanks
Haha Thank you Graeme!
THANKS A TON
This was helpful
Glad you think so! Thanks for leaving as comment ;-)
excellent presentation!
Thank you! Cheers!
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.
great video
big thanks
Thank you very good trainer good explanation
Glad you liked it
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.
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?
Which one is working best for purchasing order comparisons
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?
Do you have any videos on future values and also depreciation?
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.
Honestly everyone, just learn how to write formulas because it is more useful than these limited functions.
anyone else notice the conditional formatting? she said highest number in red, lowest number in blue. However it was the opposite, am i wrong?
ty
This is a great course.Please share with me your email address,I am interested in Power BI and more advance excel courses