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

[@__j.s.k__]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@sehanathukorala4537]

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

[@bisetwalle]

the best video that I have ever seen in my life

[@dr.j.nelsonraja1026]

Very Useful. Thanks a lot Sir

[@PKAnExcelExpert]

Most welcome🙏

[@jordankopal1412]

This is so cool, What-If Analysis.

[@PKAnExcelExpert]

Thanks

[@NimmiPandey333]

This is perfect video for what -if analysis.

[@PKAnExcelExpert]

Thanks 🙏

[@ananyaa9]

Brief and well explained 🫡

[@PKAnExcelExpert]

Thanks🙏

[@LakshansanjeewaMunasingha]

Best explanation about what if analysis
From sri lanka

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@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

[@muskanyadav10]

So simply you explan.👍

[@PKAnExcelExpert]

Glad you think so!

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

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

[@PKAnExcelExpert]

Most welcome🎉

[@hanabihaku8732]

Wonderful and simple example! Thank you!

[@PKAnExcelExpert]

Most welcome🙏

[@bradtavares-vd3hz]

Thank you for simple and concise video.

[@PKAnExcelExpert]

You're welcome!

[@saaddiouri5620]

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

[@PKAnExcelExpert]

Glad it was helpful!

[@the.defining.light4]

You are very good teacher thank you I understood perfectly well

[@PKAnExcelExpert]

My pleasure

[@ar-5gaminggirl830]

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

[@PKAnExcelExpert]

Most welcome

[@C1T-g9j]

Super, thank you!!

[@PKAnExcelExpert]

Most welcome

[@relax9286]

Winning with PK! Thank you!

[@PKAnExcelExpert]

Most welcome

[@dbsarv5588]

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

[@pinkyshroff3436]

Ur videos are good and easy to grasp

[@PKAnExcelExpert]

Thanks 🙏

[@shivanichawla2156]

Gr8, impressive

[@PKAnExcelExpert]

Thanks🙏

[@AyushKumar-fi5tj]

Legends for IT exam

[@Lanylor9]

So true especially for practicals

[@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

[@aiswaryasubash7821]

Very helpful. Thank you 😊

[@PKAnExcelExpert]

Glad it was helpful!

[@christnhvv256]

you are a great teacher!!! thx

[@PKAnExcelExpert]

Most welcome

[@EduKidsZone-pk]

Thanks for kind info

[@PKAnExcelExpert]

Most welcome

[@AliAkbar-bf1md]

Excellent! Best of Luck!

[@PKAnExcelExpert]

Thanks 🙏

[@SylvesterMarshallPune]

Very nicely explained

[@PKAnExcelExpert]

Thanks

[@sakshammaurya765]

very well explained

[@PKAnExcelExpert]

Thanks🙏

[@soyoyeoluwafunso4586]

Amazing this very good video understood 100%

[@PKAnExcelExpert]

Thanks

[@ane3569]

Saved a life, thank you

[@PKAnExcelExpert]

Most welcome

[@saqlainsukhera9757]

Well explained ❤❤

[@PKAnExcelExpert]

Thanks

[@samgaming595]

excellent video!!!!!!!!!

[@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

[@bat-orgilenkh-amgalan6631]

So insightful, thanks dude!

[@PKAnExcelExpert]

Most welcome

[@FiatoDioke]

Thank you so much. Very well explained.

[@PKAnExcelExpert]

Most welcome

[@yogeshchaudhari5338]

Nice explanation

[@PKAnExcelExpert]

Thanks for liking

[@mathewvjos315]

U are NXT level bro. Tq

[@PKAnExcelExpert]

It's my pleasure

[@TheMixedBaggg]

Thank you sir

[@PKAnExcelExpert]

Most welcome

[@AmitKumar-pz7tu]

Amazing I understood 100%
Thanks for creating this video

[@PKAnExcelExpert]

You are most welcome

[@dawagyeltshen1784]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@shubhamsachdeva6969]

Thank you very much you explained it very well

[@PKAnExcelExpert]

Glad it was helpful!

[@chib_bie]

Very well explained. Thank you

[@PKAnExcelExpert]

Glad it was helpful!

[@upbro3881]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@michaelskirde-visuata5742]

Great! Thank you so much for this simple explanation.

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@UDADNAMAS]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@Nowheresssaa]

wow bro much respects

[@PKAnExcelExpert]

Thanks🙏

[@MoinShaikh-i2j]

helpful 👍

[@PKAnExcelExpert]

Thanks

[@raymondhansen4482]

Thank you!

[@PKAnExcelExpert]

Most welcome

[@motivatigyan6417]

Very clear explanation 👍

[@shehansandeepa8824]

thank you very much. got it easily

[@PKAnExcelExpert]

Most welcome🙏

[@Taksheducation1729]

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

[@PKAnExcelExpert]

Thanks

[@Tobii_iz]

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

[@yafu9384]

Thanks this helped with my online course

[@PKAnExcelExpert]

Glad it helped!

[@SMAmericalifestylevlogs]

May I know the online course name ?

[@ravishjacob]

Very good explanation

[@PKAnExcelExpert]

Thanks🙏

[@AKhan-nu9mw]

Great Sir, it is helpful for me. Thanx

[@PKAnExcelExpert]

Most welcome

[@fabriziogazzani9074]

Great !

[@PKAnExcelExpert]

Thanks

[@jianie732]

Great one!

[@PKAnExcelExpert]

Thanks!

[@abhishekanand9430]

thanks a lot sir

[@PKAnExcelExpert]

Most welcome

[@Jishayaful]

Excellent teaching sir.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@rj_lab]

Thank you Bro!

[@PKAnExcelExpert]

Most welcome

[@tajuddinidrisi6610]

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

[@PKAnExcelExpert]

You are welcome!

[@KevinDavid-dx3tq]

Very well explained

[@leahsmith2121]

Very helpful, thank you very much 🙂

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@vacilando86]

You are awesome, thanks for simple and valueable tutoriol

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@GeorgeAJululian]

Many thanks Sir

[@PKAnExcelExpert]

Most welcome

[@chawdemramprasad9236]

GOOD TRAINING SIR👋

[@PKAnExcelExpert]

Thanks🙏

[@fulloblivion]

Superb..thank you!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@enringcarmona4301]

@@PKAnExcelExpert 7

[@munsurmohammadarafatkhan3391]

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

[@izzetyarar9542]

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

[@陈明年]

THANK YOU THIS 3 ALWAYS MAK ME HEADACHE

[@zoyeb100]

Nice video sir 👌🏻👍🏻 . Thank you

[@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

[@rahulshewale9206]

Thank you so much for video

[@PKAnExcelExpert]

Most welcome

[@starfish258852]

Thank you :)

[@PKAnExcelExpert]

You're welcome!

[@kamaleshdeka7443]

Thank you Sir.

[@PKAnExcelExpert]

Most welcome

[@moubarakhalidou6418]

you are just incredible. Sir

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@aungthuya4276]

thanks

[@PKAnExcelExpert]

Most welcome🙏

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

[@Srinivas-oe3cj]

Very helpful

[@PKAnExcelExpert]

Glad you think so!

[@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?

[@jongjin311]

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

[@pratyakshsaxena7420]

Thank you so much

[@PKAnExcelExpert]

You're most welcome

[@nessim.liamani]

Thanks

[@PKAnExcelExpert]

Most welcome🙏

[@madukes5474]

Thank you so much for sharing. Excellent examples.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@easy4u00]

very well explained!! thank you so much :)

[@AbhishekSingh-wo7fk]

Very helpful 👍

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@MohammedIslamElshiekhElsmani]

Interesting!!

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@bhoopalani7256]

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

[@saideepthidigavinti6831]

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

[@narendranegipoetry3253]

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

[@Kushalpaudel7]

Nice video

[@PKAnExcelExpert]

Thanks

[@reethumartin3379]

Thank u...

[@PKAnExcelExpert]

Welcome

[@Icelander01]

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

[@jianie732]

great！！！

[@PKAnExcelExpert]

Thanks🙏

[@aman1245singh]

Thanks buddy

[@PKAnExcelExpert]

Most welcome🙏

[@saifrashid6713]

Can we drag the Goal seek function?

[@churchilraj6374]

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

[@irfanjulianto3556]

Thx Sir....

[@PKAnExcelExpert]

Most welcome