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

Channel:
Australia Magic Monk
Subscribers:
64,099
Published on ● Video Link: https://www.youtube.com/watch?v=o81gskeR2xE


Duration: 8:37
152,091 views
1,074

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:
https://www.youtube.com/playlist?list=PLzr5fRV1AGV9CMSWzCjFExhEfzDxZcGFX



Other Videos By Magic Monk


2014-01-01Surds lesson 8 - Rationalising denominators using conjugates
2014-01-01Surds lesson 7 - Rationalising the denominator
2014-01-01Surds lesson 6 - Binomial Expansion (Distributive Law)
2013-12-31Surds lesson 5 - Division
2013-12-30Surds lesson 4 - Multiplication
2013-12-30Surds lesson 3 - Addition and subtraction
2013-12-30Surds lesson 2 - Simplifying surds
2013-12-30Microsoft Excel Lesson 6 - If function, nested if function, AND function
2013-12-29Microsoft Excel lesson 5 - count and countif functions
2013-12-28Microsoft Excel lesson 4 - Dice Simulator (randbetween function, paste as values)
2013-12-28Microsoft Excel lesson 2 - compound interest calculator (absolute referencing, fill down)
2013-12-28How to force copy files off scratched dvds
2013-12-26DVD drive missing in Windows 8
2013-12-26How to get data off an old hard drive
2013-12-25How to stop a program from running automatically when computer starts (Windows)
2013-12-25Solution to Christmas puzzle, subscriber winner and prize announced, why does 0 factorial equal 1
2013-12-24How to save your files online - Cloud Storage comparison
2013-12-22Free Android Games - Real Racing 3 tutorial
2013-12-22How to get rid of popup ads on nexus g7 android tablet
2013-12-22Microsoft Excel lesson 1 - basic numerical operations, cell referencing
2013-12-21Integral Calculus lesson 8 - Shortcut for finding area between 2 curves


Tags:
absolute referencing
excel tutorials
compound interest calculator tutorial
excel compound interest