Microsoft Excel lesson 2 - compound interest calculator (absolute referencing, fill down)

In this lesson we build a compound interest calculator to calculate how much interest the bank will pay you if you save a certain amount of money in the bank. We talk about absolute referencing using dollar signs and what happens when you fill down by dragging the corner dot down the screen.

Link to Excel Lessons Playlist:

[denishamdiev]

I know its quality content a guy sitting in his room discussing excell no intros no sponsors just old school quality contect thanks

[melissaramirez]

I watched about 10 tutorials trying to finish an Excel project - none helped. After watching yours, I was able to finish in less than five minutes. Thank you!

[hotdog]

I'd been searching around for a calculation of compound interest and all the formulas I'd seen were based on yearly calculations, whereas I wanted one that is open ended. This is perfect. Thank you for the clear explanation and the bonus info about putting a dollar sign in to stop excel incrementing the cell numbers. Top marks!

[KeanuKianK]

9 and a half years on and this video is still useful! Thanks :)

[faithbarrows]

numbers really jumble my head but this tutorial made them enjoyable. Thank you for the dollar sign tip. Super helpful.

[justenelee]

Thank you!! Understood it much better once I watched this video.

[gotmikedaniels]

YOU MADE THIS SO EASY! THANK YOU! I applied it and made a RENT VS BUY with annual appreciation. Thanks!

[JadeLao-nq]

thanks for ur help! us stem students are thankful ❤

[avinashbhan]

This was very well explained . Thanks for sharing

[vinothkumar-dbmz]

Very helpful and the method u r explaining is very easy and very clear to understand. Thank you so much. 👍👍

[nigelpollitt]

completely sorted me out, and on a lot of spreadsheet basics, thanks

[captoshuragnarok]

Thank you sooo much! Great tutorial! Dollar sign for the win!

[itsalv]

Thanks a lot! I was too lazy to figure the formula, this video was very helpful!

[nasikastrology]

Can I use this calculations for daily or monthly basis except yearly for my own business pl reply or create a new video on this topic

[stevecorrie]

How do you account for added monthly payments?

[tonytones]

HI.. great video.. I do however have a problem I'm hoping you can help me with?? i have a formula created that work compounding my initial principle at 10% but once this calculation begins and I then want to ADD another amount paid the whole calculation is revealed as if both payments where mad on the same day so the 10% compound has assumed there was only 1 original payment as apposed to a sum being added later on down the sorry could not explain this better but I hope you understand.

[james]

How do you find compounding interest when also adding a fixed amount each year?

[alexc]

How would you calculate compound interest, calculated daily, paid monthly, on principal that is regularly increased

[mohamedbentahar]

2:48 i get #value ! in 115$ how to fix that ?

[alexandreb]

Thank You my friend you helped me a lot !