The Complete Excel Course with AI Integration

Excel course for retirement planners

Model any client's retirement in a workbook you own, every formula in view, independent of any other software. The Complete Excel Course with AI Integration teaches the Excel side of your work at full strength, and the advice stays yours: WealthFlow, an industry-standard simulator months in the making, puts a client's SIP (investing a fixed amount regularly) and SWP (withdrawing one regularly) in one model with inflation and charts. The lessons around it make it reusable for every client and safe to hand over.

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

At work, you will be able to:

  • Model a client's whole plan in one workbook: monthly saving that steps up each year, withdrawals from a chosen age and the balance year by year to an end age.
  • Set withdrawals to rise with inflation and show a client the pot and the income in today's money.
  • Show the age at which a plan would run dry, then rerun it at once with a lower return or a smaller withdrawal.
  • Reuse one model for every client: assumptions in a single input block reached by locked references, so a new client needs new inputs, not new formulas.
  • Hand over a protected workbook: inputs open to change, formulas and the sheets' structure locked, negative balances in red.
  • Check a dashboard an AI assistant builds on a client's model, from its source data to every total, before the client sees it.

Projects

What you will build.

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

  • Project 10

    WealthFlow

    A retirement plan that shows how long the money lasts.

    The most useful project in the course for retirement work, made to be reused: SIP and SWP calculators and a lifetime simulator, every input ready for a client's own figures.

  • Project 07

    TaskFlow

    One sheet that shows what is done, what is late and what is urgent.

    Built as a task tracker that flags overdue work, it teaches the protection a client-facing model needs: cells locked, the sheet protected with an optional password and the workbook's structure fixed.

  • Project 09

    FinanceGuard

    The budget vs actual report finance teams send every month.

    Built for budget against actual, it lends a planner its custom number format: negative figures in red brackets, so the years after a pot runs dry stand out.

  • Project 14

    Agentic AI in Excel

    AI finds and fixes the formula; you check it before it counts.

    Built around Copilot, ChatGPT and Claude, it holds the checklist to run on anything an assistant adds to a client's workbook before the client sees it.

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 18 of them, 1 h 27 min of video. Each lesson keeps its number in the course.

Where to start

Lesson 125 SIP and SWP calculators

Begin at Lesson 125, where WealthFlow sets out SIPs and SWPs before the first formula, and build it through to its dashboard. If dollar signs in formulas are new to you, watch Lesson 10 first; new to Excel altogether, start at Lesson 1. Keep the protection and checking lessons for the day a model goes to a client. The finished WealthFlow workbook is free by email from the course page, so you can open the whole model and try a client's figures in it before you decide.

18 of 186 lessons · 1 h 27 min

01 Microsoft Excel fundamentals: building a foundation from scratch 1 of 13 lessons · 3 min Absolute and mixed references with F4: a rate typed once and every formula pointing at it, the habit that lets one model serve client after client. The lesson practises on a budget.
  1. 10 Relative vs absolute references in Excel Dollar signs and mixed references 3 min
03 Managing data in Excel: sort, filter and tables (Dunder Michael Paper employee database) 1 of 9 lessons · 3 min Freeze panes: the heading row and first column stay in view, so a plan that runs from a client's first saving year to the end age keeps its headings in sight. The lesson freezes an employee list.
  1. 26 Freeze panes in Excel Lock header rows and columns while scrolling 3 min
04 Essential formulas and functions (IF, SUMIF and more) 2 of 13 lessons · 8 min TRUE and FALSE comparisons, then IF: the test that stops contributions and starts withdrawals at the age a client chooses. The lessons mark pupils' results as pass or fail.
  1. 28 Logical functions in Excel TRUE and FALSE comparisons for beginners 5 min
  2. 29 The IF function in Excel Pass or fail results with a single condition 3 min
09 Project: task automation with data validation and forms 1 of 9 lessons · 4 min Protection done properly: the Locked setting cells carry, which counts only once the sheet is protected, Protect Sheet with an optional password, and Protect Workbook so sheets cannot be renamed or moved. The lesson protects a task tracker.
  1. 86 Protect a sheet and lock cells in Excel Secure the TaskFlow tracker workbook 4 min
10 Boosting productivity with AI in Excel (Copilot, ChatGPT and Claude) 1 of 17 lessons · 2 min A short checklist for AI output: the right data, the right period, charts wired to the right source and totals that are correct, not just plausible. The lesson checks a dashboard Copilot built.
  1. 99 Check AI output in Excel A quick QA checklist for Copilot results 2 min
12 Project: FinanceGuard budget variance analyser (budget vs actual Excel dashboard) 1 of 10 lessons · 2 min A custom number format that puts negative numbers in red and in brackets, practised on budget variances; on a client's plan it flags every year after the pot runs dry.
  1. 119 Custom number formats in Excel Show budget variances with colours and signs 2 min
13 WealthFlow investment and retirement simulator 11 lessons · 1 h 5 min WealthFlow from first idea to finished workbook: SIPs, lump sums and SWPs explained, a SIP calculator with XIRR and a monthly rate, a yearly step-up, FV, values in today's money and charts, an SWP calculator whose withdrawals rise with inflation, a real rate of return and a stress test, then the lifetime simulator with age columns, IF formulas, scenarios and a dashboard Claude builds for you to check.
  1. 125 Start here SIP and SWP calculators What is an SIP, lump sum and compounding 6 min
  2. 126 SIP and SWP calculators What is an SWP, inflation and FIRE 6 min
  3. 127 WealthFlow SIP model in Excel Input assumptions, XIRR and monthly rate 6 min
  4. 128 WealthFlow SIP model in Excel Step-up SIP table and FV formulas 6 min
  5. 129 WealthFlow SIP model in Excel Real portfolio value, inflation and charts 7 min
  6. 130 WealthFlow SWP model in Excel Real rate, corpus and yearly withdrawals 6 min
  7. 131 WealthFlow SWP model in Excel Real corpus, stress test and SWP chart 5 min
  8. 132 Retirement simulator in Excel WealthFlow inputs, year and age columns 5 min
  9. 133 Retirement simulator in Excel SIP, withdrawal and portfolio formulas with IF 7 min
  10. 134 Retirement simulator in Excel Reading the results and retirement scenarios 5 min
  11. 135 Retirement simulator in Excel Claude builds the WealthFlow dashboard 5 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 this a good Excel course for someone who plans retirements for clients?

Yes. The Complete Excel Course with AI Integration from Coding Liquids gives you WealthFlow, an industry-standard retirement simulator: SIP and SWP calculators and a lifetime simulator, with inflation and charts. It was designed after talking with people from many different industries, and it is yours: the workbook needs no other software, shows every formula and opens in front of any client. Around it, 18 lessons (1 hour 27 minutes) make the model reusable and safe to hand over. The lessons use example figures; your clients' own go into the same input cells.

How do I plan retirement withdrawals that keep pace with inflation?

Give the withdrawal a yearly rise of its own. The SWP calculator in The Complete Excel Course with AI Integration starts from a first year's withdrawal, raises it each year by a rate you can set to inflation and takes it from the pot after that year's return (Lesson 130); real columns then show the pot and the income in today's money (Lesson 131). Set inflation above the rise and the client watches the income buy a little less each year, a point every plan should make.

Can one workbook show a client's working years and retirement years together?

That is exactly what the lifetime simulator in The Complete Excel Course with AI Integration is built for: one row per year from the age saving starts to an end age you choose. IF formulas pay in a monthly amount that steps up each year until the retirement age, then switch to withdrawals that grow each year (Lesson 133), while the portfolio carries across with its value in today's money beside it. A client sees a whole financial life on one sheet.

How can I show a client the age at which their money would run out?

Read down the lifetime simulator to the first negative balance. In The Complete Excel Course with AI Integration, Lesson 134 sets the first withdrawal too high and the pot is nearly gone decades before the end age, then lowers it and the pot is still growing at the end. A custom number format (Lesson 119) puts negative balances in red brackets, so the year the money runs out is the first thing a client sees.

Can a client change the inputs without breaking my formulas?

Yes, once you protect the model. The Complete Excel Course with AI Integration shows the Locked setting cells carry by default, which takes effect only when the sheet is protected, then Protect Sheet with an optional password and Protect Workbook to fix the sheets' names and order (Lesson 86, on a task tracker). Clear Locked on the input cells first, and a client can try another return or retirement age while every formula stays exactly as you built it.

Can I show a client their retirement plan in charts?

WealthFlow draws them as you build it, so the charts are ready the moment the plan is. In The Complete Excel Course with AI Integration one chart sets the pot, its value in today's money and everything paid in side by side (Lesson 129), another sets the pot against the yearly withdrawals (Lesson 131), and in Lesson 135 Claude adds a dashboard sheet with charts for the whole workbook. Change an input while the client watches and every line redraws.

How fast can I show a client a cautious version of a plan and a hopeful one?

In seconds. Every assumption in the simulator of The Complete Excel Course with AI Integration sits in an input cell, so a different return, inflation rate or withdrawal reruns the whole table and every chart at once (Lesson 131). Lesson 134 reads the results across scenarios, from a first withdrawal that drains the pot to one that leaves it growing, and from contributions that stop early to ones that run to the retirement age.

Can AI build the part of a retirement model that a client sees?

Yes, with you signing off. In The Complete Excel Course with AI Integration, Claude adds a dashboard sheet with charts to the finished simulator (Lesson 135), and the lesson shows why you stay in charge: it does not always write correct formulas, so on real work you approve its edits one at a time. The checklist in Lesson 99 says what to inspect before a client sees anything: the data used, the period, each chart's source and every total.

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.