8 ай бұрын
Жыл бұрын
2 жыл бұрын
Пікірлер
@epm1995 5 күн бұрын
Thanks, Sir. Very helpful.
@christoslefkimiotis9889 18 күн бұрын
Very nice video, it is always better and safer to build your discount formulas and use goal seek to force the nov to of the flows to 0 in this way you bulletproof your calcs if the first flows are 0. Xirr is a quick way but nit the best
@suchibhargava7222 21 күн бұрын
It’s not working for same day join and leaving employee
@salmakhaled4402 Ай бұрын
Thanks a lot, very helpful!! Short, simple and to the point
@anormans8252 Ай бұрын
Thank You very much, your video helped me so much..
@yannickboutalbi6324 Ай бұрын
What computer program do you use for the stats?
@pierrejoubert29 Ай бұрын
Very usefull.. thanks!👏
@Almightydeep 2 ай бұрын
Thank you.
@TapasDas-fr7jv 2 ай бұрын
sir, Can you guide me regarding power pivot at Excel please
@camiloescallon4387 2 ай бұрын
Thank you very much, you just made my life so much easier. It's incredible that microsoft hasn't made the formating of these graphs more straightforward!
@david_allen1 2 ай бұрын
Wouldn't HSTACK be simpler than using CHOOSE?
@ProfectusLearning 2 ай бұрын
Indeed, it would be better. If I remember correctly, HSTACK didn’t exist when I made this video.
@rahulrpatil3005 2 ай бұрын
Helped me :) Thanks a lot.
@jonielcabanting3292 2 ай бұрын
Thank you for this tutorial❤
@jonathansvardh7924 2 ай бұрын
Thanks for this!
@underzero4 3 ай бұрын
thanks man you help me a lot!!
@hussainabbasbw9190 3 ай бұрын
Came here for the explanation, got impressed by the excel skills
@joshuamanampiu6489 3 ай бұрын
Wow. Best explanation video I have seen
@patnaikg 3 ай бұрын
Thanks for the tutorial
@neerajgupta93 3 ай бұрын
How to count a Specific repeated word array in excel Example PPPPPPWWPPPPPP = 2 means P is repeated 2 times with an array of 6. I need formula for the same.
@user-dh5bs9ve8y 3 ай бұрын
thanks for this video.. really helpful.
@bdee4707 3 ай бұрын
nicely explained... waiting for part 2 😊
@bdee4707 3 ай бұрын
most underrated video!! ,
@mostafanashaat1538 4 ай бұрын
You are the mannnnnnnnn .. extremely useful video .. thank you
@AntaresGameStudios 4 ай бұрын
Really helpful
@mukeshkadkol4759 4 ай бұрын
Superb boss !
@vineetbansal4728 4 ай бұрын
Awesome
@devarajpriyadharshini9503 4 ай бұрын
Really great video, thanks for the save❤
@donniesalvador7493 4 ай бұрын
What year is CAGR ideal for future forecast? Year 3 onwards? Thanks.
@victoraguirre7486 4 ай бұрын
we are done with what? nothing seemed to change?
@anuragideas6237 4 ай бұрын
Can you please comment back on my issue?
@tarundakalia 5 ай бұрын
Great video! If I can recall correctly, you were about to come up with a course on Report Writing. Any update on it or am I mistaken?
@ProfectusLearning 5 ай бұрын
Hi Tarun, thanks for your compliments and for showing interest in our financial writing program. We have a program on financial writing already. We are likely to start the next batch by second week of March 2024. We shall keep you posted.
@user-lu2mp7cf8r 5 ай бұрын
Genius
@deekshapriyani1242 5 ай бұрын
Thank you, I was stuck at this for a long time and this one helped me.
@TimEllisWW 5 ай бұрын
Well explain, thanks.
@GunjanMeher 5 ай бұрын
Thanks for this tutorial. Solved my problem and learned something new. Didn't knew that there is something called "No Break Space".
@chandramohan1418 6 ай бұрын
please inform about Excel course details. thank yu
@josejordan5013 6 ай бұрын
😜 Promo sm
@RahulSingh-bt3el 6 ай бұрын
Thank you 😊
@kniitito801 7 ай бұрын
Thank you so much, this was the video I was looking for all along....
@TheKishan55 7 ай бұрын
Can you share the file as row 21 to 25 are grouped
@gowthamdhanasekaran3908 7 ай бұрын
Great video! Just wondering why we shouldn't use circular reference in the first place?
@ProfectusLearning 7 ай бұрын
That is a good question, Gowtham. Circular reference in MS Excel create multiple issues including the following: (i) Presence of circularity makes the file difficult to debug. When you try to find the source of the problem, it might bring you back to the same cell where you first encountered the problem. (ii) It will not point out any unintentional circular reference that we have given, and (iii) If the problem does not have a real solution, instead of telling you that, it will give you a wrong answer.
@anilpenugondakumar4518 7 ай бұрын
One way to work around this limitation is to introduce a small initial cash flow, even if it's just a negligible amount, and then adjust the formula. Insert one row & input a dummy initial cashflow as negative -0.00001. It should work
@ProfectusLearning 7 ай бұрын
Yes, that works in majority of the cases. But we have seen that approach failing in some occasions. Reproducing the error hasn’t been easy, but we recommend that approach as a last resort.
@spideyocd 7 ай бұрын
It would be better if you could provide an excel sheet you worked on
@AustinM-wf5nk 7 ай бұрын
Fixed my problem. Thank You!!!
@stanwilson1189 7 ай бұрын
Thanks i did this very comparison you eluded to ; some people just rely on XIRR
@Talib_Husain18 7 ай бұрын
Very useful info 👍
@ladhkay 8 ай бұрын
Too rushed, thumbs down
@tarundakalia 8 ай бұрын
Helpful video Viswanathan sir! I am a big fan your use of the mathematical functions. Looking forward to more videos in that area!
@agapheputrasusilo741 8 ай бұрын
bro straight to the point and do not waste any second
@user-be9xu1bz7s 9 ай бұрын
Is there a way to add multi-level labels on the x axis for waterfall graphs on Excel? I can't seem to do this, but I can for other chart types.
@ProfectusLearning 9 ай бұрын
The built-in one doesn't seem to allow it. But if you use the older method, illustrated in the link below, you will be able to do that: kzbin.info/www/bejne/bIKTh2Cbpa6Wqbc