Excel WhatIf Analysis with Scenario Manager and Goal Seek

preview_player
Показать описание
Рекомендации по теме
Комментарии
Автор

I've been watching your tutorials in your Excel playlist since the start and as an accountant, so far this one's my favourite!!! You are God-sent!

angelicacauntay
Автор

These are awesome and so easy to follow. I started watching from the beginning just to see what I could learn and I'm addicted!

jessmyers
Автор

Thank you so much you deserve more credit and views .This was part of my project and i liked how you were on point and i was able to focus and catch everything.So glad to have found your video.Keep it up !

Syahininsyirah
Автор

Oh my god! This tutorial is extremely helpful, it helps me totally understand the whole process and the purpose of the funtion. Thank you for making this video!

issacyau
Автор

The video is super clear. In 8 minutes you explained it perfectly. Loved it. I would however not use this functionality in a real use cases, as reality is always more complex and you rarely change only one variable. So I rather set up helper table, where I would include several combinations. I even think that I would be faster in my results. But, as I said: The video is super. Thanks a lot.

nairobi
Автор

It's a very nice and detailed tutorial. You helped me answer my assignments about Goal seek, Data Validation and Look Up. Looking forward for more tutorials that would help me learn into it.

sydneyrochelle
Автор

Goal seek can be very useful, for example, when looking for what the price should be to make a certain profit. Thank you very much! You have a great way of presenting!

elinat
Автор

Thanks so much for your videos!!! I paid $190 for a course and can't understand what they are talking about.. learned more from your free youtube videos!

jacquelinehadid
Автор

Great tutorial. Easy and to the point. Thanks!

hamidmghazi
Автор

this is exactly what i needed, thanks. I have a test today haha

taemi
Автор

This is so I loved it :) love from India <3

urvashibhardwaj
Автор

Great clear explanation. Thank you for posting

lindaoulton
Автор

Thank You for making this easy to understand!!

lesliewinans
Автор

It was indeed helpful and so easy explanation to understand 😅
Thankyou very much, sir😊

tannukumari
Автор

I found after I hit OK in the goal seek it gave me icons. I needed to accect the changes and then double click into the text box, and then hit enter for the sum precalculated. After doing those extra steps it seems to have worked. Thanks for the tutorials!

gracecowden
Автор

wow thank you for the tutorial, very good explanation sir

riyan
Автор

I liked this video very much thank u, love from India

hinduswastika
Автор

Very clear presentation. Never thought Scenario Manager & Goal seek to be so easy. I have a question. The scenario & Goal seek can be worked out for multiple options? - 1. Price change for one product for select months, 2. Qty change for 3 different months, etc?. Thanks

brshankar
Автор

Definitely underused in Excel nice video

Howtoexcelatexcel
Автор

Need relevant examples... Ones that we can relate to. The explanation was helpful! 👌

dipenmodi