# Microsoft Excel lesson two – compound fascination calculator (complete referencing, fill down)

In this lesson we make a compound fascination calculator to estimate how a great deal fascination the bank will pay back you if you save a selected sum of dollars in the bank. We chat about complete referencing employing dollar symptoms and what occurs when you fill down by dragging the corner dot down the screen.

# 17 comments

1. Thank you for your HELP, and for explaining it so simply. Thanks again.

Reply
2. Thank you so much!

Reply
3. Awesome tutorial brother

Reply
4. Thank you very much dude!!!! helped me a lot

Reply
5. Thanks for your help!

Reply
6. This was a great video. Thanks for the help

Reply
7. thank u dear u made my day

Reply
8. Thank brother Monk, you helped me out a lot today!!!
I learned a good strategy, keep up the good work.

Reply
9. can you do monthly and quaterly

Reply
10. 1
2
4
8
16
32
64
128
256
512
1024
2046
4092
8184
16368
32736
65472
130944
261888
523776
1047552
2095104
4190208
8380416
16760832
33521664
67043328
134086656
268173312
536346624
1072693248
2145386496
4290772992
8581545984
17163091968
34326183936
68652367872
1.37305E+11
2.74609E+11
5.49219E+11
1.09844E+12
2.19688E+12
4.39375E+12
8.7875E+12
1.7575E+13
3.515E+13
7.03E+13
1.406E+14
2.812E+14
5.624E+14
1.1248E+15
2.2496E+15
4.4992E+15
8.9984E+14
1.79968E+16
3.59936E+16
7.19872E+16
1.44E+17
2.88E+17
5.76E+17
1.15E+18
2.30E+18
4.61E+18
9.21E+18

what does the 9.21E+18 actually mean ?

Reply
11. thanks a lot….

Reply
12. You're a lifesaver

Reply
13. Thanks a lot , perfect explanation by simple way, i am appreciated 🙂

Reply
14. Very helpful. Thank you

Reply
15. Thank you very much. This is an excellent lesson.

Reply
16. Compound interest calculator

Principal 2300
Interest rate p.a 5%

Year Principal Interest e.o.y.principal
1 2300 115 2415
2 2415 12075% 253575%
3
why is it not calculating properly on the second line.  I am using excel 2013

Reply
17. Excellent

Reply