The Complete Excel Course with AI Integration

Excel course for finance and accounting

Finance and accounting run on Excel, and The Complete Excel Course with AI Integration teaches that Excel through big, industry-standard projects for financial analysis and the reports accountants need, each designed after talking with people from many different industries. You build a budget vs actual report with a variance engine and a retirement simulator with SIP and SWP, then join sheets with lookups, total any period in PivotTables, clean every export in Power Query and write a macro that checks a sheet.

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:

  • Turn a plan and a record of spending into one variance model: keys, months, departments and categories from dynamic arrays, every figure from SUMIFS, and a status note on every line.
  • Make every underspend stand out in red brackets through a number format of your own, and put budget, actuals, variance and budget utilisation on KPI cards that follow the data.
  • Grow a monthly investment with FV, raise it every year, draw an income from a pot with an SWP, and read every figure at today's value once inflation is taken out.
  • Pull a value from another sheet with XLOOKUP, INDEX and MATCH or VLOOKUP, and show a clear message wherever a code finds no match.
  • Total revenue and cost by category, quarter or month in PivotTables, show them in millions, and refresh every table at once when new rows arrive.
  • Clean exported files in Power Query with profit and margin columns built in, combine a whole folder of them on refresh, and run a macro that flags what is missing or stored as text.

Projects

What you will build.

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

  • Project 09

    FinanceGuard

    The budget vs actual report finance teams send every month.

    Two raw tables, one the plan and one the spending, turned into a variance engine that labels each line over or under budget and a dashboard a finance director can filter by department, category or month.

  • Project 10

    WealthFlow

    A retirement plan that shows how long the money lasts.

    Built around personal investing, it is a finance model you own outright: an inputs block, step-up contributions, withdrawals that rise with inflation, real values on every row and a stress test in seconds.

  • Project 12

    SalesFusion

    A sales report that refreshes itself from a folder of files.

    Messy CSV exports cleaned for good: money symbols and fake errors stripped, numbers made numbers, profit and margin columns added, and a folder of period files that loads itself on refresh.

  • Project 05

    SalesPlusPerformance

    A sales question answered in seconds, straight from the order data.

    An order-level table carrying net sales, cost and gross profit, cut by region, category and month in PivotTables that all refresh together when new orders land.

  • Project 06

    PeopleInsight HR workbook

    Employee data joined across sheets with one formula.

    Built on employee records, it is where XLOOKUP, VLOOKUP and INDEX with MATCH join one sheet to another through a shared code, the move behind every mapping table a finance file leans on.

  • Project 11

    FormatWizard

    One click that checks a whole sheet for you.

    A sales sheet checked by a macro you write: blank fields and numbers typed as text flagged and coloured in one run, the check an export deserves before its numbers reach a report.

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 71 of them, 5 h 55 min of video. Each lesson keeps its number in the course.

Where to start

Lesson 115 FinanceGuard budget vs actual dashboard

Start at Lesson 115 if you already total by condition and summarise with PivotTables every week: FinanceGuard opens there on a starter workbook of two raw tables. Newer to formulas? Begin at Lesson 18, the course's first financial function, or at Lesson 1 if you have never used Excel.

71 of 186 lessons · 5 h 55 min

02 Project: personal budget tracker 1 of 5 lessons · 7 min FV, the first financial function the course puts to work: a monthly sum at an assumed return compounded in a column you build, then in one formula with monthly compounding, and charted as the curve that money makes.
  1. 18 SIP growth calculator in Excel FV function for mutual fund investment growth 7 min
04 Essential formulas and functions (IF, SUMIF and more) 2 of 13 lessons · 15 min Totals and counts that obey conditions, practised on sales records: by product, rating or region with SUMIF and COUNTIF, then several tests at once with SUMIFS and COUNTIFS, the function that later pulls every budget and actual figure into FinanceGuard.
  1. 36 SUMIF and COUNTIF in Excel Conditional sum and count with one criterion 8 min
  2. 37 SUMIFS and COUNTIFS in Excel Sum and count with multiple criteria 7 min
07 PivotTables and PivotCharts: data analysis made easy 10 lessons · 33 min PivotTables on order-level sales with net sales, cost and gross profit: the data cleaned first, revenue set against cost by product category, dates rolled up into years, quarters and months, slicers, PivotCharts, the Design tab with figures shown in millions, Refresh All and a Ninja Challenge.
  1. 57 PivotTables 101 in Excel What a PivotTable does and the sales dataset 5 min
  2. 58 Preparing data for PivotTables Clean data with TRIM, PROPER, find and replace 5 min
  3. 59 Create your first PivotTable in Excel Insert a PivotTable from a sales table 1 min
  4. 60 PivotTable fields in Excel Rows, values, columns and Value Field Settings 2 min
  5. 61 PivotTable summaries in Excel Sales by product category and grouping by date 4 min
  6. 62 Slicers in Excel Filter PivotTables with clickable buttons 3 min
  7. 63 PivotCharts in Excel Create interactive charts from a PivotTable 5 min
  8. 64 PivotTable design Tab Report layouts, PivotTable styles and number formats 5 min
  9. 65 Refresh a PivotTable in Excel Update pivots when source data changes 2 min
  10. 66 Excel Ninja Challenge PivotTable sales by region, category and monthly trend 1 min
08 Advanced Excel functions: lookups, text and arrays 4 of 12 lessons · 19 min Lookups across sheets on an HR workbook: VLOOKUP and why an inserted column breaks it, XLOOKUP that survives one, IFERROR turning a missing code into a readable message, and INDEX with MATCH. A cost-centre or account mapping is looked up the same way.
  1. 68 VLOOKUP in Excel Find employee data across sheets with exact match 4 min
  2. 69 XLOOKUP in Excel Exact match, if not found and two-way lookup 6 min
  3. 70 IFERROR in Excel Handle lookup errors in VLOOKUP and XLOOKUP formulas 3 min
  4. 71 INDEX and MATCH in Excel A flexible alternative to VLOOKUP 6 min
12 Project: FinanceGuard budget variance analyser (budget vs actual Excel dashboard) 10 lessons · 52 min FinanceGuard end to end: budget and actuals as named tables in accounting format, a model keyed with SORT, UNIQUE and VSTACK, month, department and category read out of each key with LET and TEXTSPLIT, SUMIFS for every figure, variance with a note on each line, red brackets for underspend, five PivotTables, KPI cards and charts, slicers, and a dark finished theme.
  1. 115 Start here FinanceGuard budget vs actual dashboard Excel project overview 3 min
  2. 116 Excel tables for budget and actual data Organise the FinanceGuard datasets 4 min
  3. 117 Budget vs actual model in Excel SORT, UNIQUE, VSTACK, LET, TEXTSPLIT, SUMIFS 8 min
  4. 118 Budget variance in Excel Calculate variance and percent variance 4 min
  5. 119 Custom number formats in Excel Show budget variances with colours and signs 2 min
  6. 120 PivotTables for budget vs actual The FinanceGuard pivot workspace 8 min
  7. 121 KPI cards in Excel Summary cards for a budget variance dashboard 4 min
  8. 122 Budget vs actual charts in Excel Combo chart with secondary axis for variance 5 min
  9. 123 Slicers and PivotCharts in Excel Interactive FinanceGuard budget dashboard 4 min
  10. 124 Finish the FinanceGuard dashboard in Excel Final polish and variance insights 10 min
13 WealthFlow investment and retirement simulator 11 lessons · 1 h 5 min WealthFlow as a finance model: assumptions in one block, a monthly rate derived from the yearly return, contributions stepped up each year and grown with FV, a pot that earns and pays out year by year, Fisher's real rate, columns in today's money, a stress test on the return, IF switching a lifetime from saving to drawing, and a closing dashboard from Claude.
  1. 125 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
14 VBA and macros in Excel: FormatWizard 17 lessons · 1 h 16 min FormatWizard: recorded macros with absolute and relative references, buttons and the .xlsm format, then VBA from a blank module up: variables, a Function for the last row, a routine that clears old flags, loops that flag blanks, IsNumeric for figures stored as text, colour on every fault, Debug.Print, and one master macro with an error handler.
  1. 136 Excel macros and VBA for beginners What macros are, the FormatWizard project 3 min
  2. 137 Record your first Excel macro Name, run and use absolute references 6 min
  3. 138 Relative references in Excel macros Make recorded macros dynamic 4 min
  4. 139 Developer Tab in Excel Run macros from a button and the quick access toolbar 4 min
  5. 140 Save macros in Excel Macro-enabled workbooks and the XLSM file format 3 min
  6. 141 The VBA Editor in Excel Open it with Alt+F11 and learn the workspace 4 min
  7. 142 Working in the VBA editor Macro security, trust settings, switching to Excel 6 min
  8. 143 Your first VBA code Modules, worksheets, rows, columns and formatting 4 min
  9. 144 VBA variables and data types Sub vs function for Excel beginners 6 min
  10. 145 VBA functions in Excel Build GetLastUsedRow with find and exit function 5 min
  11. 146 Clear old flags with VBA Reset messages and fill colours with if statements 5 min
  12. 147 For Next loop in VBA Flag missing region values in Excel 4 min
  13. 148 VBA If Else and loops Check missing sales data and build a FlagText message 5 min
  14. 149 Highlight cells with VBA Interior.Color and RGB for missing data 5 min
  15. 150 IsNumeric in VBA Validate unit price and amount data types in Excel 7 min
  16. 151 Debugging VBA for beginners Debug.Print and the Immediate window 5 min
  17. 152 Complete Excel validation macro One VBA subroutine with an error handler 3 min
15 SalesFusion: advanced data tools and a Power Query modelling system 16 of 21 lessons · 1 h 28 min SalesFusion's Power Query half: messy CSV exports extracted and cleaned in recorded steps, symbols and fake errors stripped, data types fixed, calendar columns and profit, margin, high-value and return flags added, totals and row counts checked with Group By, lookups merged, one year's pipeline reused for the next, two years appended and a whole folder of period files combined.
  1. 153 SalesFusion Power Query project Excel ETL pipeline and data model overview 5 min
  2. 154 Introduction to Power Query in Excel The ETL workflow explained 5 min
  3. 155 Import a CSV with Power Query Get data from text and transform data 2 min
  4. 156 Clean columns in Power Query Remove and rename columns for modelling 5 min
  5. 157 Clean text in Power Query Trim, clean, replace values and fix text case 6 min
  6. 158 Data types in Power Query Fix date, whole number, decimal and text types 7 min
  7. 159 Date columns in Power Query Add year, month and year-month fields for reports 7 min
  8. 160 Business logic in Power Query Custom and conditional columns for profitability 6 min
  9. 161 Group By in Power Query Summarise sales by month and region to validate data 5 min
  10. 162 Close and Load in Power Query Connection only, table or Data Model 5 min
  11. 163 Merge queries in Power Query Look up product and region names with a left join 5 min
  12. 164 Reuse a Power Query pipeline Duplicate queries for a new year of sales data 5 min
  13. 165 Append queries in Power Query Combine 2024 and 2025 sales tables 3 min
  14. 166 From Folder in Power Query Combine every sales file in a folder automatically 9 min
  15. 167 From Folder automation in Power Query Profit metrics and fiscal year columns 7 min
  16. 168 Build a sales fact table in Power Query Merge lookups and append history 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.

Which Excel course covers finance and accounting from raw data to a dashboard?

The Complete Excel Course with AI Integration from Coding Liquids, through big, industry-standard projects built for financial analysis and for the reports accountants need. FinanceGuard turns raw budget and actual figures into a variance engine and a dashboard; WealthFlow models SIPs, withdrawals and a whole retirement with inflation built in; SalesFusion cleans messy exports in Power Query; PivotTables, lookups across sheets and a checking macro complete the toolkit. That is the entire analysis, end to end: raw data in, a finished dashboard out, and this page holds 71 lessons, 5 hours 55 minutes of video. A Certificate of Completion marks the finish, and on the instructor support plan the instructor answers your written questions on the lessons for two months from the day you switch it on.

How do I learn Excel for finance if I am new to it?

Follow the course in order up to the finance work, then build it: The Complete Excel Course with AI Integration starts from your very first spreadsheet, and its opening lessons are free preview lessons on the course page. Your first financial function, FV, arrives in Lesson 18; conditional totals with SUMIFS in Lesson 37; PivotTables from Lesson 57; lookups across sheets from Lesson 68. FinanceGuard then puts SUMIFS and PivotTables to work on a real budget from Lesson 115, beginning with a starter workbook, and the course page sends the finished WealthFlow simulator free by email, so you can open a real finance model before you buy.

Which Excel skills do accountants use most, and where does the course teach them?

These carry most of the load, and The Complete Excel Course with AI Integration teaches each on a real project: SUMIFS for conditional totals (Lesson 37); XLOOKUP, INDEX with MATCH and IFERROR for matching codes across sheets (Lesson 69 to Lesson 71); PivotTables grouped by month and quarter with Refresh All (Lesson 61, Lesson 65); custom number formats that sign and colour a variance (Lesson 119); Power Query to clean each period's exports (Lesson 155 onward); and a macro that checks a sheet (Lesson 152). With lifetime access, every one of them stays there to look up at the next month end.

What does a variance engine do in a budget vs actual report?

It sets every planned figure beside the actual one and says what the gap means, which is what FinanceGuard's engine does in The Complete Excel Course with AI Integration. Keys from both tables are stacked and de-duplicated so no line is lost, SUMIFS brings in each budget and actual (Lesson 117), the variance is actual minus budget, the percentage is guarded by IFERROR, and a note reads Over budget, high or Under budget, high once a line moves past 5% either way (Lesson 118). PivotTables then add totals, a monthly trend, department views and a department-by-month heat map, and a KPI card shows budget utilisation (Lesson 120, Lesson 121).

Does the course teach financial modelling in Excel?

The Complete Excel Course with AI Integration teaches it by having you build two working financial models, with the habits of good modelling built in. FinanceGuard is written in dynamic arrays, so it recalculates the moment its tables change. WealthFlow keeps every assumption in one block, turns the yearly return into a monthly rate and, through Fisher's equation, into a real return, sets real values beside nominal ones and switches phases with IF (Lesson 133), so one changed input reruns the whole plan. NPV, IRR, PMT, depreciation, Goal Seek, Solver and three-statement models are not in the lessons; the SWP sheet's row, last balance plus a period's return minus the payment (Lesson 130), is the very row a loan balance follows, so the method carries over.

Can Excel clean the exports my finance system produces?

Build the clean-up once and it runs again on every refresh: that is what the Power Query lessons of The Complete Excel Course with AI Integration give you. SalesFusion imports a messy CSV export (Lesson 155), strips money symbols, commas, NA and fake error text, sets proper number types, turns numbers written as words into figures, evens out a discount column that mixes whole percentages with decimals, and clears out a date that cannot exist (Lesson 157 to Lesson 159). A Group By query then checks totals and row counts by month and region (Lesson 161), and From Folder takes in every new file dropped into a folder (Lesson 166). The lessons use sales exports; a ledger or bank export goes through the very same pipeline.

Can a macro catch figures stored as text before they reach a report?

FormatWizard, the macro you write in The Complete Excel Course with AI Integration, is built for it: it asks IsNumeric of every row's per-unit figure and writes Units invalid wherever the answer is False, colouring both the culprit and its flag cell (Lesson 150). The same run flags missing regions and salespeople, clears the last run's flags first and explains any error in plain English through its handler (Lesson 152). FormatWizard practises on a sales sheet; pointing the same check at an amount column of your own export means changing one column letter, and the macro then guards each file before a total is built on it.

Does the course cover personal finance as well, such as SIPs and retirement?

Yes: WealthFlow, the retirement simulator you build in The Complete Excel Course with AI Integration, is personal finance built as a proper model, and it is yours, with no website, app or other software between you and your plan. A SIP grows with FV and steps up every year (Lesson 128); an SWP draws an income that climbs each year while columns in today's money show what both are really worth (Lesson 130, Lesson 131); and a lifetime sheet follows you year by year from a start age to the end age you set, so stopping contributions early, drawing less or starting withdrawals later is tested in seconds (Lesson 134). The lessons teach the model, not financial advice, and every assumption stays yours to change. The finished WealthFlow workbook is free by email from the course page: open it and see the whole model before you build your own.

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.