What-If Analysis (Goal Seek, Scenario Manager and Data Table) in Excel | Step by Step tutorial

#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
Our Course of Excel Pivot Tables for Data Analysis: Basic to Advanced:
www.udemy.com/...
Subscribe our new KZbin 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/...

[@__j.s.k__]

Simple, crisp, accurate, to the point!! Best video so far!!

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@dr.j.nelsonraja1026]

Very Useful. Thanks a lot Sir

[@PKAnExcelExpert]

Most welcome🙏

[@shahzadahmed-g6m]

best video. explained very simply.

[@PKAnExcelExpert]

Thanks🙏

[@shahzadahmed-g6m]

Please make a video on Regression analysis in very simple way. I will be thankful to you. @@PKAnExcelExpert

[@bradtavares-vd3hz]

Thank you for simple and concise video.

[@PKAnExcelExpert]

You're welcome!

[@ananyaa9]

Brief and well explained 🫡

[@PKAnExcelExpert]

Thanks🙏

[@ธัชภรณ์สัทธาพงศ์]

Well-explaind and on point.Thank you very much.

[@PKAnExcelExpert]

Most welcome🎉

[@hanabihaku8732]

Wonderful and simple example! Thank you!

[@PKAnExcelExpert]

Most welcome🙏

[@sehanathukorala4537]

highly recommend this video. thank you so much, PK for your explanation.

[@jordankopal1412]

This is so cool, What-If Analysis.

[@PKAnExcelExpert]

Thanks

[@muskanyadav10]

So simply you explan.👍

[@PKAnExcelExpert]

Glad you think so!

[@the.defining.light4]

You are very good teacher thank you I understood perfectly well

[@PKAnExcelExpert]

My pleasure

[@C1T-g9j]

Super, thank you!!

[@PKAnExcelExpert]

Most welcome

[@bisetwalle]

the best video that I have ever seen in my life

[@NimmiPandey333]

This is perfect video for what -if analysis.

[@PKAnExcelExpert]

Thanks 🙏

[@LakshansanjeewaMunasingha]

Best explanation about what if analysis From sri lanka

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@christnhvv256]

you are a great teacher!!! thx

[@PKAnExcelExpert]

Most welcome

[@pinkyshroff3436]

Ur videos are good and easy to grasp

[@PKAnExcelExpert]

Thanks 🙏

[@saaddiouri5620]

Good job, I really enjoyed learning how to use the What-if-analysis!

[@PKAnExcelExpert]

Glad it was helpful!

[@AyushKumar-fi5tj]

Legends for IT exam

[@Lanylor9]

So true especially for practicals

[@aiswaryasubash7821]

Very helpful. Thank you 😊

[@PKAnExcelExpert]

Glad it was helpful!

[@relax9286]

Winning with PK! Thank you!

[@PKAnExcelExpert]

Most welcome

[@bat-orgilenkh-amgalan6631]

So insightful, thanks dude!

[@PKAnExcelExpert]

Most welcome

[@dbsarv5588]

Thank You PK, simplified a complex thing. Nice work.

[@AliAkbar-bf1md]

Excellent! Best of Luck!

[@PKAnExcelExpert]

Thanks 🙏

[@EduKidsZone-pk]

Thanks for kind info

[@PKAnExcelExpert]

Most welcome

[@FiatoDioke]

Thank you so much. Very well explained.

[@PKAnExcelExpert]

Most welcome

[@shivanichawla2156]

Gr8, impressive

[@PKAnExcelExpert]

Thanks🙏

[@ar-5gaminggirl830]

Thank you so much Sir finally samjh me AA gya 👍👍👍👍👍👍👍

[@PKAnExcelExpert]

Most welcome

[@ane3569]

Saved a life, thank you

[@PKAnExcelExpert]

Most welcome

[@sakshammaurya765]

very well explained

[@PKAnExcelExpert]

Thanks🙏

[@SylvesterMarshallPune]

Very nicely explained

[@PKAnExcelExpert]

Thanks

[@nikitachouhan501]

This video helped me alot.Now I perfectly understand the what if analysis.thanx

[@PKAnExcelExpert]

most welcome

[@nsanch0181]

PK thank you so much for sharing that video on What-If-Analysis. I have learned so much from following you.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@soyoyeoluwafunso4586]

Amazing this very good video understood 100%

[@PKAnExcelExpert]

Thanks

[@TheMixedBaggg]

Thank you sir

[@PKAnExcelExpert]

Most welcome

[@dawagyeltshen1784]

It's very easy while you explain... Thankyousomuch

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@AmitKumar-pz7tu]

Amazing I understood 100% Thanks for creating this video

[@PKAnExcelExpert]

You are most welcome

[@mathewvjos315]

U are NXT level bro. Tq

[@PKAnExcelExpert]

It's my pleasure

[@yogeshchaudhari5338]

Nice explanation

[@PKAnExcelExpert]

Thanks for liking

[@saqlainsukhera9757]

Well explained ❤❤

[@PKAnExcelExpert]

Thanks

[@chib_bie]

Very well explained. Thank you

[@PKAnExcelExpert]

Glad it was helpful!

[@shubhamsachdeva6969]

Thank you very much you explained it very well

[@PKAnExcelExpert]

Glad it was helpful!

[@michaelskirde-visuata5742]

Great! Thank you so much for this simple explanation.

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@upbro3881]

SIR YOUR VIDEO HELPED ME A LOT THANKS FOR CLEAR EXPLANATION 🙏🙏💐💐

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@samgaming595]

excellent video!!!!!!!!!

[@PKAnExcelExpert]

Thanks

[@fabriziogazzani9074]

Great !

[@PKAnExcelExpert]

Thanks

[@UDADNAMAS]

Self explanatory. Well delivered message to the point. Thanks.

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@Nowheresssaa]

wow bro much respects

[@PKAnExcelExpert]

Thanks🙏

[@raymondhansen4482]

Thank you!

[@PKAnExcelExpert]

Most welcome

[@sharanyacollections8667]

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....

[@PKAnExcelExpert]

All the best

[@yafu9384]

Thanks this helped with my online course

[@PKAnExcelExpert]

Glad it helped!

[@SMAmericalifestylevlogs]

May I know the online course name ?

[@shehansandeepa8824]

thank you very much. got it easily

[@PKAnExcelExpert]

Most welcome🙏

[@MoinShaikh-i2j]

helpful 👍

[@PKAnExcelExpert]

Thanks

[@AKhan-nu9mw]

Great Sir, it is helpful for me. Thanx

[@PKAnExcelExpert]

Most welcome

[@motivatigyan6417]

Very clear explanation 👍

[@Taksheducation1729]

A lot of love u sir g ❤️❤️❤️🥰🥰🥰

[@PKAnExcelExpert]

Thanks

[@abhishekanand9430]

thanks a lot sir

[@PKAnExcelExpert]

Most welcome

[@ravishjacob]

Very good explanation

[@PKAnExcelExpert]

Thanks🙏

[@aungthuya4276]

thanks

[@PKAnExcelExpert]

Most welcome🙏

[@rj_lab]

Thank you Bro!

[@PKAnExcelExpert]

Most welcome

[@jianie732]

Great one!

[@PKAnExcelExpert]

Thanks!

[@GeorgeAJululian]

Many thanks Sir

[@PKAnExcelExpert]

Most welcome

[@chawdemramprasad9236]

GOOD TRAINING SIR👋

[@PKAnExcelExpert]

Thanks🙏

[@KevinDavid-dx3tq]

Very well explained

[@Jishayaful]

Excellent teaching sir.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@vacilando86]

You are awesome, thanks for simple and valueable tutoriol

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@fulloblivion]

Superb..thank you!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@enringcarmona4301]

@@PKAnExcelExpert 7

[@leahsmith2121]

Very helpful, thank you very much 🙂

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@tajuddinidrisi6610]

Excellent, you better explain what if analysis to me, thanks a lot

[@PKAnExcelExpert]

You are welcome!

[@Srinivas-oe3cj]

Very helpful

[@PKAnExcelExpert]

Glad you think so!

[@kamaleshdeka7443]

Thank you Sir.

[@PKAnExcelExpert]

Most welcome

[@陈明年]

THANK YOU THIS 3 ALWAYS MAK ME HEADACHE

[@zoyeb100]

Nice video sir 👌🏻👍🏻 . Thank you

[@PKAnExcelExpert]

Most welcome

[@starfish258852]

Thank you :)

[@PKAnExcelExpert]

You're welcome!

[@rahulshewale9206]

Thank you so much for video

[@PKAnExcelExpert]

Most welcome

[@munsurmohammadarafatkhan3391]

A simplified way for easy explanation. Thank u. would be more greatful if u can loose the music too. Love from Bangladesh

[@nessim.liamani]

Thanks

[@PKAnExcelExpert]

Most welcome🙏

[@BertandRussell]

Namaskaar Sir, You are just great...Too good, just too good. Thanks and blessing for all your efforts... Thanks a lot Sir, love you....

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@pratyakshsaxena7420]

Thank you so much

[@PKAnExcelExpert]

You're most welcome

[@moubarakhalidou6418]

you are just incredible. Sir

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@izzetyarar9542]

Thank you so much I have found out what I had been looking for ..

[@MohammedIslamElshiekhElsmani]

Interesting!!

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@Tobii_iz]

2:00 Scenario Manager 7:00 Goal Seek 10:00 Data Table

[@AbhishekSingh-wo7fk]

Very helpful 👍

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@jianie732]

great！！！

[@PKAnExcelExpert]

Thanks🙏

[@madukes5474]

Thank you so much for sharing. Excellent examples.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@easy4u00]

very well explained!! thank you so much :)

[@Kushalpaudel7]

Nice video

[@PKAnExcelExpert]

Thanks

[@reethumartin3379]

Thank u...

[@PKAnExcelExpert]

Welcome

[@joephoffmann4294]

ty sir!

[@Sandeesh_Srikantam]

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.

[@aman1245singh]

Thanks buddy

[@PKAnExcelExpert]

Most welcome🙏

[@irfanjulianto3556]

Thx Sir....

[@PKAnExcelExpert]

Most welcome

[@Satoru_Gojo-w9d]

at 9:04 u said 500 dollar but u entered 5000 dollars

[@jongjin311]

Many thanks for clear explanation! What sould I do if I want to see multiple result cells in senario summary??

[@narendranegipoetry3253]

Hi PK, could you make a video roster vs Attendance center wise

[@rabinkhatri9550]

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?

[@bhoopalani7256]

When we have simple formulas to achieve the same, what's the need for what-if analysis?

[@Icelander01]

How to use data table in wps offfice ? Any idea??

[@saideepthidigavinti6831]

If we are doing data for multiple columns then how to proceed in row input and column inpuy