The Complete Excel Course with AI Integration

A paid Excel course or free tutorials?

Free videos and Microsoft's own help pages answer one Excel question at a time, and often answer it well. The Complete Excel Course with AI Integration turns those answers into a working skill: you build industry-standard projects yourself, in an order where every lesson builds on the last, with practice files and Ninja Challenges that make it stick. Each project was designed after talking with people from many different industries. Below: what you can try free, and where the course makes you do the work.

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 long employee list into a clean, sorted and filtered Excel table, starting free with the section sent by email.
  • Find the function a task needs with Insert Function, and fill in its arguments while Excel previews the result.
  • Crack Ninja Challenges on your own, from conditional sums to lookups and PivotTables, and check every answer against the solution file.
  • Clean messy names, emails and IDs with TRIM, PROPER and CONCAT, then lock entries down with drop-down lists.
  • Build a Power Automate Desktop flow on Windows that reads a sheet row by row and flags the rows that match.
  • Know which AI assistant is worth paying for, once you have seen Copilot, ChatGPT and Claude at work in Excel.

Projects

What you will build.

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

  • Project 10

    WealthFlow

    A retirement plan that shows how long the money lasts.

    Its finished simulator workbook is free by email too: open a complete retirement calculator, change its assumptions, then build your own in the paid lessons.

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

    Free to build before you pay: the lessons on tables, sorting, filtering and clean-up for this employee database are the section sent by email, practice files included.

  • Project 03

    Sales Goal Tracker

    Where the first Ninja Challenge waits: sales data and a list of conditional sums, counts and labels to crack with hints, then a solution file to check yourself against.

Lessons

The lessons that matter, in course order.

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

Where to start

Lesson 1 Introduction

Start free at Lesson 1: the free preview lessons play on the course page. Then ask there for Managing data in Excel, a whole section that is free by email with its practice files, and build along on your own screen. From Lesson 38 on, this path is in the paid course, where Ninja Challenges turn watching into doing.

Get the free section by email

21 of 186 lessons · 2 h 7 min

01 Microsoft Excel fundamentals: building a foundation from scratch 4 of 13 lessons · 25 min The free preview lessons on the course page: what the course is, a tour of its three parts with advice on how to work through them, then the Excel window, workbooks and sheets.
  1. 1 Start here Introduction Free preview 2 min
  2. 2 Course overview What you will learn in this Excel and AI course Free preview 5 min
  3. 3 The Excel interface Ribbon, tabs, name box, formula bar and navigation Free preview 13 min
  4. 4 Workbooks and worksheets in Excel Add, rename, move and navigate sheets Free preview 6 min
03 Managing data in Excel: sort, filter and tables (Dunder Michael Paper employee database) 9 lessons · 1 h 1 min Free by email with its practice files: an employee database turned into an Excel table, sorted, filtered and cleaned with TRIM, Remove Duplicates, Flash Fill and Text to Columns, with frozen headers and print settings to finish.
  1. 19 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) 1 of 13 lessons · 5 min Excel's own guide to its functions: Insert Function finds one from a plain description of the task, then builds the formula argument by argument with a preview.
  1. 38 The Excel function library Insert Function dialog and Formula AutoComplete 5 min
04 Essential formulas and functions (IF, SUMIF and more) 1 of 13 lessons · 8 min A challenge file of conditional sums, counts and labels on sales data, with hints: every task answered by you before the solution file and the walkthrough.
  1. 40 Excel Ninja Challenge COUNTIF, SUMIF, IF, COUNTIFS, SUMIFS and IFS practice 8 min
05 Text functions and data validation (enhancing data quality) 2 of 7 lessons · 11 min A messy employee list to fix alone, from mixed-case names and badly typed emails to inconsistent IDs, then the solution lesson with TRIM, PROPER, CONCAT, Text to Columns and drop-down lists.
  1. 46 Ninja Challenge: problem Clean messy data with text functions and validation 4 min
  2. 47 Ninja Challenge: solution PROPER, Text to Columns and drop-down lists 7 min
07 PivotTables and PivotCharts: data analysis made easy 1 of 10 lessons · 1 min A PivotTable challenge: sales by region, by region and category, and a monthly trend, where AI may help you understand the task but should not write the answer.
  1. 66 Excel Ninja Challenge PivotTable sales by region, category and monthly trend 1 min
08 Advanced Excel functions: lookups, text and arrays 1 of 12 lessons · 3 min Lookup tasks on orders and products: product names and details brought in with XLOOKUP, line totals and formatted order IDs, tried before the solution is shown.
  1. 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 · 8 min What Copilot, ChatGPT and Claude can and cannot do, which of them work inside Excel and which outside it, and the advice to watch the AI lessons before paying for any of them.
  1. 88 AI in Excel What Copilot, ChatGPT and Claude can and cannot do 8 min
16 Power Automate: weekly sales report automation 1 of 12 lessons · 5 min The Power Automate Ninja Challenge in Power Automate Desktop, a Windows app: a flow that reads each client's status and flags the onboarded ones, built alone before the walkthrough.
  1. 185 Power Automate Ninja Challenge Flag onboarded rows with loop, read, if, write 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.

How can I learn Excel for free?

Free videos and Microsoft's own help pages explain any single function well, and The Complete Excel Course with AI Integration from Coding Liquids lets you begin for free too: the free preview lessons play on its page, and Managing data in Excel is free by email with its practice files. Where free material leaves you to plan the route yourself, the course hands you one, from your first spreadsheet to Power Query, VBA, Power Automate and AI. The 21 lessons on this page (2 hours 7 minutes) are the free start, then the challenges that make the skill stick.

Which Excel course should I take when free videos have not stuck?

The Complete Excel Course with AI Integration, because it makes you do the work a video only shows. Its projects are industry-standard workbooks that you build yourself, with practice files for every project and finished workbooks to check your own against. Ninja Challenges hand you the data and the tasks before any solution: conditional sums at Lesson 40, a messy employee list at Lesson 46, PivotTables at Lesson 66. Section quizzes confirm what stuck, later projects reuse earlier functions so they stay with you, and with instructor support, two months of written answers from the instructor under every lesson, plus Ask AI, start on the day you choose.

Is the Excel with AI course free?

You can start it free. The Complete Excel Course with AI Integration is a paid course with a free way in: watch its free preview lessons on the course page, and Managing data in Excel, a whole section with its practice files, is free by email together with the finished WealthFlow retirement simulator workbook. Buying it gives you lifetime access to every other section with its workbooks, the AI lessons, the Ninja Challenges and quizzes, and completing it earns the Certificate of Completion; instructor support is an option on top. Lessons are watched online, not sold as a PDF or a download; the practice workbooks are the files you download and work in.

How do I pick the best free Excel course for me?

Hold it to the tests a good course passes: lessons that build on one another, workbooks to practise in, tasks set before the answer is shown, and recordings in a recent Excel with XLOOKUP and dynamic arrays. The Complete Excel Course with AI Integration passes every one, and you can see that before paying: its overview, a free preview lesson (Lesson 2), maps the three parts of the course and how to work through them, and Managing data in Excel arrives free by email with its practice files. Every lesson is recorded and taught by the instructors themselves.

Can I learn Excel with AI for free?

You can begin free, since Microsoft's help pages explain Copilot in Excel and a free ChatGPT account writes and explains formulas; Copilot itself needs a Microsoft plan that includes it. The Complete Excel Course with AI Integration takes you much further, putting Copilot, ChatGPT and Claude to work on the same real tasks, from formulas and PivotTables to cleaning data and a dashboard, with a checklist that catches a wrong answer before it reaches your work (Lesson 99). Its first AI lesson, Lesson 88, shows what each assistant can do before you pay for any of them, and Copilot stays optional.

Can I learn advanced Excel for free?

You can read about it free: Microsoft's references for Power Query's M language, DAX and VBA document every function. What a reference cannot do is walk you from raw files to a finished report, and The Complete Excel Course with AI Integration does exactly that: SalesFusion takes a folder of sales files through Power Query into a Power Pivot data model with DAX measures and an interactive dashboard (Lesson 166 to Lesson 172), FormatWizard grows a recorded macro into VBA with loops and an error handler, and AutoFlow hands a weekly Excel routine to Power Automate Desktop. The Power Pivot and Power Automate lessons need Windows, and you finish with the report, the macro and the flow built by your own hands, not read about.

Will I still need free tutorials after the course?

For everything its projects cover, The Complete Excel Course with AI Integration becomes the tutorial you return to: with lifetime access you go back to the lesson itself, found by its number and topic, whenever a task calls for it. LAMBDA, Python in Excel, Office Scripts and Power BI are not taught, and Microsoft keeps adding functions, so for those its help pages stay useful. The course prepares you for that too: Lesson 38 shows Insert Function, which finds a function from a plain description of the task and walks you through its arguments with a preview of the result.

Is the free section enough to learn Excel?

It is a real first step and a skill you keep, not the whole of Excel. Managing data in Excel, free by email, teaches you to keep a long list in order with an Excel table, sorting, filtering, TRIM, Remove Duplicates, Flash Fill, Text to Columns, frozen headers and print settings. The rest of The Complete Excel Course with AI Integration carries you on to formulas such as SUM and IF, charts, PivotTables, lookups, AI with Copilot, ChatGPT and Claude, macros and VBA, Power Query and Power Automate, with challenges and quizzes on the way. If the free section suits you, the full course continues in the same hands-on style.

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.