The Complete Excel Course with AI Integration

Build a compound interest calculator in Excel

Compound interest is easy to state and hard to feel until you watch it in your own sheet, where every return joins the pot and earns returns of its own. The Complete Excel Course with AI Integration builds that sheet in the closing lesson of its opening project: a monthly saving compounds row by row beside FV and bends into a steep curve on a chart. WealthFlow, the industry-standard simulator it leads to, takes the same arithmetic to a whole retirement. Every formula stays yours, and Excel is all you need.

Taught by Sagnik Bhattacharya and Virginia Thorn

The Complete Excel Course with AI Integration: Sagnik Bhattacharya and Virginia Thorn

What you will be able to do

You will be able to:

  • Grow any monthly saving at any yearly return and read its value at the end of every year, in a table that answers again the moment an input changes.
  • Write compounding with your own hands, last year's value times one plus the rate plus the year's new money, and check FV's answer against it column by column.
  • Lock every formula onto its input cells with F4, so a new rate or monthly amount flows through every year of the table at once.
  • Turn a yearly return into its true monthly equivalent with one formula, so twelve months of compounding land exactly on the yearly figure.
  • Draw the growth as a line that starts gently and then climbs steeply, a picture of what a small, steady habit is worth over the long run.

Projects

What you will build.

The course has 14 industry-standard projects. These two matter most here.

  • Project 01

    Personal Budget Tracker

    Your first workbook: where the money goes each month.

    Its closing lesson is your compound interest calculator: a monthly saving grown by hand and by FV, column beside column, then drawn as a curve, with the finished workbook to check yours against.

  • Project 10

    WealthFlow

    A retirement plan that shows how long the money lasts.

    Where compounding becomes a plan you own: a monthly investment sheet begun from a blank page, its monthly rate worked out from the yearly return, with step-ups, inflation and withdrawals waiting further on.

Tap or pinch to zoom in, drag to move around. Click or scroll to zoom in, drag to move around.

Lessons

The lessons that matter, in course order.

The Complete Excel Course with AI Integration has 186 lessons. This page picks out 5 of them, 26 min of video. Each lesson keeps its number in the course.

Where to start

Lesson 8 Basic maths in Excel

Begin at Lesson 8 if formulas are new to you: arithmetic, brackets and locked references come first, and Lesson 18 then builds the whole calculator in one sitting. Already write formulas? Go straight to Lesson 18. New to Excel itself? The course opens with free preview lessons on the course page, from Lesson 1.

5 of 186 lessons · 26 min

01 Microsoft Excel fundamentals: building a foundation from scratch 1 of 13 lessons · 3 min Formulas that open with an equals sign, the four kinds of arithmetic, and brackets that tell Excel what to work out first: the grammar of last year's value times one plus the rate. Practised on the budget sheet.
  1. 8 Start here Basic maths in Excel Add, subtract, multiply and divide with formulas 3 min
01 Microsoft Excel fundamentals: building a foundation from scratch 1 of 13 lessons · 3 min F4 and the dollar signs it adds: a reference locked onto the rate cell stays put as the formula is copied down, the difference between a calculator right on every row and one that breaks after the first. The lesson locks a tax rate on budget amounts.
  1. 10 Relative vs absolute references in Excel Dollar signs and mixed references 3 min
02 Project: personal budget tracker 1 of 5 lessons · 7 min The calculator itself: a monthly saving, a yearly return and a number of years as inputs, a year column filled by the fill handle, the total you paid in, one column compounded by hand and one by FV, and a line chart of the growth.
  1. 18 SIP growth calculator in Excel FV function for mutual fund investment growth 7 min
13 WealthFlow investment and retirement simulator 1 of 11 lessons · 6 min Compounding explained before WealthFlow's first formula, on an online calculator: a SIP, a fixed amount invested every month, beside a lump sum invested once, and how small the part you paid in looks next to the return by the end.
  1. 125 SIP and SWP calculators What is an SIP, lump sum and compounding 6 min
13 WealthFlow investment and retirement simulator 1 of 11 lessons · 6 min A monthly investment calculator begun from a blank sheet: an input block for the amount, its yearly increase, the assumed return and inflation, then one formula that turns the yearly return into its monthly equivalent.
  1. 127 WealthFlow SIP model in Excel Input assumptions, XIRR and monthly rate 6 min

Instructors

Who teaches it.

Virginia Thorn smiling at the camera, dark hair tied back, wearing a navy top.

Instructor, Excel with AI

Virginia Thorn

Emmy Award winner. Teaches Excel with AI at Coding Liquids.

Questions

Asked before starting.

Is there an Excel course where I build my own compound interest calculator?

The Complete Excel Course with AI Integration from Coding Liquids has you build one from scratch. In Lesson 18 a monthly saving compounds year by year twice over, once in a column you write yourself and once with FV, and a line chart draws the curve; WealthFlow, the retirement simulator later in the course, grows the same idea into step-ups, inflation and a lifetime plan. Every project in the course is industry standard, designed after talking with people from many different industries. This page holds 5 lessons, 26 minutes of video, from your first formula to a calculator that is yours outright.

Can Excel calculate compound interest?

Yes, with a function made for it and with a formula you write yourself, and The Complete Excel Course with AI Integration has you do both on the same saving so each checks the other (Lesson 18). FV, Excel's future value function, returns what a monthly investment grows to in one formula; the column beside it compounds the same money a year at a time. The monthly amount and the return sit in input cells of their own, so the moment you change either, every year of both columns answers again: an investment calculator you can question, not just read.

What is the compound interest formula in Excel?

Written by hand it is one line, and The Complete Excel Course with AI Integration has you type it in Lesson 18: this year's value equals last year's value times one plus the rate, plus the money you added during the year. Brackets keep one plus the rate together so Excel works it out first (Lesson 8); F4 locks the rate and the monthly amount with dollar signs so the formula can be filled down (Lesson 10); and a double-click on the fill handle compounds every remaining year within seconds. FV does the same job month by month, which is why its answer sits close to yours.

How does Excel's future value formula handle monthly contributions?

It takes each contribution as a payment and compounds every one of them for you. In The Complete Excel Course with AI Integration you hand FV a monthly rate, the number of months and the amount you add each month, leave the starting sum at zero, and fill it down to read the value at the end of every year (Lesson 18). WealthFlow then sharpens the rate: one formula finds the monthly rate that, compounded over twelve months, gives back exactly XIRR, the yearly return you set (Lesson 127). The return you type is your own assumption, since the course teaches the spreadsheet and gives no financial advice. What you hold at the end is compound interest with monthly contributions, worked by a formula you understand.

Why does compound interest grow slowly at first and then so fast?

Because every return is added to the pot and then earns returns of its own, so each year's growth outgrows the year before. The Complete Excel Course with AI Integration shows it on an online calculator before WealthFlow begins, where the money paid in ends as a small slice beside a far larger slice of returns (Lesson 125). Your own calculator then shows it twice: in year-end values that climb faster the further down the column you read, and in a line that starts as a gentle slope and bends sharply upward (Lesson 18).

Can I work out compound interest on a lump sum in Excel?

The Complete Excel Course with AI Integration explains lump-sum compounding in WealthFlow's opening lesson, a single amount invested once and left to grow, set beside a monthly plan on an online calculator (Lesson 125). In Excel your builds compound a monthly amount, and the lifetime simulator also takes money you have already saved as a starting amount and grows it with every year's return, alongside the monthly investing (Lesson 133). A sheet for a lump sum on its own is not built, but the row you compound by hand in Lesson 18 is that same arithmetic, with the year's new money added.

Should I download a compound interest calculator template or build my own?

Build it, because a calculator you wrote yourself can be checked, changed and trusted. The Complete Excel Course with AI Integration gets you there in a single lesson (Lesson 18), and you come away knowing how compounding is written, so the next growth projection someone shows you is one you can rebuild with your own inputs and test. The lesson's finished workbook is there to hold yours against, and to see where the idea leads, open the finished WealthFlow simulator first: it is free by email from the course page.

Do I need to be good at maths to build a compound interest calculator?

School arithmetic is all it takes, and The Complete Excel Course with AI Integration begins there: a formula opens with an equals sign, brackets decide what is worked out first, and a reference to a cell keeps the answer live when its number changes (Lesson 8). WealthFlow says it outright when it sets up the return: you are there to learn Excel, not to sit a finance exam (Lesson 127). Should a step still puzzle you, the plan with instructor support adds two months of written questions answered by the instructor under each lesson, with Ask AI in every lesson, from the day you switch it on.

Excel with AI

See the whole course.

The Complete Excel Course with AI Integration: 16 hours of video in 186 lessons, built around 14 industry-standard projects, with lifetime access, a Certificate of Completion and a 14-day money-back guarantee.

The same course

For another job, goal, level, topic or comparison.