The Complete Excel Course with AI Integration

Is Excel worth learning, and is a course worth it?

Does Excel still repay the effort when Copilot, ChatGPT and Claude can write formulas, and is a course the way to learn it? If your work touches figures, lists or reports, the answer is yes to both. See why on a short tour of the industry-standard projects in The Complete Excel Course with AI Integration: clean tables, PivotTables, modern lookups, AI with checks, a first macro and Power Query, each built for 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:

  • Keep a long list in an Excel Table and clean it with TRIM, Remove Duplicates, Flash Fill and Text to Columns.
  • Summarise thousands of order rows in a PivotTable by region, channel, category and month.
  • Pull values across sheets with XLOOKUP, and make lists that rebuild themselves with UNIQUE and FILTER.
  • Have Copilot write formula columns and Claude fill a cell inside Excel, then check each result against the data.
  • Record a macro that repeats a routine in one click.
  • Combine a whole folder of files with Power Query, so that a new file needs only a refresh.

Projects

What you will build.

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

  • Project 05

    SalesPlusPerformance

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

    Drag fields into a PivotTable and a summary you would otherwise build by hand with filters appears at once.

  • Project 06

    PeopleInsight HR workbook

    Employee data joined across sheets with one formula.

    XLOOKUP with a fallback for records it cannot find, and UNIQUE and FILTER lists that rebuild themselves as the data changes.

  • Project 14

    Agentic AI in Excel

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

    Copilot, ChatGPT and Claude set to work on the same sales data, so you see what each does well and what is still yours to decide.

  • Project 11

    FormatWizard

    One click that checks a whole sheet for you.

    A recorded macro first, then VBA of your own: automation that runs in desktop Excel on Windows and on a Mac.

  • Project 12

    SalesFusion

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

    Cleaning steps recorded once in Power Query and run again on every file dropped into the folder.

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

    A long employee list sorted, filtered and cleaned inside an Excel Table: practice in keeping data tidy, which PivotTables, lookups and AI prompts all depend on.

Lessons

The lessons that matter, in course order.

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

Where to start

Lesson 19 Excel tables

Start at Lesson 19. The whole of Managing data in Excel is on this path and free by email with its practice files, so you can test Excel, and the teaching, before you pay. Never opened Excel? Watch the free preview lessons from Lesson 1 first.

Get the free section by email

26 of 186 lessons · 2 h 25 min

03 Managing data in Excel: sort, filter and tables (Dunder Michael Paper employee database) 9 lessons · 1 h 1 min Excel Tables, sorting and filters on a long employee list, then the clean-up every later tool relies on: TRIM, Remove Duplicates, Flash Fill and Text to Columns, with frozen headers and printing to finish.
  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
07 PivotTables and PivotCharts: data analysis made easy 5 of 10 lessons · 17 min PivotTables from the start: what one is for, data made ready for it, a first table from sales orders, fields in rows, columns and values, and summaries by category and by date.
  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
08 Advanced Excel functions: lookups, text and arrays 1 of 12 lessons · 6 min XLOOKUP bringing city, state, region and work arrangement into an employee sheet, with a value shown for any record it cannot find.
  1. 69 XLOOKUP in Excel Exact match, if not found and two-way lookup 6 min
08 Advanced Excel functions: lookups, text and arrays 2 of 12 lessons · 10 min Dynamic arrays: UNIQUE for a list of distinct values and FILTER for the rows that match, both spilling results that follow the data.
  1. 75 UNIQUE function in Excel Extract a distinct list with dynamic arrays 6 min
  2. 76 FILTER function in Excel Dynamic array filtering with AND and OR criteria 5 min
10 Boosting productivity with AI in Excel (Copilot, ChatGPT and Claude) 2 of 17 lessons · 14 min What Copilot, ChatGPT and Claude can and cannot do, a first Copilot summary of a sales sheet, then the tables and headers that let an assistant read your data.
  1. 88 AI in Excel What Copilot, ChatGPT and Claude can and cannot do 8 min
  2. 89 Prepare data for Copilot in Excel Tables, headers and clean structure 6 min
10 Boosting productivity with AI in Excel (Copilot, ChatGPT and Claude) 1 of 17 lessons · 6 min Copilot writing formula columns, a profit margin with IFERROR and two review flags, and ChatGPT returning a changed copy of the file, each checked before it is used.
  1. 95 Excel formulas with AI Copilot and ChatGPT write formula columns you verify 6 min
10 Boosting productivity with AI in Excel (Copilot, ChatGPT and Claude) 1 of 17 lessons · 2 min A short QA checklist for anything an assistant builds: the right data selected, dates that line up and charts tied to the right source.
  1. 99 Check AI output in Excel A quick QA checklist for Copilot results 2 min
10 Boosting productivity with AI in Excel (Copilot, ChatGPT and Claude) 1 of 17 lessons · 7 min Claude added to Excel, asking permission before it writes a profit percentage formula into a cell, then fixing an error in another column.
  1. 104 Claude in Excel Analyse data and build spreadsheets with Claude 7 min
14 VBA and macros in Excel: FormatWizard 2 of 17 lessons · 9 min What macros and VBA are, then a first macro recorded, named and run.
  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
15 SalesFusion: advanced data tools and a Power Query modelling system 1 of 21 lessons · 5 min What Power Query is: the extract, transform and load steps, and where Get Data sits in Excel.
  1. 154 Introduction to Power Query in Excel The ETL workflow explained 5 min
15 SalesFusion: advanced data tools and a Power Query modelling system 1 of 21 lessons · 9 min A whole folder of sales files combined into one query, so next month's file needs only a refresh.
  1. 166 From Folder in Power Query Combine every sales file in a folder automatically 9 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 Excel still worth learning?

Yes, for anyone whose work involves figures, lists or reports. Business systems still hand their data over as workbooks and CSV files, Microsoft keeps adding to Excel, and AI assistants now work inside it, so the skill is gaining new uses rather than fading; only work that never touches a spreadsheet can do without it. The Complete Excel Course with AI Integration from Coding Liquids teaches Excel and its AI tools together on industry-standard projects, and the 26 lessons (2 hours 25 minutes) on this page show what each part is worth.

Will AI tools replace Excel?

So far AI has moved into the spreadsheet rather than replacing it: Copilot is built into Excel, Claude works in it as an add-in, and ChatGPT reads uploaded workbooks. No one can promise how that develops, but the work is shifting from typing formulas to preparing data an assistant can read and judging what it returns, and that is exactly what The Complete Excel Course with AI Integration trains: what each tool can and cannot do at Lesson 88, then Claude analysing data and building spreadsheets inside Excel, down to writing a formula and fixing an error in the sheet, at Lesson 104.

Should I learn Google Sheets, Power BI or Python instead of Excel?

Learn the one your work runs on, and expect overlap rather than a contest: Google Sheets suits several people editing one sheet at once and opens Excel files; Power BI is Microsoft's tool for shared, interactive reports on data models; Python, with libraries such as pandas, suits analysis written as code and run again. The Complete Excel Course with AI Integration teaches Excel only and takes it far: its SalesFusion project gives you a head start on Power BI, since Power Query and DAX are the same tools Power BI uses.

Is VBA still worth learning?

Yes, for anyone who works in desktop Excel: VBA is built into Excel for Windows and Mac with no extra licence, and the macros already in a workbook run there. It does not run in Excel on the web, where Microsoft's newer Office Scripts take its place, and The Complete Excel Course with AI Integration does not teach Office Scripts; it takes you through VBA in FormatWizard instead, from a first recorded macro at Lesson 137 to a validation routine with an error handler that checks a whole sheet at Lesson 152, with Power Automate Desktop flows on Windows after it.

Are Excel courses worth paying for?

Yes, as soon as you want more than one function for one task, which a search or Microsoft's own help pages can cover. A course gives you an order to learn in, real workbooks to build and practice that shows what you have retained, and The Complete Excel Course with AI Integration does all three on projects designed after talking with people from many different industries, each with its practice files, plus Ninja Challenges, quizzes and a Certificate of Completion. Judge it first through the free preview lessons and Managing data in Excel, free by email with its practice files.

Can I learn Excel from ChatGPT or Copilot instead of a course?

Use it alongside a course rather than instead of one. An assistant explains a formula well, and Copilot can explain one inside your own workbook, but it answers only what you think to ask, gives no order to learn in, and cannot be relied on to notice its own mistakes. The Complete Excel Course with AI Integration gives you the order and the judgement, then puts AI to work as a study aid: at Lesson 102, Copilot's guided help explains Excel's features as you work, and on the instructor support plan Ask AI answers in every lesson from the course's own material.

Is this Excel course worth it if I want Excel and AI together?

Yes: The Complete Excel Course with AI Integration teaches them as one skill, not two, with a project for each part of Excel, from a personal budget tracker to the FinanceGuard dashboard and the SalesFusion Power Query model, and Copilot, ChatGPT and Claude brought back into later projects with a checklist for their answers (Lesson 99). Unless your work needs Google Sheets or Power BI rather than Excel, it suits you as a beginner or as someone who uses Excel at work already, and with lifetime access it stays open for looking things up and picking up new techniques.

Does this Excel course come with a job guarantee or placement?

It gives you something to show an employer: work you built yourself, such as the FinanceGuard budget vs actual dashboard and the SalesFusion report that refreshes from a folder of files, and a Certificate of Completion with a verification link and a QR code. The Complete Excel Course with AI Integration offers no job guarantee, placement or CV service and cannot promise what an employer decides, but you can walk into an interview, open a finished workbook and explain how you built 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.