Lesson 1
Introduction
2 min
Build the Excel workbooks companies actually run on, with AI.
Dashboards, Power Query and DAX, macros and VBA, and AI with Copilot, ChatGPT and Claude.
30,000+ students in 175 countries
14-day money-back guarantee · Lifetime access · Certificate of Completion
Sagnik Bhattacharya Founder of Coding Liquids
Virginia Thorn Primetime Emmy Award winner What you will learn
Projects
You build 14 industry-standard projects in the course. Each was designed after talking with people who do this work across many industries. Here is what twelve of them look like.
Project 09
The budget vs actual report finance teams send every month.
Budget vs actual with SORT, UNIQUE, VSTACK, LET, TEXTSPLIT and SUMIFS, a variance engine and custom number formats.
Project 14
AI finds and fixes the formula; you check it before it counts.
Copilot, ChatGPT and Claude on real tasks, plus the COPILOT function, Copilot Guided Help, Microsoft Stride and Claude in Excel.
Project 08
One screen that shows which campaigns earn back their spend.
A marketing dashboard with six PivotTables, KPI cards, charts, a timeline and slicers.
Project 10
A retirement plan that shows how long the money lasts.
SIP and SWP calculators and a lifetime retirement simulator.
Project 12
A sales report that refreshes itself from a folder of files.
Power Query ETL, a Power Pivot data model, DAX measures and a report built from the data model.
Project 07
One sheet that shows what is done, what is late and what is urgent.
A project tracker with data validation, conditional formatting, a Gantt-style timeline and sheet protection.
Project 13
The weekly report routine, run by a flow instead of by you.
Power Automate Desktop flows that read, write and check Excel for you.
Project 11
One click that checks a whole sheet for you.
Recorded macros, then VBA with loops, validation rules and Debug.Print.
Project 05
A sales question answered in seconds, straight from the order data.
PivotTables, PivotCharts, slicers and Refresh All on order-level sales data.
Project 06
Employee data joined across sheets with one formula.
VLOOKUP, XLOOKUP, INDEX MATCH, text and date functions, dynamic arrays.
Project 04
Nine charts, each picked for the question it answers.
Every chart type and when to use it.
Project 01
Your first workbook: where the money goes each month.
Your first formulas, conditional formatting, charts and a SIP calculator.
Excel Tables, sorting, filtering, data cleaning, text functions and drop-down lists.
IF, IFS, AND, OR, SUMIF, COUNTIF, SUMIFS, COUNTIFS and date functions.
Virginia Thorn
Primetime Emmy Award winner
Sagnik Bhattacharya
30,000+ students from 175 countries
Free preview lessons
These lessons are free to watch in full, so you can judge the teaching before you pay anything.
Lesson 1
2 min
Lesson 2
What you will learn in this Excel and AI course
5 min
Lesson 3
Ribbon, tabs, name box, formula bar and navigation
13 min
Lesson 4
Add, rename, move and navigate sheets
6 min
Free by email
In this section
Curriculum
17 sections · 186 lessons · 16 hours
You start from zero: the Excel window, workbooks and sheets, entering data and formatting numbers and cells. Then you write your first formulas (SUM, AutoSum, percentages and cell references) and fix common errors while building a personal budget.
In your first guided project, you turn a personal budget into a working tracker with totals and averages, colour-coded warnings, a monthly summary by category and a pie chart. You finish with a calculator that shows how a monthly investment grows over time.
Using a sample employee database, you keep a long list of records under control with Excel tables, sorting, filtering and data clean-up. You also remove duplicates, split names and columns automatically, keep headers in view while scrolling and print neatly.
You learn the formulas people use every day: IF and its relatives for yes-or-no decisions, and COUNT, SUMIF, COUNTIF and their multi-condition versions for quick summaries. You finish with date and time functions and how to find any function you need.
You combine and clean text with functions such as CONCAT, TEXTJOIN, TRIM, PROPER and SUBSTITUTE, and stop bad data at the source with drop-down lists. You finish with a Ninja Challenge on a messy employee list.
You choose the right chart and build it well: column, line, pie and combo charts, clean formatting and sparklines (tiny charts inside cells). You also use Excel's modern business charts, such as funnel, Pareto, waterfall, histogram and treemap.
You summarise thousands of rows with PivotTables: prepare the data, build and arrange the table, group by date, add slicers (clickable filters) and PivotCharts, then style the report and refresh it when the data changes. You finish with a challenge on sales by region, category and month.
Working with an HR dataset, you look up data with VLOOKUP, XLOOKUP, INDEX and MATCH, handle errors, combine and split text, and calculate working days. You then use the dynamic array functions UNIQUE, FILTER, SORT and SORTBY, and finish with a lookup challenge.
You build TaskFlow, a task tracker with drop-down lists for status and priority, highlighting for overdue work, a Gantt chart timeline and a count of the days left to each deadline. Then you protect the sheet against accidental edits and test it with sample data.
You get practical work out of AI assistants in Excel: prepare your data, write clear prompts and have Copilot, ChatGPT and Claude produce summaries, PivotTables, charts, formulas and a mini dashboard, checking the output at every step. You also try the COPILOT function and Microsoft's newer agent that builds workbooks.
In this marketing project, you clean campaign data, plan the key numbers with ChatGPT and Copilot, and calculate click-through rate, conversion rate and return on investment. You then build an interactive dashboard with PivotTables, charts, KPI cards (headline-number tiles), slicers and a timeline.
In this finance project, you compare budget with actual spending, building the model with modern formulas. You then add variance calculations, colour-coded number formats, PivotTables, KPI cards, a combo chart and slicers to make a dashboard that shows where the money went.
In this personal-finance project, you model monthly investing (including plans that step up each year), retirement withdrawals and the effect of inflation with FV and IF formulas and an assumed yearly return. You then test the plan against tougher scenarios and build a retirement simulator dashboard with Claude's help.
You automate repetitive work by recording macros, running them from a button and saving macro-enabled workbooks. Then you write your own VBA code with variables, If statements and loops to check a sales sheet, highlight problems and handle errors.
With Power Query, you turn messy data from many CSV files into one clean model: clean columns and text, fix data types, merge and stack tables, combine a whole folder of files at once and reshape wide tables. You then build a Power Pivot data model with relationships and DAX measures (Power Pivot's formula language) to feed PivotTable reports and an interactive dashboard.
You automate Excel chores with Power Automate Desktop: build your first flow, connect it to Excel, read worksheet data, start from templates or the recorder, and add conditions, approvals and loops. You also run a flow from a desktop shortcut or a link.
A closing lesson recaps what you have learnt across the course.
Instructors
Instructor, Excel with AI
Emmy Award winner. Teaches Excel with AI at Coding Liquids.
Pick your job, goal, level, topic or comparison to see the lessons and projects that matter to you.
The Complete Excel Course with AI Integration is an online video course from Coding Liquids: 16 hours of video in 186 lessons, built around 14 projects. Build the industry-standard Excel workbooks companies actually run on: budget vs actual dashboards, clean HR data, Power Query and DAX models, macros and VBA, and AI with Copilot, ChatGPT and Claude. Hands-on from lesson one, taught by Sagnik Bhattacharya and Emmy Award winner Virginia Thorn. Free preview lessons. Every purchase includes lifetime access, a Certificate of Completion with a verification link and a 14-day money-back guarantee.
Most Excel courses teach you buttons. This one makes you build the workbooks companies actually run on: a budget vs actual dashboard that explains the gap, an HR database joined across sheets, a sales report that refreshes in one click, a Power Query pipeline with a data model and DAX measures, macros that check a whole sheet for you, and Copilot, ChatGPT and Claude doing the heavy lifting while you stay in control.
Every project is industry standard. Each was designed after talking with people from many different industries about the workbooks their work depends on. Together they take you through the entire data analysis workflow in Excel, end to end, from raw data to a finished dashboard.
Hands-on from the first lesson. You open the starter workbook, build along with us step by step, and finish every section with a workbook you made yourself. Nothing here is a feature tour. Every function, chart and tool is learned because the project in front of you needs it.
VLOOKUP, XLOOKUP, INDEX MATCH, SUMIFS, COUNTIFS, PivotTables, slicers, dashboards, data cleaning, Power Query, ETL, Power Pivot, data modelling, DAX, dynamic arrays, macros, VBA, Power Automate, Copilot in Excel. You do not memorise them. You use each one to finish a project, which is how they stick.
None of the instructors’ voices are AI-generated. Every lesson is recorded and taught by Sagnik Bhattacharya and Virginia Thorn themselves.
Your first project starts in lesson one.
What you get
Come back to any lesson whenever you need it, with future updates included.
A PDF certificate with a verification link, emailed when you finish.
Every section ends with something you built: a dashboard, an app screen, an automation.
Two months of questions answered by the instructor, plus Ask AI in every lesson for immediate answers drawn from that lesson, labelled as AI. Activate it whenever you choose.
Several seats at a per-seat discount, with a team area to follow progress.
Questions
Yes. It starts from zero, with the Excel window and your first spreadsheet, and teaches one skill per short lesson, each building on the last, until you are building dashboards, automations and AI workflows of your own. Experienced users can go straight to the section they need.
Yes. Most of the course is past the basics: lookups and dynamic arrays such as XLOOKUP, FILTER, UNIQUE and LET, dashboards with PivotTables and slicers, a budget vs actual model, Power Query with a data model and DAX, macros and VBA, Power Automate Desktop, and AI with Copilot, ChatGPT and Claude. Start from the section you need, and with lifetime access the course stays on hand to look any technique up the moment work asks for it.
A tutorial shows one feature and leaves you to join the dots. This course is one path from your first spreadsheet to finished, industry-standard workbooks: every lesson builds on the one before, each project comes with a starter and a finished file, section quizzes check what stuck, and you finish with a Certificate of Completion. With the instructor support plan, the instructor answers your questions, which no video ever will.
Yes. The projects are the reports those teams build, each an industry-standard workbook: a budget vs actual dashboard for finance, an employee database and an HR workbook with lookups, a sales goal tracker and a sales performance report with PivotTables, and a marketing dashboard with CTR, conversion rate and ROI.
The course is recorded in the latest version of Excel, Microsoft 365, on Windows or Mac. Most lessons also work in older versions, and the few functions that need a newer one are pointed out when they appear. The Power Pivot and Power Automate sections need Windows.
No. You need to buy no AI account to learn from this course: the AI section shows Copilot, ChatGPT and Claude side by side on the same tasks, and you can simply watch. To try them yourself, a free ChatGPT account covers the ChatGPT lessons and a free Claude account covers about half of the Claude lessons; Claude in Excel needs a paid Claude plan and Copilot a Microsoft 365 plan that includes it. Both are optional, and the lessons advise watching first and buying only what your work needs.
The Complete Excel Course with AI Integration does. Its AI section shows Copilot, ChatGPT and Claude on the same tasks: formulas, PivotTables, charts, cleaning data and analysis, with a checklist for checking an AI answer before you rely on it. Later projects use them again, and in one lesson Claude builds a dashboard.
Yes. The SalesFusion project covers Power Query, a Power Pivot data model and DAX measures. The FormatWizard project covers recorded macros and VBA, and AutoFlow adds Power Automate Desktop. All of it is in this one course, after the formulas, charts and PivotTables it builds on.
Yes, the entire workflow, end to end, from raw data to a finished dashboard. You clean a messy export, check and total it with formulas, chart it, summarise it in PivotTables, join tables with lookups, put Copilot, ChatGPT and Claude to work on the analysis, and finish with Power Query, a Power Pivot data model and DAX measures feeding an interactive dashboard. Every stage is built on an industry-standard project. Power Pivot needs Excel for Windows.
Yes. WealthFlow, the retirement simulator of this course, is yours to build: a SIP calculator with a yearly step-up, an SWP calculator whose withdrawals rise with inflation, and a lifetime simulator that joins the saving years to the withdrawal years, with charts that redraw the moment you change an input. Every formula is in view and every assumption is yours to change, so you depend on no website, app or other software, only Excel. The finished workbook is free by email from this page.
Lifetime access: buy once and it is yours. Come back to any lesson the moment work asks for it, on any device, and every future update to the course is included.
Yes. When you complete the course, your Certificate of Completion is emailed to you as a PDF, with a verification link an employer can check and you can share on LinkedIn. Behind it stand the industry-standard projects you built, ready to open in an interview.
Both give you the full course with lifetime access, every project and the Certificate of Completion. The option with instructor support adds a teacher at your side: two months of your questions answered by the instructor in writing, through the inbox under each lesson, plus Ask AI in every lesson for those two months. The two months start on the day you switch them on, not the day you buy, so you can begin whenever you are ready.
Yes. With the instructor support plan you are never stuck alone: every lesson has an Ask AI button that answers immediately from that lesson's material, and you can send your question to the instructor through the inbox under the lesson and get the answer in writing.
Yes. Every project comes with a starter file and a finished file inside the course, so you build along step by step and can compare your result.
Yes, taught in English with English captions. Audio in Hindi, Bengali, Spanish and German is planned, and one purchase will include every language.
Yes. One whole section, Managing data in Excel, is free with every lesson and its practice files, and so is the finished WealthFlow retirement simulator workbook. Ask for both by email on the course page, confirm your address, and they open in your account. The course page also has free preview lessons.
You are covered by a 14-day money-back guarantee. Details are in the refund policy.
Yes. Team plans give each person a seat of their own at a per-seat discount, with a team area where you add people and follow their progress, so a whole team builds the same industry-standard workbooks.
Yes. Every project is an industry-standard workbook of the kind companies run on, and each was designed after talking with people from many different industries. You build a budget vs actual dashboard, an HR workbook joined across sheets, a marketing KPI dashboard, a sales report that refreshes from a folder of files, a retirement simulator, a macro that checks a whole sheet and a Power Automate flow, each from a starter workbook, with the finished one to compare against.
Ready?
Regular price $129 now $79
for lifetime access, or Regular price $180 now $120
with two months of instructor support and Ask AI, started whenever you choose. 14-day
money-back guarantee.
Questions first? Contact us or chat on WhatsApp.