What-If Analysis (Goal Seek, Scenario Manager and Data Table) in Excel | Step by Step tutorial
HTML-код
- Опубликовано: 4 окт 2024
- #WhatIfAnalysis #GoalSeek
Hello Friends,
In this video, You will learn about What-If Analysis in Microsoft Excel. You can use several different sets of values in one or more formulas to explore all the various results using What-If Analysis.
There 3 types of What-If Analysis tool in Excel-
1. Scenario Manager
2. Goal Seek
3. Data Table
Subscribe our new RUclips Channel:
/ @neotechnavigators
Watch the Step by Step tutorial for Project Plan (Gantt Chart) in Excel
• Project Plan(Gantt Cha...
Download the practice files from below given link:
www.pk-anexcel...
Download the Free Project Management Dashboard
www.pk-anexcel...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcel...
See our Excel Products:
www.pk-anexcel...
Visit to learn more:
Chart and Visualizations: www.pk-anexcel...
VBA Course: www.pk-anexcel...
Download useful Templates: www.pk-anexcel...
Dashboards: www.pk-anexcel...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
WWW.PK-AnExcel...
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/...
Pinterest:
/ pkanexcelexpert
Visit our Amazon Store
www.amazon.in/...
Legends for IT exam
Simple, crisp, accurate, to the point!! Best video so far!!
Thanks for your valuable feedback🙏
the best video that I have ever seen in my life
This is so cool, What-If Analysis.
Thanks
PK thank you so much for sharing that video on What-If-Analysis. I have learned so much from following you.
Thanks for your valuable feedback
highly recommend this video. thank you so much, PK for your explanation.
This is perfect video for what -if analysis.
Thanks 🙏
Good job, I really enjoyed learning how to use the What-if-analysis!
Glad it was helpful!
Well-explaind and on point.Thank you very much.
Most welcome🎉
Wonderful and simple example! Thank you!
Most welcome🙏
You are very good teacher thank you I understood perfectly well
My pleasure
Brief and well explained 🫡
Thanks🙏
Thank you for simple and concise video.
You're welcome!
This video helped me alot.Now I perfectly understand the what if analysis.thanx
most welcome
Thank You PK, simplified a complex thing. Nice work.
SIR YOUR VIDEO HELPED ME A LOT THANKS FOR CLEAR EXPLANATION 🙏🙏💐💐
Thanks for your valuable feedback
Great! Thank you so much for this simple explanation.
Thanks for your valuable feedback🙏
It's very easy while you explain...
Thankyousomuch
Thanks for your valuable feedback
So simply you explan.👍
Glad you think so!
Taq sooo much sir ....I'm joining in an institute.. there only said in what-if analysis in goal seek .But I learned here in your video all sir .Taq tnq soo much sir....
All the best
Thank you so much Sir finally samjh me AA gya 👍👍👍👍👍👍👍
Most welcome
best video. explained very simply.
Thanks🙏
Please make a video on Regression analysis in very simple way. I will be thankful to you.
@@PKAnExcelExpert
Thank you so much. Very well explained.
Most welcome
Amazing this very good video understood 100%
Thanks
Hi sir can we manipulate multiple cells in single scenario run?
For example, if we are assuming best case scenario and sales price we are expecting 1.1 and per unit cost is .9?
Self explanatory. Well delivered message to the point.
Thanks.
Thanks for your valuable feedback🙏
Very Useful. Thanks a lot Sir
Most welcome🙏
you are a great teacher!!! thx
Most welcome
Thank you very much you explained it very well
Glad it was helpful!
Winning with PK! Thank you!
Most welcome
Gr8, impressive
Thanks🙏
Amazing ! I liked the Data table the most, and i wonder if it’s values change dynamically when we change the values in the main table.
Excellent! Best of Luck!
Thanks 🙏
So insightful, thanks dude!
Most welcome
A simplified way for easy explanation. Thank u. would be more greatful if u can loose the music too. Love from Bangladesh
Saved a life, thank you
Most welcome
very well explained
Thanks🙏
Very nicely explained
Thanks
Thanks this helped with my online course
Glad it helped!
May I know the online course name ?
Very helpful. Thank you 😊
Glad it was helpful!
excellent video!!!!!!!!!
Thanks
You are awesome, thanks for simple and valueable tutoriol
Thanks for your valuable feedback
Nice explanation
Thanks for liking
Amazing I understood 100%
Thanks for creating this video
You are most welcome
Very well explained. Thank you
Glad it was helpful!
U are NXT level bro. Tq
It's my pleasure
thank you very much. got it easily
Most welcome🙏
thanks
Most welcome🙏
Very clear explanation 👍
Well explained ❤❤
Thanks
Great Sir, it is helpful for me. Thanx
Most welcome
Thank you!
Most welcome
Excellent teaching sir.
Thanks for your valuable feedback
Many thanks Sir
Most welcome
Hi PK, could you make a video roster vs Attendance center wise
Very good explanation
Thanks🙏
helpful 👍
Thanks
thanks a lot sir
Most welcome
Many thanks for clear explanation! What sould I do if I want to see multiple result cells in senario summary??
Hi, I have tried Data Table 12.17 time example , Data Table if i am selecting your same excel coming $880 not changing the profit .Kindly let me know why it is not changing with same quantity as you given
Very helpful, thank you very much 🙂
Thanks for your valuable feedback🙏
Excellent, you better explain what if analysis to me, thanks a lot
You are welcome!
Thank you so much I have found out what I had been looking for ..
Thank you so much
Most welcome
Great !
Thanks
Thank you so much for sharing. Excellent examples.
Thanks for your valuable feedback
Namaskaar Sir,
You are just great...Too good, just too good.
Thanks and blessing for all your efforts...
Thanks a lot Sir, love you....
Thanks for your valuable feedback
GOOD TRAINING SIR👋
Thanks🙏
Thank you so much for video
Most welcome
THANK YOU THIS 3 ALWAYS MAK ME HEADACHE
wow bro much respects
Thanks🙏
A lot of love u sir g ❤️❤️❤️🥰🥰🥰
Thanks
Hello to all; I thank you for your clarity it is really very rich
I am a student and I am working on my final year project, I am working on the opportunity of adopting "economic xx" policies in a context of crisis.
I seek through this subject to study on the one hand the performance of these policies and on the other hand predict its adoption in Morocco
I would like to know, can I use this method of waht if style to analyze the said subject?
I would like to know if I can use this waht if method to analyze the subject?
I need your help
Thank you very much for you and for all
Brahim el jaidi
Thanks
Most welcome🙏
Very well explained
Superb..thank you!!
Thanks for your valuable feedback
@@PKAnExcelExpert 7
Thank you :)
You're welcome!
you are just incredible. Sir
Thanks for your valuable feedback
very well explained!! thank you so much :)
Thank you Bro!
Most welcome
Thank you Sir.
Most welcome
If we are doing data for multiple columns then how to proceed in row input and column inpuy
Hi KP, I do not the think for “ data table “ work sheet is working . I try it , the outcome for profit stay the same as original qty even qty is charging. Anyway, appreciated your job to teach us .
Very helpful
Glad you think so!
Hello,
sir thanks for ur sacrifice but I need to know how to calculate the item cost.
Thanks.
Yes can someone please explain how the cost was calculated to 20? Was it missed out being mentioned in a separate row?
When we have simple formulas to achieve the same, what's the need for what-if analysis?
Great one!
Thanks!
Can we drag the Goal seek function?
Thanks for your lessons pls could you increase on . modern forms in vba
Is there a goalseek formula instead of pop-up form?
Very helpful 👍
Thanks for your valuable feedback
Which tool you used to edit videos
Thank u...
Welcome
Nice video
Thanks
what is the version of your excel?
Interesting!!
Thanks for your valuable feedback🙏
great!!!
Thanks🙏
Nice video sir 👌🏻👍🏻 . Thank you
Most welcome
Thx Sir....
Most welcome
sir aapki ye expensive low quality MERCHANDISE kaun khareedta h?