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🙏

[@AyushKumar-fi5tj]

Legends for IT exam

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

[@LakshansanjeewaMunasingha]

Best explanation about what if analysis From sri lanka

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@NimmiPandey333]

This is perfect video for what -if analysis.

[@PKAnExcelExpert]

Thanks 🙏

[@jordankopal1412]

This is so cool, What-If Analysis.

[@PKAnExcelExpert]

Thanks

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

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

[@PKAnExcelExpert]

Most welcome🎉

[@hanabihaku8732]

Wonderful and simple example! Thank you!

[@PKAnExcelExpert]

Most welcome🙏

[@ananyaa9]

Brief and well explained 🫡

[@PKAnExcelExpert]

Thanks🙏

[@bradtavares-vd3hz]

Thank you for simple and concise video.

[@PKAnExcelExpert]

You're welcome!

[@the.defining.light4]

You are very good teacher thank you I understood perfectly well

[@PKAnExcelExpert]

My pleasure

[@muskanyadav10]

So simply you explan.👍

[@PKAnExcelExpert]

Glad you think so!

[@saaddiouri5620]

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

[@PKAnExcelExpert]

Glad it was helpful!

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

[@dbsarv5588]

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

[@dr.j.nelsonraja1026]

Very Useful. Thanks a lot Sir

[@PKAnExcelExpert]

Most welcome🙏

[@ar-5gaminggirl830]

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

[@PKAnExcelExpert]

Most welcome

[@EduKidsZone-pk]

Thanks for kind info

[@PKAnExcelExpert]

Most welcome

[@relax9286]

Winning with PK! Thank you!

[@PKAnExcelExpert]

Most welcome

[@nikitachouhan501]

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

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

[@christnhvv256]

you are a great teacher!!! thx

[@PKAnExcelExpert]

Most welcome

[@FiatoDioke]

Thank you so much. Very well explained.

[@PKAnExcelExpert]

Most welcome

[@bat-orgilenkh-amgalan6631]

So insightful, thanks dude!

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

[@shivanichawla2156]

Gr8, impressive

[@PKAnExcelExpert]

Thanks🙏

[@ane3569]

Saved a life, thank you

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

[@aiswaryasubash7821]

Very helpful. Thank you 😊

[@PKAnExcelExpert]

Glad it was helpful!

[@AliAkbar-bf1md]

Excellent! Best of Luck!

[@PKAnExcelExpert]

Thanks 🙏

[@TheMixedBaggg]

Thank you sir

[@PKAnExcelExpert]

Most welcome

[@shubhamsachdeva6969]

Thank you very much you explained it very well

[@PKAnExcelExpert]

Glad it was helpful!

[@soyoyeoluwafunso4586]

Amazing this very good video understood 100%

[@PKAnExcelExpert]

Thanks

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

[@mathewvjos315]

U are NXT level bro. Tq

[@PKAnExcelExpert]

It's my pleasure

[@Tobii_iz]

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

[@SylvesterMarshallPune]

Very nicely explained

[@PKAnExcelExpert]

Thanks

[@yafu9384]

Thanks this helped with my online course

[@PKAnExcelExpert]

Glad it helped!

[@SMAmericalifestylevlogs]

May I know the online course name ?

[@UDADNAMAS]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@saqlainsukhera9757]

Well explained ❤❤

[@PKAnExcelExpert]

Thanks

[@sakshammaurya765]

very well explained

[@PKAnExcelExpert]

Thanks🙏

[@upbro3881]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@chib_bie]

Very well explained. Thank you

[@PKAnExcelExpert]

Glad it was helpful!

[@michaelskirde-visuata5742]

Great! Thank you so much for this simple explanation.

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@motivatigyan6417]

Very clear explanation 👍

[@samgaming595]

excellent video!!!!!!!!!

[@PKAnExcelExpert]

Thanks

[@raymondhansen4482]

Thank you!

[@PKAnExcelExpert]

Most welcome

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

[@shehansandeepa8824]

thank you very much. got it easily

[@PKAnExcelExpert]

Most welcome🙏

[@AKhan-nu9mw]

Great Sir, it is helpful for me. Thanx

[@PKAnExcelExpert]

Most welcome

[@MoinShaikh-i2j]

helpful 👍

[@PKAnExcelExpert]

Thanks

[@yogeshchaudhari5338]

Nice explanation

[@PKAnExcelExpert]

Thanks for liking

[@Jishayaful]

Excellent teaching sir.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Nowheresssaa]

wow bro much respects

[@PKAnExcelExpert]

Thanks🙏

[@abhishekanand9430]

thanks a lot sir

[@PKAnExcelExpert]

Most welcome

[@fabriziogazzani9074]

Great !

[@PKAnExcelExpert]

Thanks

[@KevinDavid-dx3tq]

Very well explained

[@jianie732]

Great one!

[@PKAnExcelExpert]

Thanks!

[@Taksheducation1729]

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

[@PKAnExcelExpert]

Thanks

[@chawdemramprasad9236]

GOOD TRAINING SIR👋

[@PKAnExcelExpert]

Thanks🙏

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

[@leahsmith2121]

Very helpful, thank you very much 🙂

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@fulloblivion]

Superb..thank you!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@enringcarmona4301]

@@PKAnExcelExpert 7

[@vacilando86]

You are awesome, thanks for simple and valueable tutoriol

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@tajuddinidrisi6610]

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

[@PKAnExcelExpert]

You are welcome!

[@saifrashid6713]

Can we drag the Goal seek function?

[@rj_lab]

Thank you Bro!

[@PKAnExcelExpert]

Most welcome

[@jongjin311]

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

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

[@ravishjacob]

Very good explanation

[@PKAnExcelExpert]

Thanks🙏

[@saideepthidigavinti6831]

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

[@GeorgeAJululian]

Many thanks Sir

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

[@Srinivas-oe3cj]

Very helpful

[@PKAnExcelExpert]

Glad you think so!

[@narendranegipoetry3253]

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

[@rahulshewale9206]

Thank you so much for video

[@PKAnExcelExpert]

Most welcome

[@izzetyarar9542]

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

[@madukes5474]

Thank you so much for sharing. Excellent examples.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@moubarakhalidou6418]

you are just incredible. Sir

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@theithouse23]

what is the version of your excel?

[@zoyeb100]

Nice video sir 👌🏻👍🏻 . Thank you

[@PKAnExcelExpert]

Most welcome

[@aungthuya4276]

thanks

[@PKAnExcelExpert]

Most welcome🙏

[@bhoopalani7256]

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

[@hakiki1518]

Is there a goalseek formula instead of pop-up form?

[@陈明年]

THANK YOU THIS 3 ALWAYS MAK ME HEADACHE

[@kamaleshdeka7443]

Thank you Sir.

[@PKAnExcelExpert]

Most welcome

[@starfish258852]

Thank you :)

[@PKAnExcelExpert]

You're welcome!

[@pratyakshsaxena7420]

Thank you so much

[@PKAnExcelExpert]

You're most welcome

[@Singh_Garry]

Which tool you used to edit videos

[@easy4u00]

very well explained!! thank you so much :)

[@AbhishekSingh-wo7fk]

Very helpful 👍

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@maxmudxasan6645]

Hello, sir thanks for ur sacrifice but I need to know how to calculate the item cost. Thanks.

[@sanjandaniel]

Yes can someone please explain how the cost was calculated to 20? Was it missed out being mentioned in a separate row?

[@sohailmukadam3612]

how can you leave an empty cell while putting the value in the dialogue box . it is not accepting my commond

[@brahimeljaidi6229]

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

[@MohammedIslamElshiekhElsmani]

Interesting!!

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@nessim.liamani]

Thanks

[@PKAnExcelExpert]

Most welcome🙏

[@meghanlim926]

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 .

[@Kushalpaudel7]

Nice video

[@PKAnExcelExpert]

Thanks