The Complete Excel Course with AI Integration

Excel course for intermediate users

You can enter data, write a SUM and make a chart, yet a lookup, a PivotTable or a drop-down list still sends you searching. The Complete Excel Course with AI Integration is built for that moment twice over: short lessons that each teach one skill, numbered through the course and yours with lifetime access, so the answer is there the instant work asks; and the techniques after the basics, each taught on an industry-standard project. Pick the run today's task needs, and keep the rest for the day you need it.

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:

  • Total and count by several conditions with SUMIFS and COUNTIFS, and sort records into tiers with IFS, AND and OR.
  • Turn a raw list into an Excel table with a total row, then clean it with TRIM, Remove Duplicates, Flash Fill and Text to Columns.
  • Join lists across sheets with XLOOKUP or INDEX and MATCH, with IFERROR catching anything not found.
  • Summarise thousands of rows in a PivotTable by year, quarter and month, filter it with slicers and refresh it when the data changes.
  • Pull distinct, filtered and sorted lists that update themselves with UNIQUE, FILTER, SORT and SORTBY.
  • Record a formatting macro, run it from a button and keep it in a macro-enabled workbook.

Projects

What you will build.

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

  • Project 05

    SalesPlusPerformance

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

    PivotTables the way reports use them, on order data: years, quarters and months from one date field, slicers, PivotCharts and a refresh when new rows arrive.

  • Project 06

    PeopleInsight HR workbook

    Employee data joined across sheets with one formula.

    Lookups and live lists on staff records: XLOOKUP with a fallback, INDEX and MATCH, then UNIQUE, FILTER and SORTBY lists that rebuild themselves.

  • Project 04

    Marketing Engagement Dashboard

    Nine charts, each picked for the question it answers.

    Charts past column and pie: combos on two axes, sparklines inside cells, and waterfall, funnel, Pareto, histogram and box and whisker charts for business data.

  • Project 09

    FinanceGuard

    The budget vs actual report finance teams send every month.

    Modern formulas at full strength: LET, VSTACK, TEXTSPLIT and SUMIFS in a budget model, and custom number formats that colour the variances.

  • Project 11

    FormatWizard

    One click that checks a whole sheet for you.

    Its first lessons need no code at all: record a macro, make it relative, put it on a button and save the workbook so the macro stays with it.

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

  • Project 02

    Dunder Michael Paper Company employee database

    Built as an employee list, it is where a raw range becomes a table, sorted on several levels, filtered and cleaned with Flash Fill, Remove Duplicates and Text to Columns.

  • Project 03

    Sales Goal Tracker

    Built on sales targets, it drills the conditional formulas everyday reports run on: IFS tiers, AND and OR, SUMIFS and COUNTIFS, then a challenge to prove them.

Lessons

The lessons that matter, in course order.

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

Where to start

Lesson 19 Excel tables

Begin at Lesson 19, the first lesson of Managing data in Excel, a whole section free by email with its practice files, so you can judge the teaching on a real list before you buy. If copied formulas ever point at the wrong cell, watch Lesson 10 first. After that every run below stands on its own: go straight to the one today's task needs.

Get the free section by email

61 of 186 lessons · 5 h 9 min

01 Microsoft Excel fundamentals: building a foundation from scratch 1 of 13 lessons · 3 min Relative, absolute and mixed references with F4: the dollar signs that decide whether a copied formula still points where it should, and the first thing worth refreshing.
  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) 9 lessons · 1 h 1 min The whole of Managing data in Excel, free by email: an employee list made into a table with structured references and a total row, sorted on several levels, filtered by text and number, cleaned with TRIM, Paste Special values, Find and Replace, Remove Duplicates, Flash Fill and Text to Columns, with headings frozen and the sheet fitted to one printed page.
  1. 19 Start here Excel tables Create and format a table, structured references and total row 8 min
  2. 20 Sorting data in Excel Single and multi-level sort on an employee database 6 min
  3. 21 Filtering data in Excel AutoFilter, text and number filters on employee data 10 min
  4. 22 Cleaning data in Excel TRIM, Paste Special values and Find and Replace 13 min
  5. 23 Remove duplicates in Excel Find and delete duplicate rows in an employee list 6 min
  6. 24 Flash Fill in Excel Split first and last names automatically 3 min
  7. 25 Text to Columns in Excel Split data by delimiter into separate columns 6 min
  8. 26 Freeze panes in Excel Lock header rows and columns while scrolling 3 min
  9. 27 Printing in Excel Print area, page orientation, scaling and page layout 6 min
04 Essential formulas and functions (IF, SUMIF and more) 10 of 13 lessons · 1 h 3 min Formulas that decide and count for you: nested IF and IFS sort records into tiers, AND and OR pick out deals that pass several tests, and SUMIFS and COUNTIFS total by as many conditions as a question has. The Insert Function dialog finds any function you need, TODAY and MONTH handle dates, and a Ninja Challenge with its solutions puts the lot to the test.
  1. 31 Nested IF and IFS in Excel Customer value tiers with nested IF 6 min
  2. 32 Nested IF and IFS in Excel Sales performance labels with the IFS function 5 min
  3. 33 AND and OR with IF in Excel Flag high-value deals with multiple conditions 8 min
  4. 34 SUM, COUNT and COUNTA in Excel SUM with FILTER and counting numbers with COUNT 7 min
  5. 35 SUM, COUNT and COUNTA in Excel COUNTA, unique counts and completeness checks 4 min
  6. 36 SUMIF and COUNTIF in Excel Conditional sum and count with one criterion 8 min
  7. 37 SUMIFS and COUNTIFS in Excel Sum and count with multiple criteria 7 min
  8. 38 The Excel function library Insert Function dialog and Formula AutoComplete 5 min
  9. 39 Date and time functions in Excel TODAY, NOW, MONTH and date arithmetic 6 min
  10. 40 Excel Ninja Challenge COUNTIF, SUMIF, IF, COUNTIFS, SUMIFS and IFS practice 8 min
05 Text functions and data validation (enhancing data quality) 7 lessons · 35 min Text joined with CONCAT and TEXTJOIN, tidied with TRIM and PROPER, found and replaced with FIND, SEARCH and SUBSTITUTE, split with the Text to Columns wizard, then drop-down lists that stop bad entries at the source, and a messy-list challenge with its solution.
  1. 41 CONCAT, the & operator and TEXTJOIN in Excel Combine text from multiple cells 6 min
  2. 42 TRIM, UPPER, LOWER and PROPER in Excel Clean messy text and fix capitalisation 6 min
  3. 43 FIND, SEARCH and SUBSTITUTE in Excel Locate and replace text with formulas 5 min
  4. 44 Text to Columns wizard in Excel Split a column by a comma delimiter 4 min
  5. 45 Data validation in Excel Create drop-down lists for consistent data entry 4 min
  6. 46 Ninja Challenge: problem Clean messy data with text functions and validation 4 min
  7. 47 Ninja Challenge: solution PROPER, Text to Columns and drop-down lists 7 min
06 Data visualisation: charts and graphs 5 of 9 lessons · 28 min Combo charts on two axes, chart formatting, sparklines in cells, and Excel's business charts: funnel, Pareto, waterfall, histogram, box and whisker, treemap and sunburst.
  1. 52 Combo charts in Excel Column and line chart with a secondary axis 4 min
  2. 53 Formatting charts in Excel Titles, data labels, colours and chart styles 7 min
  3. 54 Sparklines in Excel Line, column and win-loss mini charts in cells 5 min
  4. 55 Funnel, Pareto and waterfall charts in Excel Modern charts for business data 5 min
  5. 56 Histogram, box and whisker, treemap and sunburst Advanced Excel chart types 6 min
07 PivotTables and PivotCharts: data analysis made easy 10 lessons · 33 min Thousands of rows summarised in seconds: PivotTables from a prepared sales table, with fields and Value Field Settings, an order date grouped by year, quarter and month, slicers, PivotCharts, report layouts and styles, a refresh when the source changes, and a challenge on region, category and month.
  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 10 of 12 lessons · 48 min XLOOKUP with an if-not-found value and a two-way lookup, IFERROR, INDEX and MATCH, TEXTJOIN, LEFT, RIGHT and MID on codes, EOMONTH and NETWORKDAYS, then UNIQUE, FILTER, SORT and SORTBY, worked on HR data, and a lookup challenge on an order sheet.
  1. 69 XLOOKUP in Excel Exact match, if not found and two-way lookup 6 min
  2. 70 IFERROR in Excel Handle lookup errors in VLOOKUP and XLOOKUP formulas 3 min
  3. 71 INDEX and MATCH in Excel A flexible alternative to VLOOKUP 6 min
  4. 72 CONCAT and TEXTJOIN in Excel Combine employee names and text with a delimiter 3 min
  5. 73 LEFT, RIGHT and MID in Excel Extract parts of a text code like DAL-SAL-0001 7 min
  6. 74 TODAY, EOMONTH and NETWORKDAYS in Excel Date calculations for HR data 5 min
  7. 75 UNIQUE function in Excel Extract a distinct list with dynamic arrays 6 min
  8. 76 FILTER function in Excel Dynamic array filtering with AND and OR criteria 5 min
  9. 77 SORT and SORTBY in Excel Sort data dynamically with formulas 4 min
  10. 78 Excel Ninja Challenge XLOOKUP, totals and text concatenation lookup challenge 3 min
10 Boosting productivity with AI in Excel (Copilot, ChatGPT and Claude) 1 of 17 lessons · 6 min Copilot and ChatGPT drafting whole formula columns for you to check: a quick way to try a function you have never written, with you still signing off.
  1. 95 Excel formulas with AI Copilot and ChatGPT write formula columns you verify 6 min
12 Project: FinanceGuard budget variance analyser (budget vs actual Excel dashboard) 3 of 10 lessons · 14 min A budget model built with LET, VSTACK, TEXTSPLIT, SORT, UNIQUE and SUMIFS, variance and percentage variance, and custom number formats that show the result in colour.
  1. 117 Budget vs actual model in Excel SORT, UNIQUE, VSTACK, LET, TEXTSPLIT, SUMIFS 8 min
  2. 118 Budget variance in Excel Calculate variance and percent variance 4 min
  3. 119 Custom number formats in Excel Show budget variances with colours and signs 2 min
14 VBA and macros in Excel: FormatWizard 5 of 17 lessons · 19 min Macros with no code: record one, switch it to relative references, run it from a button or the Quick Access Toolbar, and save the workbook in the macro-enabled format so it keeps the macro.
  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

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.

I use Excel now and then and know the basics: is this course for me?

Yes, on two counts. The Complete Excel Course with AI Integration from Coding Liquids is a course to keep: short lessons that each teach one skill, numbered from first to last and yours with lifetime access, so an instant check-up is there the moment work asks. It is also where you learn the new techniques that come after the basics: tables, SUMIFS, XLOOKUP, PivotTables with slicers, dynamic arrays and recorded macros, with a Certificate of Completion at the end. Every project is industry standard, designed after talking with people from many different industries, and the 61 lessons (5 hours 9 minutes) on this page are the ones for you.

What does intermediate Excel mean?

In The Complete Excel Course with AI Integration it means the skills that turn Excel from a grid into a working tool: references that hold when copied, tables, formulas with several conditions such as IFS and SUMIFS, lookups with XLOOKUP or INDEX and MATCH, drop-down lists, PivotTables with slicers and charts beyond column and pie. Every one is taught on a project, and every one is on this page's path. Advanced work, from Power Query and DAX to VBA, starts where they end.

Can I use the course to look something up the moment a task needs it?

Yes, and it is built for it. Every lesson in The Complete Excel Course with AI Integration teaches one skill, names it in its title and has a running number, so you go straight to the fix: copied formulas pointing at the wrong cell in Lesson 10, a lookup that fails in Lesson 70, a PivotTable missing new rows in Lesson 65. Lifetime access keeps every lesson there, and with the instructor support plan, Ask AI in each lesson answers at once from its material and the instructor answers written questions for two months from the day you switch it on.

How can I check which Excel skills I am missing?

Take the challenges first. The Complete Excel Course with AI Integration sets Ninja Challenges you solve on your own before the solution, such as Lesson 40 on IF, SUMIF and SUMIFS, Lesson 46 on cleaning a messy list and Lesson 78 on lookups, plus section quizzes that show what stuck. Whatever you solve, skip; whatever stops you points to the exact lessons to watch, listed on this page in course order. It turns a long course into your own short list.

What new Excel techniques will an occasional user pick up here?

Plenty, and each one turns a manual job into a formula or a click. In The Complete Excel Course with AI Integration: Flash Fill splitting names from one typed example (Lesson 24), IFS replacing a tangle of nested IFs (Lesson 32), TEXTJOIN joining a list with any separator (Lesson 41), sparklines inside cells (Lesson 54), waterfall and Pareto charts (Lesson 55), FILTER returning every matching row from one formula (Lesson 76) and a macro recorded without writing code (Lesson 137). Each is one short lesson away, there the day a task calls for it.

Will XLOOKUP and FILTER work in the Excel I have at work?

Yes, in a modern Excel such as Microsoft 365, the one The Complete Excel Course with AI Integration is recorded in. Its overview, Lesson 2, a free preview lesson, names XLOOKUP, the dynamic arrays and Copilot as the features that need a modern version and says the fundamentals work in older ones. On an older Excel, INDEX and MATCH (Lesson 71) with IFERROR (Lesson 70) do the same lookups, and the rest of this page works there too, from tables and SUMIFS to PivotTables and macros.

Will the course make me quicker at the Excel I already do?

Yes, and that is where it pays back first. The Complete Excel Course with AI Integration swaps the slow routines of occasional use for one-step tools: a table's total row in place of retyped SUM ranges (Lesson 19), Remove Duplicates in place of scrolling for repeats (Lesson 23), XLOOKUP in place of copying between sheets (Lesson 69), a PivotTable in place of totals built by hand (Lesson 59) and a recorded macro for formatting you repeat every week (Lesson 137).

Once lookups and PivotTables feel easy, what does the course teach next?

The tools that set you apart at work, each on a project of its own: VBA you write yourself, with variables, If tests and For Next loops, in FormatWizard; Power Query combining every file in a folder with the same clean-up, then a Power Pivot data model measured with DAX, in SalesFusion; Power Automate Desktop flows that open Excel, read a sheet, loop through rows and ask for approval, in AutoFlow; and Copilot, ChatGPT and Claude, checked before you use them. Power Pivot and Power Automate need Excel for Windows, and all of it is in The Complete Excel Course with AI Integration, ready the day you want it.

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.