The Complete Excel Course with AI Integration

Excel course for data analysis, end to end

Take a raw export all the way to a finished, interactive dashboard: The Complete Excel Course with AI Integration teaches the entire job of data analysis in Excel, end to end. You clean and check the data, total it with formulas, chart it, summarise it in PivotTables and, once it arrives as files every month, run it through Power Query and a Power Pivot data model. Every stage is hands-on, in industry-standard projects built for work, and the lessons of each stage follow below in course order.

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 raw export into a clean, consistent Excel table in minutes: stray spaces trimmed, spellings and capitals fixed, duplicates gone, names split into columns.
  • Show with COUNT and COUNTA that no value is missing, then answer business questions with several conditions in seconds using SUMIFS and COUNTIFS.
  • Summarise thousands of rows by category and by month in a PivotTable, and pull fields across from another sheet with XLOOKUP.
  • Pick the chart that makes the insight obvious, from comparisons and trends to a histogram and a box and whisker chart of how values spread.
  • Put Copilot and ChatGPT to work on a first summary, an analysis plan and the rows that break your rules, then sign off each answer with a QA checklist.
  • Turn a folder of raw CSV files into a refreshable Power Pivot data model with Power Query and DAX, and finish with an interactive dashboard on top.

Projects

What you will build.

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

  • Project 04

    Marketing Engagement Dashboard

    Nine charts, each picked for the question it answers.

    Charts that do the analysing: a funnel for drop-off, a Pareto for the main causes, and a histogram and a box and whisker chart of session lengths.

  • Project 05

    SalesPlusPerformance

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

    Order-level sales data turned into instant answers: which region, channel and category sells most, and how sales move month by month.

  • Project 06

    PeopleInsight HR workbook

    Employee data joined across sheets with one formula.

    Location details pulled into an employee table with XLOOKUP, then distinct and filtered lists that update themselves as the data changes.

  • Project 14

    Agentic AI in Excel

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

    Copilot drafts the executive summary and hunts down rows with suspicious discounts, ChatGPT plans the questions and KPIs, and you sign off every answer.

  • Project 12

    SalesFusion

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

    Raw CSV exports taken all the way to an interactive dashboard: profiled and cleaned in Power Query, related in a data model and measured with DAX.

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

    Your first real clean-up: stray spaces, a misspelt department, mixed capitals and odd dashes in an employee list, fixed so every figure after it can be trusted.

  • Project 03

    Sales Goal Tracker

    Business questions answered in seconds: totals by product, rating and region with SUMIF, then SUMIFS and COUNTIFS stacking two conditions, and counts that prove no value is missing.

Lessons

The lessons that matter, in course order.

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

Where to start

Lesson 19 Excel tables

Begin at Lesson 19 if you know the Excel basics: that first stage, Managing data in Excel, is free by email with its practice files when you ask on the course page, so you can start analysing before you buy. New to Excel? Start at Lesson 1. Already clean and total data every day? Jump to Lesson 59 for PivotTables or Lesson 153 for Power Query.

Get the free section by email

52 of 186 lessons · 4 h 48 min

03 Managing data in Excel: sort, filter and tables (Dunder Michael Paper employee database) 9 lessons · 1 h 1 min Stage one, clean, on the Dunder Michael Paper Company employee database: a messy list becomes a table you can trust. Excel tables, sorting and filtering come first; TRIM, Find and Replace, Remove Duplicates, Flash Fill and Text to Columns then clear the errors, with headers frozen for reading down a long list and the sheet printed to one page or to PDF.
  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
04 Essential formulas and functions (IF, SUMIF and more) 4 of 13 lessons · 26 min Stage two, check and total, on the Sales Goal Tracker: SUM with FILTER, COUNT and COUNTA to show whether a column has a gap, a count of distinct products, then SUMIF, COUNTIF, SUMIFS and COUNTIFS for questions with one condition or several.
  1. 34 SUM, COUNT and COUNTA in Excel SUM with FILTER and counting numbers with COUNT 7 min
  2. 35 SUM, COUNT and COUNTA in Excel COUNTA, unique counts and completeness checks 4 min
  3. 36 SUMIF and COUNTIF in Excel Conditional sum and count with one criterion 8 min
  4. 37 SUMIFS and COUNTIFS in Excel Sum and count with multiple criteria 7 min
06 Data visualisation: charts and graphs 1 of 9 lessons · 4 min Stage three, chart, on the Marketing Engagement Dashboard: which chart suits which question, with columns to compare categories, a line for change over time and a pie for parts of a whole.
  1. 48 Choosing the right Excel chart Column, line, pie, combo and modern chart types 4 min
06 Data visualisation: charts and graphs 2 of 9 lessons · 11 min Charts that analyse: a funnel for drop-off between stages, a Pareto for the few causes behind most cases, a waterfall from a start to an end value, then a histogram, a box and whisker chart, a sunburst and a treemap.
  1. 55 Funnel, Pareto and waterfall charts in Excel Modern charts for business data 5 min
  2. 56 Histogram, box and whisker, treemap and sunburst Advanced Excel chart types 6 min
07 PivotTables and PivotCharts: data analysis made easy 3 of 10 lessons · 7 min Stage four, summarise, on SalesPlusPerformance: insert a PivotTable from the table, set rows, columns and values, choose how values are summarised in Value Field Settings, then let Excel group order dates into years, quarters and months.
  1. 59 Create your first PivotTable in Excel Insert a PivotTable from a sales table 1 min
  2. 60 PivotTable fields in Excel Rows, values, columns and Value Field Settings 2 min
  3. 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 Stage five, combine, in the PeopleInsight HR workbook: XLOOKUP with an exact match brings city, state, region and work arrangement from a lookup sheet into the employee table.
  1. 69 XLOOKUP in Excel Exact match, if not found and two-way lookup 6 min
08 Advanced Excel functions: lookups, text and arrays 3 of 12 lessons · 15 min UNIQUE, FILTER, SORT and SORTBY: distinct values, rows that meet AND or OR conditions, and sorted lists, each spilled from one formula.
  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
  3. 77 SORT and SORTBY in Excel Sort data dynamically with formulas 4 min
10 Boosting productivity with AI in Excel (Copilot, ChatGPT and Claude) 1 of 17 lessons · 5 min Stage six, AI, in the Agentic AI in Excel project: Copilot drafts a short executive summary of a sales table, with the top region and products, the trend and any data concerns, for you to verify.
  1. 90 Copilot executive summary in Excel Summarise a dataset in seconds with AI 5 min
10 Boosting productivity with AI in Excel (Copilot, ChatGPT and Claude) 5 of 17 lessons · 19 min AI on the analysis itself: Copilot lists rows above a discount threshold you set and asks you to define high before judging quantities, cleans inconsistent text and lays out a mini dashboard; a QA checklist tests the result, and ChatGPT plans the business questions and KPIs.
  1. 96 Find outliers with Copilot in Excel Discounts, negative profit, suspect rows 7 min
  2. 97 Clean messy data with Copilot in Excel AI prompts plus Excel functions 4 min
  3. 98 Mini dashboard with Copilot in Excel KPIs, charts and slicers on one page 3 min
  4. 99 Check AI output in Excel A quick QA checklist for Copilot results 2 min
  5. 100 ChatGPT as your analysis planner Plan an Excel analysis before you build it 3 min
11 MarketPulse campaign intelligence dashboard 1 of 10 lessons · 4 min Rates from totals in MarketPulse: click-through rate, conversion rate and return on investment from PivotTable sums, with IFERROR returning zero instead of an error.
  1. 109 CTR, conversion rate and ROI in Excel Marketing KPI formulas with IFERROR 4 min
12 Project: FinanceGuard budget variance analyser (budget vs actual Excel dashboard) 1 of 10 lessons · 4 min Variance of actual against budget in FinanceGuard, as an amount and as a percentage, and a column of labels that marks each row over or under budget.
  1. 118 Budget variance in Excel Calculate variance and percent variance 4 min
15 SalesFusion: advanced data tools and a Power Query modelling system 21 lessons · 2 h 7 min Stage seven, the finish: SalesFusion takes raw CSV files all the way to an interactive dashboard. Power Query imports, cleans and checks them, merges and appends them and combines a whole folder; Power Pivot relates the tables, DAX measures feed a PivotTable report and the dashboard, and unpivoting reshapes a wide export. Power Pivot needs Excel for Windows.
  1. 153 SalesFusion Power Query project Excel ETL pipeline and data model overview 5 min
  2. 154 Introduction to Power Query in Excel The ETL workflow explained 5 min
  3. 155 Import a CSV with Power Query Get data from text and transform data 2 min
  4. 156 Clean columns in Power Query Remove and rename columns for modelling 5 min
  5. 157 Clean text in Power Query Trim, clean, replace values and fix text case 6 min
  6. 158 Data types in Power Query Fix date, whole number, decimal and text types 7 min
  7. 159 Date columns in Power Query Add year, month and year-month fields for reports 7 min
  8. 160 Business logic in Power Query Custom and conditional columns for profitability 6 min
  9. 161 Group By in Power Query Summarise sales by month and region to validate data 5 min
  10. 162 Close and Load in Power Query Connection only, table or Data Model 5 min
  11. 163 Merge queries in Power Query Look up product and region names with a left join 5 min
  12. 164 Reuse a Power Query pipeline Duplicate queries for a new year of sales data 5 min
  13. 165 Append queries in Power Query Combine 2024 and 2025 sales tables 3 min
  14. 166 From Folder in Power Query Combine every sales file in a folder automatically 9 min
  15. 167 From Folder automation in Power Query Profit metrics and fiscal year columns 7 min
  16. 168 Build a sales fact table in Power Query Merge lookups and append history 6 min
  17. 169 Power Pivot Data Model in Excel Relationships and Diagram View 6 min
  18. 170 DAX measures in Power Pivot Total sales, margin percent and percent of total 10 min
  19. 171 PivotTable report from the Data Model Format the SalesFusion report in Excel 5 min
  20. 172 Interactive Excel dashboard Data model PivotTables, slicers and styling 10 min
  21. 173 Unpivot columns in Power Query Turn wide month columns into a long table 8 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.

Which Excel course should I take for data analysis?

The Complete Excel Course with AI Integration from Coding Liquids covers the entire data analysis workflow in Excel, end to end, from raw data to a finished dashboard. Every stage is taught on an industry-standard project, and each project was designed after talking with people from many different industries: you clean a raw employee list, check and total sales data, chart it, summarise it in PivotTables, combine tables with lookups, put AI to work on the analysis, and finish in SalesFusion with a data model and an interactive dashboard (Lesson 172). The route is 52 lessons, 4 hours 48 minutes, yours to keep with lifetime access.

What are the steps of data analysis in Excel?

Clean it, check it, total it, chart it, summarise it, combine it, then automate it. In The Complete Excel Course with AI Integration that means TRIM and Find and Replace (Lesson 22) and Remove Duplicates (Lesson 23); COUNT and COUNTA (Lesson 35); SUMIFS and COUNTIFS (Lesson 37); the chart that fits the question (Lesson 48); a PivotTable with dates grouped by month (Lesson 61); XLOOKUP (Lesson 69); and, when the data keeps coming, Power Query cleaning (Lesson 157) feeding a data model report (Lesson 171), so the same analysis reruns on new data with one refresh.

Do I need to know Excel before I learn data analysis with it?

No. The Complete Excel Course with AI Integration starts from zero and teaches the basics first: the Excel window (Lesson 3), entering and formatting data, SUM, cell references and the common errors, then a personal budget project. This path picks up straight after them at Excel tables (Lesson 19), so if you can already write a formula and copy it down a column, start there. And you need not learn alone: on the instructor support plan, the instructor answers your written questions under every lesson for two months, from the day you switch it on.

How do I check my data is right before I analyse it?

Count it, profile it and test the totals, the analyst's habit The Complete Excel Course with AI Integration builds from the cleaning lessons to the last query. COUNT and COUNTA show whether every row of a column holds a value (Lesson 35), and a SUMIF whose range stops short is caught by checking its total (Lesson 36). In Power Query, column quality and distribution expose errors, empty cells and distinct values across a whole folder of files (Lesson 166), and a Group By query totals sales and rows by month and region so a wrong figure stands out before it reaches a report (Lesson 161).

How do I find outliers or suspicious rows in my data?

Set the rule, then let Excel and AI do the hunting. In The Complete Excel Course with AI Integration, Copilot lists every row above a discount threshold you give it, asks what high means before it judges quantities, and applies the interquartile range when you ask for unusually high values (Lesson 96). A box and whisker chart then lays out the spread and the extremes of each group side by side (Lesson 56), so an odd value jumps out before you write a single prompt.

Which charts should I use to analyse data in Excel?

The chart that makes the insight obvious, and The Complete Excel Course with AI Integration teaches you to pick it. The rule comes first (Lesson 48): columns compare categories, a line follows change over time, a pie shows parts of a whole. Then the analyst's charts: a funnel for drop-off between stages, a Pareto for the few causes behind most of a total, a waterfall for the rises and falls between a start and an end (Lesson 55), a histogram for how values spread and a treemap for shares within a hierarchy (Lesson 56).

Do I need Power Query for data analysis, or are formulas and PivotTables enough?

Formulas and PivotTables carry a one-off analysis; Power Query turns a report you rebuild every month into one you simply refresh. It records each cleaning step and replays it on new data, and The Complete Excel Course with AI Integration teaches both in that order: PivotTables early (Lesson 59), then SalesFusion, where a query built for one year is pointed at the next year's file and replays every step (Lesson 164), and a whole folder of sales files is combined in one query (Lesson 166).

What will I have built by the end of the data analysis lessons?

A finished, interactive sales dashboard built from raw files. In The Complete Excel Course with AI Integration, messy CSV exports are combined and cleaned in Power Query, related in a Power Pivot data model, measured with DAX and laid out as PivotTables by category, region, month and top products under shared slicers (Lesson 172). On the way you build a clean employee table, PivotTable summaries, a set of analysis charts and a Copilot mini dashboard, each project with a finished workbook to check yours against, and completing the course earns a Certificate of Completion.

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.