The Complete Excel Course with AI Integration
Excel course for data analysts
For data analysts, and for people moving into analysis work, who want the Excel side done properly. This page picks out the analysis core of The Complete Excel Course with AI Integration: PivotTables, lookups and dynamic arrays, AI for exploring and checking data, and SalesFusion, where Power Query, a data model and DAX measures turn a folder of raw files into a report.
Taught by Sagnik Bhattacharya and Virginia Thorn
What you will be able to do
At work, you will be able to:
- Run an ETL in Power Query: import CSV files, fix data types, clean text, merge and append queries, combine a whole folder and unpivot a wide table.
- Build a Power Pivot data model with relationships, and write DAX measures for total sales, margin percent and percent of total.
- Summarise thousands of rows with PivotTables, group them by date and filter them with slicers.
- Join tables with XLOOKUP or INDEX and MATCH, and build lists that update themselves with UNIQUE, FILTER, SORT and SORTBY.
- Use Copilot, ChatGPT and Claude to plan an analysis, find outliers and draft formulas, and check every answer with a QA checklist.
Projects
What you will build.
The course has 14 projects. These four matter most here.
-
Project 12
SalesFusion
A sales report that refreshes itself from a folder of files.
A whole pipeline in one project: raw files in, a clean model and measures out, and a report that refreshes.
-
Project 05
SalesPlusPerformance
A sales question answered in seconds, straight from the order data.
Order-level data summarised by category, region and month: a first look at the data before anything else is built.
-
Project 06
PeopleInsight HR workbook
Employee data joined across sheets with one formula.
Tables joined with lookups and filtered with dynamic arrays, instead of copying between sheets.
-
Project 14
Agentic AI in Excel
AI finds and fixes the formula; you check it before it counts.
AI as an assistant you supervise: it explains and fixes a formula, and you verify the result.
Lessons
The lessons that matter, in course order.
The Complete Excel Course with AI Integration has 186 lessons. This page picks out 60 of them, 4 h 54 min of video. Each lesson keeps its number in the course.
Where to start
Lesson 57 PivotTables 101 in Excel
Begin at Lesson 57 if formulas such as IF and SUMIFS are already familiar. If they are not, begin at Lesson 28, or at Lesson 1 if Excel is new to you. If PivotTables and lookups are daily tools, go to Lesson 153, where Power Query begins.
60 of 186 lessons · 4 h 54 min
07 PivotTables and PivotCharts: data analysis made easy PivotTables: prepare the data, build and arrange the table, group by date, add slicers and PivotCharts, and refresh when the source changes.
- 57 Start here PivotTables 101 in Excel What a PivotTable does and the sales dataset 5 min
- 58 Preparing data for PivotTables Clean data with TRIM, PROPER, find and replace 5 min
- 59 Create your first PivotTable in Excel Insert a PivotTable from a sales table 1 min
- 60 PivotTable fields in Excel Rows, values, columns and Value Field Settings 2 min
- 61 PivotTable summaries in Excel Sales by product category and grouping by date 4 min
- 62 Slicers in Excel Filter PivotTables with clickable buttons 3 min
- 63 PivotCharts in Excel Create interactive charts from a PivotTable 5 min
- 64 PivotTable design Tab Report layouts, PivotTable styles and number formats 5 min
- 65 Refresh a PivotTable in Excel Update pivots when source data changes 2 min
- 66 Excel Ninja Challenge PivotTable sales by region, category and monthly trend 1 min
08 Advanced Excel functions: lookups, text and arrays Lookups and dynamic arrays on an HR dataset: VLOOKUP, XLOOKUP, INDEX and MATCH, IFERROR, then UNIQUE, FILTER with AND and OR criteria, SORT and SORTBY.
- 67 Lookup functions in Excel The PeopleInsight HR dataset and why lookups matter 2 min
- 68 VLOOKUP in Excel Find employee data across sheets with exact match 4 min
- 69 XLOOKUP in Excel Exact match, if not found and two-way lookup 6 min
- 70 IFERROR in Excel Handle lookup errors in VLOOKUP and XLOOKUP formulas 3 min
- 71 INDEX and MATCH in Excel A flexible alternative to VLOOKUP 6 min
- 72 CONCAT and TEXTJOIN in Excel Combine employee names and text with a delimiter 3 min
- 73 LEFT, RIGHT and MID in Excel Extract parts of a text code like DAL-SAL-0001 7 min
- 74 TODAY, EOMONTH and NETWORKDAYS in Excel Date calculations for HR data 5 min
- 75 UNIQUE function in Excel Extract a distinct list with dynamic arrays 6 min
- 76 FILTER function in Excel Dynamic array filtering with AND and OR criteria 5 min
- 77 SORT and SORTBY in Excel Sort data dynamically with formulas 4 min
- 78 Excel Ninja Challenge XLOOKUP, totals and text concatenation lookup challenge 3 min
10 Boosting productivity with AI in Excel (Copilot, ChatGPT and Claude) AI for analysis: prepare data for Copilot, prompt it for summaries, PivotTables, charts and formulas, find outliers, plan an analysis with ChatGPT, analyse data with Claude, and check the output each time.
- 88 AI in Excel What Copilot, ChatGPT and Claude can and cannot do 8 min
- 89 Prepare data for Copilot in Excel Tables, headers and clean structure 6 min
- 90 Copilot executive summary in Excel Summarise a dataset in seconds with AI 5 min
- 91 Copilot prompts for Excel Weak vs strong prompts and the PRO prompt pattern 5 min
- 92 PivotTables with Copilot Build an Excel PivotTable from a prompt 5 min
- 93 Charts with Copilot and ChatGPT Create and choose the right Excel chart 6 min
- 94 Conditional formatting with Copilot and ChatGPT Highlight problems in Excel 4 min
- 95 Excel formulas with AI Copilot and ChatGPT write formula columns you verify 6 min
- 96 Find outliers with Copilot in Excel Discounts, negative profit, suspect rows 7 min
- 97 Clean messy data with Copilot in Excel AI prompts plus Excel functions 4 min
- 98 Mini dashboard with Copilot in Excel KPIs, charts and slicers on one page 3 min
- 99 Check AI output in Excel A quick QA checklist for Copilot results 2 min
- 100 ChatGPT as your analysis planner Plan an Excel analysis before you build it 3 min
- 101 COPILOT function in Excel Use Copilot as a formula inside your cells 4 min
- 102 Copilot guided help in Excel Step-by-step AI help inside Excel 3 min
- 103 Microsoft Stride for Excel The Office Agent that builds workbooks for you 4 min
- 104 Claude in Excel Analyse data and build spreadsheets with Claude 7 min
15 SalesFusion: advanced data tools and a Power Query modelling system SalesFusion: the ETL workflow in Power Query (clean, fix types, merge, append, combine from a folder, unpivot), a sales fact table, a Power Pivot data model in Diagram View, DAX measures, and a PivotTable report and dashboard on the model.
- 153 SalesFusion Power Query project Excel ETL pipeline and data model overview 5 min
- 154 Introduction to Power Query in Excel The ETL workflow explained 5 min
- 155 Import a CSV with Power Query Get data from text and transform data 2 min
- 156 Clean columns in Power Query Remove and rename columns for modelling 5 min
- 157 Clean text in Power Query Trim, clean, replace values and fix text case 6 min
- 158 Data types in Power Query Fix date, whole number, decimal and text types 7 min
- 159 Date columns in Power Query Add year, month and year-month fields for reports 7 min
- 160 Business logic in Power Query Custom and conditional columns for profitability 6 min
- 161 Group By in Power Query Summarise sales by month and region to validate data 5 min
- 162 Close and Load in Power Query Connection only, table or Data Model 5 min
- 163 Merge queries in Power Query Look up product and region names with a left join 5 min
- 164 Reuse a Power Query pipeline Duplicate queries for a new year of sales data 5 min
- 165 Append queries in Power Query Combine 2024 and 2025 sales tables 3 min
- 166 From Folder in Power Query Combine every sales file in a folder automatically 9 min
- 167 From Folder automation in Power Query Profit metrics and fiscal year columns 7 min
- 168 Build a sales fact table in Power Query Merge lookups and append history 6 min
- 169 Power Pivot Data Model in Excel Relationships and Diagram View 6 min
- 170 DAX measures in Power Pivot Total sales, margin percent and percent of total 10 min
- 171 PivotTable report from the Data Model Format the SalesFusion report in Excel 5 min
- 172 Interactive Excel dashboard Data model PivotTables, slicers and styling 10 min
- 173 Unpivot columns in Power Query Turn wide month columns into a long table 8 min
Questions
Asked before starting.
Is there an Excel course for data analysts?
Yes. The Complete Excel Course with AI Integration from Coding Liquids covers the Excel side of analysis work, from PivotTables, lookups and dynamic arrays to a full Power Query, Power Pivot and DAX pipeline in SalesFusion, with AI for exploring and checking data. The 60 lessons on this page come to 4 hours 54 minutes of the course's 16 hours.
Does it teach data cleaning?
Yes, by hand, in Power Query and with AI. The Complete Excel Course with AI Integration cleans an employee database with TRIM, Remove Duplicates, Flash Fill and Text to Columns, turns the same work into repeatable Power Query steps in SalesFusion (trimming and cleaning text, replacing values, fixing data types), and uses Copilot prompts alongside Excel's own functions on messy data.
Does it cover SQL, Python or Power BI?
No. The Complete Excel Course with AI Integration stays inside Excel. Power Query, the data model and DAX carry over to Power BI, which uses the same tools, but the course has no lessons on Power BI itself, SQL or Python.
Does it teach statistics?
Only what Excel's charts show. The Complete Excel Course with AI Integration covers histogram and box and whisker charts, and finding outliers with Copilot. It has no lessons on statistical tests or regression.
How does AI fit into analysis work in the course?
As a helper whose work you check. In The Complete Excel Course with AI Integration Copilot, ChatGPT and Claude summarise a dataset, build PivotTables and charts from a prompt, draft formulas and look for outliers, and a short QA checklist is applied to what they return.
Excel with AI
See the whole course.
The Complete Excel Course with AI Integration: 16 hours of video in 186 lessons, built around 14 projects, with lifetime access, a Certificate of Completion and a 14-day money-back guarantee.
The same course