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
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.
-
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.
52 of 186 lessons · 4 h 48 min
03 Managing data in Excel: sort, filter and tables (Dunder Michael Paper employee database) 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.
- 19 Start here Excel tables Create and format a table, structured references and total row 8 min
- 20 Sorting data in Excel Single and multi-level sort on an employee database 6 min
- 21 Filtering data in Excel AutoFilter, text and number filters on employee data 10 min
- 22 Cleaning data in Excel TRIM, Paste Special values and Find and Replace 13 min
- 23 Remove duplicates in Excel Find and delete duplicate rows in an employee list 6 min
- 24 Flash Fill in Excel Split first and last names automatically 3 min
- 25 Text to Columns in Excel Split data by delimiter into separate columns 6 min
- 26 Freeze panes in Excel Lock header rows and columns while scrolling 3 min
- 27 Printing in Excel Print area, page orientation, scaling and page layout 6 min
04 Essential formulas and functions (IF, SUMIF and more) 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.
- 34 SUM, COUNT and COUNTA in Excel SUM with FILTER and counting numbers with COUNT 7 min
- 35 SUM, COUNT and COUNTA in Excel COUNTA, unique counts and completeness checks 4 min
- 36 SUMIF and COUNTIF in Excel Conditional sum and count with one criterion 8 min
- 37 SUMIFS and COUNTIFS in Excel Sum and count with multiple criteria 7 min
06 Data visualisation: charts and graphs 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.
- 48 Choosing the right Excel chart Column, line, pie, combo and modern chart types 4 min
06 Data visualisation: charts and graphs 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.
- 55 Funnel, Pareto and waterfall charts in Excel Modern charts for business data 5 min
- 56 Histogram, box and whisker, treemap and sunburst Advanced Excel chart types 6 min
07 PivotTables and PivotCharts: data analysis made easy 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.
- 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
08 Advanced Excel functions: lookups, text and arrays 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.
- 69 XLOOKUP in Excel Exact match, if not found and two-way lookup 6 min
08 Advanced Excel functions: lookups, text and arrays UNIQUE, FILTER, SORT and SORTBY: distinct values, rows that meet AND or OR conditions, and sorted lists, each spilled from one formula.
- 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
10 Boosting productivity with AI in Excel (Copilot, ChatGPT and Claude) 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.
- 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) 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.
- 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
11 MarketPulse campaign intelligence dashboard 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.
- 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) 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.
- 118 Budget variance in Excel Calculate variance and percent variance 4 min
15 SalesFusion: advanced data tools and a Power Query modelling system 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.
- 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
Instructors
Who teaches it.
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.
By job
Finance and accounting
- Accountants and finance teams
- Bookkeepers and accounts assistants
- FP&A and budget analysts
- Auditors and fraud examiners
- Payroll administrators
- Tax accountants and advisers
- Banking professionals
- Cost and management accountants
- Financial controllers
- Credit control and receivables teams
- Accounts payable teams
- Financial planners and advisers
- Credit analysts and loan officers
- Insurance underwriters
- Insurance claims handlers
- Reconciliation analysts
- Treasury analysts
- Medical billing and coding specialists
- Fund accountants
- Billing administrators
- AML and KYC analysts
- Actuarial analysts
- Insurance agents and brokers
- Retirement planners
HR and office administration
Operations and supply chain
- Operations and project managers
- Procurement and purchasing officers
- Logistics coordinators
- Inventory controllers and storekeepers
- Supply chain analysts
- Warehouse managers and supervisors
- PMO analysts
- Import and export coordinators
- Production planners
- Demand planners
- Fleet and transport managers
- Apparel merchandisers
Data and reporting
Sales, marketing and customer service
Business and management
Engineering, construction and manufacturing
- Quantity surveyors and estimators
- Civil and site engineers
- Quality managers and engineers
- Construction project managers
- Health and safety officers
- Document controllers
- Production managers and supervisors
- Mechanical and electrical engineers
- Industrial engineers
- Planning engineers
- Sustainability and ESG analysts
- Maintenance planners
Retail, property and hospitality
Healthcare and life sciences
Education and careers
Public sector, non-profit and legal
By goal
- Instructor support
- Certificates
- How long it takes
- Is Excel worth learning
- A retirement calculator
- A budget tracker
- A task tracker
- A KPI dashboard
- A budget vs actual report
- A sales goal tracker
- An employee database
- A chart dashboard
- An employee lookup
- A self-refreshing sales report
- A checking macro
- A Power Automate flow
- A compound interest calculator
- A SIP calculator
- An Excel test for a job
- A step-up SIP calculator
- Practice exercises
- Excel skills for a CV