Тёмный
No video :(

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

PK: An Excel Expert
Подписаться 274 тыс.
Просмотров 388 тыс.
50% 1

Опубликовано:

 

21 авг 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 204   
@jordankopal1412
@jordankopal1412 6 дней назад
This is so cool, What-If Analysis.
@PKAnExcelExpert
@PKAnExcelExpert 4 дня назад
Thanks
@__j.s.k__
@__j.s.k__ Год назад
Simple, crisp, accurate, to the point!! Best video so far!!
@PKAnExcelExpert
@PKAnExcelExpert Год назад
Thanks for your valuable feedback🙏
@AyushKumar-fi5tj
@AyushKumar-fi5tj 5 месяцев назад
Legends for IT exam
@PragatiPandey050
@PragatiPandey050 20 дней назад
This is perfect video for what -if analysis.
@PKAnExcelExpert
@PKAnExcelExpert 20 дней назад
Thanks 🙏
@sehanathukorala4537
@sehanathukorala4537 9 месяцев назад
highly recommend this video. thank you so much, PK for your explanation.
@nsanch0181
@nsanch0181 3 года назад
PK thank you so much for sharing that video on What-If-Analysis. I have learned so much from following you.
@PKAnExcelExpert
@PKAnExcelExpert 3 года назад
Thanks for your valuable feedback
@saaddiouri5620
@saaddiouri5620 2 года назад
Good job, I really enjoyed learning how to use the What-if-analysis!
@PKAnExcelExpert
@PKAnExcelExpert 2 года назад
Glad it was helpful!
@hanabihaku8732
@hanabihaku8732 10 месяцев назад
Wonderful and simple example! Thank you!
@PKAnExcelExpert
@PKAnExcelExpert 10 месяцев назад
Most welcome🙏
@user-lw1nv8fr4k
@user-lw1nv8fr4k 8 месяцев назад
Well-explaind and on point.Thank you very much.
@PKAnExcelExpert
@PKAnExcelExpert 8 месяцев назад
Most welcome🎉
@muskanyadav10
@muskanyadav10 5 месяцев назад
So simply you explan.👍
@PKAnExcelExpert
@PKAnExcelExpert 5 месяцев назад
Glad you think so!
@bradtavares-vd3hz
@bradtavares-vd3hz 10 месяцев назад
Thank you for simple and concise video.
@PKAnExcelExpert
@PKAnExcelExpert 10 месяцев назад
You're welcome!
@ananyaa9
@ananyaa9 8 месяцев назад
Brief and well explained 🫡
@PKAnExcelExpert
@PKAnExcelExpert 8 месяцев назад
Thanks🙏
@AliAkbar-bf1md
@AliAkbar-bf1md Месяц назад
Excellent! Best of Luck!
@PKAnExcelExpert
@PKAnExcelExpert Месяц назад
Thanks 🙏
@ar-5gaminggirl830
@ar-5gaminggirl830 6 месяцев назад
Thank you so much Sir finally samjh me AA gya 👍👍👍👍👍👍👍
@PKAnExcelExpert
@PKAnExcelExpert 6 месяцев назад
Most welcome
@soyoyeoluwafunso4586
@soyoyeoluwafunso4586 Месяц назад
Amazing this very good video understood 100%
@PKAnExcelExpert
@PKAnExcelExpert Месяц назад
Thanks
@AmitKumar-pz7tu
@AmitKumar-pz7tu Месяц назад
Amazing I understood 100% Thanks for creating this video
@PKAnExcelExpert
@PKAnExcelExpert Месяц назад
You are most welcome
@atorsamuel4
@atorsamuel4 6 месяцев назад
You are very good teacher thank you I understood perfectly well
@PKAnExcelExpert
@PKAnExcelExpert 6 месяцев назад
My pleasure
@relax9286
@relax9286 2 года назад
Winning with PK! Thank you!
@PKAnExcelExpert
@PKAnExcelExpert 2 года назад
Most welcome
@sharanyacollections8667
@sharanyacollections8667 2 года назад
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
@PKAnExcelExpert 2 года назад
All the best
@nikitachouhan501
@nikitachouhan501 2 года назад
This video helped me alot.Now I perfectly understand the what if analysis.thanx
@PKAnExcelExpert
@PKAnExcelExpert 2 года назад
most welcome
@samgaming595
@samgaming595 7 месяцев назад
excellent video!!!!!!!!!
@PKAnExcelExpert
@PKAnExcelExpert 7 месяцев назад
Thanks
@user-go1ec3wf2r
@user-go1ec3wf2r 8 месяцев назад
best video. explained very simply.
@PKAnExcelExpert
@PKAnExcelExpert 8 месяцев назад
Thanks🙏
@user-go1ec3wf2r
@user-go1ec3wf2r 8 месяцев назад
Please make a video on Regression analysis in very simple way. I will be thankful to you. @@PKAnExcelExpert
@user-zf9cz5jk4r
@user-zf9cz5jk4r 4 месяца назад
Thank you so much. Very well explained.
@PKAnExcelExpert
@PKAnExcelExpert 4 месяца назад
Most welcome
@dbsarv5588
@dbsarv5588 2 года назад
Thank You PK, simplified a complex thing. Nice work.
@christnhvv256
@christnhvv256 5 месяцев назад
you are a great teacher!!! thx
@PKAnExcelExpert
@PKAnExcelExpert 5 месяцев назад
Most welcome
@shivanichawla2156
@shivanichawla2156 Год назад
Gr8, impressive
@PKAnExcelExpert
@PKAnExcelExpert Год назад
Thanks🙏
@upbro3881
@upbro3881 2 года назад
SIR YOUR VIDEO HELPED ME A LOT THANKS FOR CLEAR EXPLANATION 🙏🙏💐💐
@PKAnExcelExpert
@PKAnExcelExpert 2 года назад
Thanks for your valuable feedback
@dr.j.nelsonraja1026
@dr.j.nelsonraja1026 11 месяцев назад
Very Useful. Thanks a lot Sir
@PKAnExcelExpert
@PKAnExcelExpert 11 месяцев назад
Most welcome🙏
@ane3569
@ane3569 6 месяцев назад
Saved a life, thank you
@PKAnExcelExpert
@PKAnExcelExpert 6 месяцев назад
Most welcome
@dawagyeltshen1784
@dawagyeltshen1784 2 года назад
It's very easy while you explain... Thankyousomuch
@PKAnExcelExpert
@PKAnExcelExpert 2 года назад
Thanks for your valuable feedback
@BertandRussell
@BertandRussell 3 года назад
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
@PKAnExcelExpert 3 года назад
Thanks for your valuable feedback
@UDADNAMAS
@UDADNAMAS Год назад
Self explanatory. Well delivered message to the point. Thanks.
@PKAnExcelExpert
@PKAnExcelExpert Год назад
Thanks for your valuable feedback🙏
@michaelskirde-visuata5742
@michaelskirde-visuata5742 2 года назад
Great! Thank you so much for this simple explanation.
@PKAnExcelExpert
@PKAnExcelExpert 2 года назад
Thanks for your valuable feedback🙏
@SylvesterMarshallPune
@SylvesterMarshallPune 5 месяцев назад
Very nicely explained
@PKAnExcelExpert
@PKAnExcelExpert 5 месяцев назад
Thanks
@aiswaryasubash7821
@aiswaryasubash7821 9 месяцев назад
Very helpful. Thank you 😊
@PKAnExcelExpert
@PKAnExcelExpert 9 месяцев назад
Glad it was helpful!
@sakshammaurya765
@sakshammaurya765 10 месяцев назад
very well explained
@PKAnExcelExpert
@PKAnExcelExpert 10 месяцев назад
Thanks🙏
@shubhamsachdeva6969
@shubhamsachdeva6969 Год назад
Thank you very much you explained it very well
@PKAnExcelExpert
@PKAnExcelExpert Год назад
Glad it was helpful!
@raymondhansen4482
@raymondhansen4482 3 месяца назад
Thank you!
@PKAnExcelExpert
@PKAnExcelExpert 3 месяца назад
Most welcome
@fabriziogazzani9074
@fabriziogazzani9074 6 месяцев назад
Great !
@PKAnExcelExpert
@PKAnExcelExpert 6 месяцев назад
Thanks
@mathewvjos315
@mathewvjos315 Год назад
U are NXT level bro. Tq
@PKAnExcelExpert
@PKAnExcelExpert Год назад
It's my pleasure
@saqlainsukhera9757
@saqlainsukhera9757 5 месяцев назад
Well explained ❤❤
@PKAnExcelExpert
@PKAnExcelExpert 5 месяцев назад
Thanks
@aungthuya4276
@aungthuya4276 Год назад
thanks
@PKAnExcelExpert
@PKAnExcelExpert Год назад
Most welcome🙏
@yafu9384
@yafu9384 2 года назад
Thanks this helped with my online course
@PKAnExcelExpert
@PKAnExcelExpert 2 года назад
Glad it helped!
@SMAmericalifestylevlogs
@SMAmericalifestylevlogs Год назад
May I know the online course name ?
@chibogwuononye8644
@chibogwuononye8644 Год назад
Very well explained. Thank you
@PKAnExcelExpert
@PKAnExcelExpert Год назад
Glad it was helpful!
@user-bt7tc6rh7n
@user-bt7tc6rh7n 3 месяца назад
helpful 👍
@PKAnExcelExpert
@PKAnExcelExpert 3 месяца назад
Thanks
@yogeshchaudhari5338
@yogeshchaudhari5338 9 месяцев назад
Nice explanation
@PKAnExcelExpert
@PKAnExcelExpert 9 месяцев назад
Thanks for liking
@rabinkhatri9550
@rabinkhatri9550 3 года назад
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?
@munsurmohammadarafatkhan3391
@munsurmohammadarafatkhan3391 3 месяца назад
A simplified way for easy explanation. Thank u. would be more greatful if u can loose the music too. Love from Bangladesh
@motivatigyan6417
@motivatigyan6417 3 года назад
Very clear explanation 👍
@shehansandeepa8824
@shehansandeepa8824 Год назад
thank you very much. got it easily
@PKAnExcelExpert
@PKAnExcelExpert Год назад
Most welcome🙏
@GeorgeAJululian
@GeorgeAJululian 2 года назад
Many thanks Sir
@PKAnExcelExpert
@PKAnExcelExpert 2 года назад
Most welcome
@oreoluwababatola8551
@oreoluwababatola8551 7 месяцев назад
Thank you so much
@PKAnExcelExpert
@PKAnExcelExpert 7 месяцев назад
Most welcome
@AKhan-nu9mw
@AKhan-nu9mw 2 года назад
Great Sir, it is helpful for me. Thanx
@PKAnExcelExpert
@PKAnExcelExpert 2 года назад
Most welcome
@Sandeesh_Srikantam
@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.
@abhishekanand9430
@abhishekanand9430 9 месяцев назад
thanks a lot sir
@PKAnExcelExpert
@PKAnExcelExpert 9 месяцев назад
Most welcome
@rj_lab
@rj_lab Год назад
Thank you Bro!
@PKAnExcelExpert
@PKAnExcelExpert Год назад
Most welcome
@vacilando86
@vacilando86 3 года назад
You are awesome, thanks for simple and valueable tutoriol
@PKAnExcelExpert
@PKAnExcelExpert 3 года назад
Thanks for your valuable feedback
@Jishayaful
@Jishayaful 3 года назад
Excellent teaching sir.
@PKAnExcelExpert
@PKAnExcelExpert 3 года назад
Thanks for your valuable feedback
@ravishjacob
@ravishjacob 11 месяцев назад
Very good explanation
@PKAnExcelExpert
@PKAnExcelExpert 11 месяцев назад
Thanks🙏
@KevinDavid-dx3tq
@KevinDavid-dx3tq Год назад
Very well explained
@leahsmith2121
@leahsmith2121 2 года назад
Very helpful, thank you very much 🙂
@PKAnExcelExpert
@PKAnExcelExpert 2 года назад
Thanks for your valuable feedback🙏
@tajuddinidrisi6610
@tajuddinidrisi6610 Год назад
Excellent, you better explain what if analysis to me, thanks a lot
@PKAnExcelExpert
@PKAnExcelExpert Год назад
You are welcome!
@samimzemarai9078
@samimzemarai9078 Год назад
wow bro much respects
@PKAnExcelExpert
@PKAnExcelExpert Год назад
Thanks🙏
@nessim.liamani
@nessim.liamani Год назад
Thanks
@PKAnExcelExpert
@PKAnExcelExpert Год назад
Most welcome🙏
@jianie732
@jianie732 Год назад
Great one!
@PKAnExcelExpert
@PKAnExcelExpert Год назад
Thanks!
@ssanonymous1729
@ssanonymous1729 2 года назад
A lot of love u sir g ❤️❤️❤️🥰🥰🥰
@PKAnExcelExpert
@PKAnExcelExpert 2 года назад
Thanks
@chawdemramprasad9236
@chawdemramprasad9236 2 года назад
GOOD TRAINING SIR👋
@PKAnExcelExpert
@PKAnExcelExpert 2 года назад
Thanks🙏
@izzetyarar9542
@izzetyarar9542 3 года назад
Thank you so much I have found out what I had been looking for ..
@starfish258852
@starfish258852 Год назад
Thank you :)
@PKAnExcelExpert
@PKAnExcelExpert Год назад
You're welcome!
@fulloblivion
@fulloblivion 2 года назад
Superb..thank you!!
@PKAnExcelExpert
@PKAnExcelExpert 2 года назад
Thanks for your valuable feedback
@enringcarmona4301
@enringcarmona4301 2 года назад
@@PKAnExcelExpert 7
@user-ot4rp8yn8r
@user-ot4rp8yn8r 2 года назад
THANK YOU THIS 3 ALWAYS MAK ME HEADACHE
@madukes5474
@madukes5474 3 года назад
Thank you so much for sharing. Excellent examples.
@PKAnExcelExpert
@PKAnExcelExpert 3 года назад
Thanks for your valuable feedback
@rahulshewale9206
@rahulshewale9206 3 года назад
Thank you so much for video
@PKAnExcelExpert
@PKAnExcelExpert 3 года назад
Most welcome
@easy4u00
@easy4u00 2 года назад
very well explained!! thank you so much :)
@Srinivas-oe3cj
@Srinivas-oe3cj 2 года назад
Very helpful
@PKAnExcelExpert
@PKAnExcelExpert 2 года назад
Glad you think so!
@kamaleshdeka7443
@kamaleshdeka7443 Год назад
Thank you Sir.
@PKAnExcelExpert
@PKAnExcelExpert Год назад
Most welcome
@moubarakhalidou6418
@moubarakhalidou6418 3 года назад
you are just incredible. Sir
@PKAnExcelExpert
@PKAnExcelExpert 3 года назад
Thanks for your valuable feedback
@churchilraj6374
@churchilraj6374 3 года назад
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
@jianie732
@jianie732 Год назад
great!!!
@PKAnExcelExpert
@PKAnExcelExpert Год назад
Thanks🙏
@narendranegipoetry3253
@narendranegipoetry3253 3 года назад
Hi PK, could you make a video roster vs Attendance center wise
@MohammedIslamElshiekhElsmani
@MohammedIslamElshiekhElsmani 2 года назад
Interesting!!
@PKAnExcelExpert
@PKAnExcelExpert 2 года назад
Thanks for your valuable feedback🙏
@jongjin311
@jongjin311 Год назад
Many thanks for clear explanation! What sould I do if I want to see multiple result cells in senario summary??
@AbhishekSingh-wo7fk
@AbhishekSingh-wo7fk 3 года назад
Very helpful 👍
@PKAnExcelExpert
@PKAnExcelExpert 3 года назад
Thanks for your valuable feedback
@reethumartin3379
@reethumartin3379 3 года назад
Thank u...
@PKAnExcelExpert
@PKAnExcelExpert 3 года назад
Welcome
@brahimeljaidi6229
@brahimeljaidi6229 2 года назад
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
@Kushalpaudel7
@Kushalpaudel7 Год назад
Nice video
@PKAnExcelExpert
@PKAnExcelExpert Год назад
Thanks
@maxmudxasan6645
@maxmudxasan6645 3 года назад
Hello, sir thanks for ur sacrifice but I need to know how to calculate the item cost. Thanks.
@sanjandaniel
@sanjandaniel 27 дней назад
Yes can someone please explain how the cost was calculated to 20? Was it missed out being mentioned in a separate row?
@mazenzagha8811
@mazenzagha8811 3 года назад
Thanks for your lessons pls could you increase on . modern forms in vba
@zoyeb100
@zoyeb100 Год назад
Nice video sir 👌🏻👍🏻 . Thank you
@PKAnExcelExpert
@PKAnExcelExpert Год назад
Most welcome
@parulleuva3088
@parulleuva3088 Год назад
👍👍👍👍👍
@PKAnExcelExpert
@PKAnExcelExpert Год назад
Thanks🙏
@joephoffmann4294
@joephoffmann4294 2 года назад
ty sir!
@meghanlim926
@meghanlim926 3 года назад
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 .
@bhoopalani7256
@bhoopalani7256 2 года назад
When we have simple formulas to achieve the same, what's the need for what-if analysis?
@KrishnaBiopaczz
@KrishnaBiopaczz 3 года назад
Tq boss
@PKAnExcelExpert
@PKAnExcelExpert 3 года назад
Most welcome
@prajwalshetty2047
@prajwalshetty2047 2 года назад
👍
@PKAnExcelExpert
@PKAnExcelExpert 2 года назад
Thanks
@nguyenphuong3836
@nguyenphuong3836 Год назад
1
@PKAnExcelExpert
@PKAnExcelExpert Год назад
Thanks
@bharatpokhriyal7185
@bharatpokhriyal7185 3 года назад
Sir pls ek video google sheet pe Dashboard ki video baniye
@saifrashid6713
@saifrashid6713 Год назад
Can we drag the Goal seek function?
@publikkers3796
@publikkers3796 Год назад
It was very difficult for me who didn't understand English when my teacher told me to summarize from this video
@aman1245singh
@aman1245singh Год назад
Thanks buddy
@PKAnExcelExpert
@PKAnExcelExpert Год назад
Most welcome🙏
Далее
Solve Anything FAST with Excel's What-if Analysis
9:57
Dashboard Power BI para Northwind
1:08
Просмотров 837
Excel Solver & Goal Seek Tutorial
23:34
Просмотров 161 тыс.
Make a Search Bar in Excel to Find Anything!
10:35
Просмотров 349 тыс.
Transport Cost Optimization Using Solver in Excel
14:36
MS Excel - Pie, Bar, Column & Line Chart
8:56
Просмотров 1,1 млн