Went thru so many examples in the net, and finally chanced upon yours. Clear and straightforward for very layman like me to understand. Thanks man :D
@IvanCortinas_ES
4 ай бұрын
Absolutely pedagogical. Very instructive. Thank you!!!
@RoySamuel
4 ай бұрын
Great, informative, educational, entertaining videos... Big fan.
@jerrydellasala7643
4 ай бұрын
It's worth pointing out that spilled ranges often don't need locked cell references. For example, in the "Effect of Interest Rate on Compounding" section, you use the formula =FV(C122#,$D$118,,-$D$117), however the formula =FV(C122#,D118,,-D117) gives the same exact answer, and makes the formula more flexible and less error prone. Likewise, the formula =$D$93*(1+$D$94/D$98:I$98)^($C99:$C102*D$98:I$98) in the "Effect of Compounding Frequency" section can be simplified to =D93*(1+D94/D98:I98)^(C99:C102*D98:I98). And so on. Spilled Range is a beautiful thing!
@chandoo_
4 ай бұрын
They are indeed very powerful and flexible.
@gauravupreti5612
4 ай бұрын
Chandoo, that was an excellent video. Can you please create a video demonstrating how to prepare an employee monthly performance sheet?
@exploreyourexcel
4 ай бұрын
I am your big fan Boss first comment 😀
@gloystar
Ай бұрын
Hey Chandoo, nice video bro. Can you make a video showing us how to construct such dynamic chart titles like the ones you did here (while also preserving currency formats and such)? It's amazing and I'd like to learn how to do it.
@ahmedshahzad9402
4 ай бұрын
Sir please make a video on advance ecommerce metrics e.g: CLV, CAC, COG, AOV, customer retention rate and more. Please.....
@chrism9037
4 ай бұрын
Excellent Chandoo!
@huzaifahshah3841
4 ай бұрын
Great work
@gopalkrishna8977
4 ай бұрын
meeru Thopu sir
@TheAlwaysGoel
4 ай бұрын
Can u make videos on power query and Power pivot
@mkimpact
4 ай бұрын
Thanks Chandoo, a fantastic video. Can I please ask how would you modify the FV formula to include a starting amount? e.g. if you have $20,000 to invest, and want to add $5,000 per annum at 8% interest rate, how would you modify the formula to include this initial lump sum? Thanks
@chandoo_
4 ай бұрын
You are welcome. You can use this variation. =FV(8%,10,5000,20000) calculates future value of initial investment of $20k + 5k per annum for 10 years at 8%
@mkimpact
4 ай бұрын
@@chandoo_ fantastic thank you :)
@pujaagarwal8014
Ай бұрын
Thanks you made it so easy to understand even children can understand by seeing this video
@v_fiver
4 ай бұрын
Sir pls make video on salary bonus sheet all employees
@gova3vardhan
4 ай бұрын
Hey Chandoo can you help in creating a solution at my workplace How can I upload any PDF/Word file in a dedicated Excel cell and share the sheet with a team, so they can access the file I uploaded?
@VJ_1985
4 ай бұрын
Can you help me in one formula in excel. Wherein I need 4 input boxes, two for From Date and To Date, Interest Rate per Month, And Principal Amount. Now I need a formula to calculate Compund interest on the principal amount wherein interest gets compounded every 11 months. A month always has 30 days. Even few days extra needs to be considered as a Full Month. I mean from 20-Mar-2022 to 25 - Mar-2024. It will be 24 months and 5 days, but it should calculate it as 25 months. Interest Needs to be calculated for first 11 months when duration is more than 11 months and then for the rest of the duration interest needs to be calculated on principal+11 months interest.
@enteryourname4440
4 ай бұрын
can I have the template
@matinurrahman6173
4 ай бұрын
What happen when interest compounded quarterly with mothly installment payments declining method
@chandoo_
4 ай бұрын
In this case, you create a schedule by month, calculate opening balance and closing balance of both interest and principal and then reduce the amounts. You can use ipmt and ppmt functions for some of the numbers.
@khushdilinsaan3605
4 ай бұрын
Suggest me course for banking and finances
@illiakhmaladze2071
4 ай бұрын
That should be $10,998,806.28 for 100 years If I'm correct
@shubhampaul790
4 ай бұрын
2nd Time
@rockstar0r
4 ай бұрын
5k @ 8% in 100 years = 1,09,98,806.28
@vabi151993
4 ай бұрын
How please?
@venuchaganthi
4 ай бұрын
Hi Chandoo, How to contact you, we need advanced excel training.
@chandoo_
4 ай бұрын
Please get in touch via chandoo.org/wp/power-bi-remote-training/
@udaykiranvanapalli1516
4 ай бұрын
for 100 Years $10,993,806.28
@chanukamadusanka7442
4 ай бұрын
can someone tell me, how to download sample data set?🥲
Пікірлер: 32