[100% Off] The Complete Excel Guide With Ai Integration
Excel 2026: Beginner to Advanced with hands-on projects, formulas, PivotTables, dashboards and AI tools.
What you’ll learn
- Build real Excel projects and dashboards for finance, marketing, sales, HR and operations
- Use VLOOKUP, XLOOKUP, INDEX MATCH, SUMIFS, COUNTIFS, UNIQUE, FILTER and SORT
- Clean messy data and analyse it with PivotTables, Power Query, data modelling and DAX
- Automate Excel with macros, VBA and Power Automate, and boost productivity with Copilot, ChatGPT and Claude
Requirements
- Microsoft Excel on Windows or Mac (Power Pivot and Power Automate need Windows)
- No Excel experience needed
Description
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.
This course contains the use of artificial intelligence. Please note: none of the instructors’ voices are AI-generated. Every lecture is recorded and taught by the instructors themselves.
Hands-on from the first lecture. 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.
Your instructors
Sagnik Bhattacharya, founder of Coding Liquids, and Primetime Emmy Award winner Virginia Thorn teach this course together. Students from 175 countries learn with Coding Liquids.
What you will be able to do
Open a messy export and make it clean, deduplicated and consistent in minutes with TRIM, Remove Duplicates, Text to Columns, Flash Fill and Data Validation
Answer “how did the West region do last quarter?” in seconds with PivotTables, slicers and PivotCharts
Join data from separate sheets with VLOOKUP, XLOOKUP and INDEX MATCH, and build lists that update themselves with UNIQUE, FILTER and SORT
Turn a year of campaign data into a marketing dashboard with CTR, Conversion Rate and ROI
Build the budget vs actual dashboard finance teams ask for: a variance engine, KPI cards, charts and slicers
Load, clean and combine a whole folder of sales files with Power Query (ETL: Extract, Transform, Load), model them in Power Pivot and write DAX measures, the same skills Power BI uses
Record and write macros and VBA that validate a sheet in one click, and build Power Automate Desktop flows that run your weekly report for you
Use Copilot, ChatGPT and Claude inside Excel for formulas, PivotTables, charts, cleaning and analysis, with a QA checklist so a wrong answer never slips through
Model a SIP, an SWP and a full retirement plan with inflation built in
The projects you build
Every project comes with a starter file and a finished file:
Personal budget tracker: your first formulas, conditional formatting, charts and a SIP calculator
Dunder Michael Paper Company employee database: Excel Tables, sorting, filtering, data cleaning, text functions and drop-down lists
Sales goal tracker: IF, IFS, AND, OR, SUMIF, COUNTIF, SUMIFS, COUNTIFS and date functions
Marketing engagement dashboard: every chart type and when to use it
SalesPlusPerformance: PivotTables, PivotCharts, slicers and Refresh All on order-level sales data
PeopleInsight HR workbook: VLOOKUP, XLOOKUP, INDEX MATCH, text and date functions, dynamic arrays
TaskFlow: a project tracker with data validation, conditional formatting, a Gantt-style timeline and sheet protection
MarketPulse: a marketing dashboard with six PivotTables, KPI cards, charts, a timeline and slicers
FinanceGuard: budget vs actual with SORT, UNIQUE, VSTACK, LET, TEXTSPLIT and SUMIFS, a variance engine and custom number formats
WealthFlow: SIP and SWP calculators and a lifetime retirement simulator
FormatWizard: recorded macros, then VBA with loops, validation rules and Debug.Print
SalesFusion: Power Query ETL, a Power Pivot data model, DAX measures and a report built from the data model
AutoFlow: Power Automate Desktop flows that read, write and check Excel for you
Agentic AI in Excel: Copilot, ChatGPT and Claude on real tasks, plus the COPILOT function, Copilot Guided Help, Microsoft Stride and Claude in Excel
Skills recruiters search for
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.
How it is taught
Short lectures, one skill each, recorded in the latest version of Excel
Starter and complete workbooks for every project
Ninja Challenges to solve on your own, quizzes, practice tests and a practice role play
Captions on every lecture
You need Microsoft Excel on Windows or Mac (the Power Pivot and Power Automate sections need Windows). No Excel experience needed. This is not a 30-minute crash course.
Enroll now. Your first project starts in lecture one.
Author(s): Sagnik Bhattacharya, Virginia Thorn
