The Complete Excel Course with AI Integration
How long does it take to learn Excel?
16 hours of video takes you from your first spreadsheet to Power Query, VBA and AI in The Complete Excel Course with AI Integration, hands-on from the first lesson on industry-standard projects. For data analysis, the route below, from your first spreadsheet through PivotTables and lookups to Power Query, is 6 hours 56 minutes, each section with its own minutes. Count them as watching time: building along in the practice files takes longer, and that hands-on time is where the skill sets in.
Taught by Sagnik Bhattacharya and Virginia Thorn
What you will be able to do
You will be able to:
- Turn a messy list into an Excel table, then sort it, filter it and clear out its duplicates.
- Summarise a table with IF, SUMIFS and COUNTIFS, and with a PivotTable you can slice and refresh.
- Join sheets with XLOOKUP or INDEX and MATCH, and pull lists out of a table with UNIQUE, FILTER and SORT.
- Combine a folder of CSV files with Power Query and report from a Power Pivot data model with DAX measures.
- Plan your study from the minutes of each section, and test yourself on the Ninja Challenges before moving on.
Projects
What you will build.
The course has 14 industry-standard projects. These five matter most here.
-
Project 05
SalesPlusPerformance
A sales question answered in seconds, straight from the order data.
PivotTables learnt in one short section, then met again in later projects, which is where they become routine.
-
Project 06
PeopleInsight HR workbook
Employee data joined across sheets with one formula.
Lookups and dynamic arrays on an HR dataset, the step on this route that ends copying between sheets.
-
Project 12
SalesFusion
A sales report that refreshes itself from a folder of files.
The longest project on this route and the one that pays its time back: Power Query from one CSV to a folder of files, then a data model with DAX.
-
Project 02
Dunder Michael Paper Company employee database
Where to time yourself first: tables, sorting, filtering and clean-up on a long employee list, in a section you can try for free.
-
Project 03
Sales Goal Tracker
IF, SUMIFS and COUNTIFS practised on sales targets, the summary formulas later projects keep reaching for.
Lessons
The lessons that matter, in course order.
The Complete Excel Course with AI Integration has 186 lessons. This page picks out 78 of them, 6 h 56 min of video. Each lesson keeps its number in the course.
Where to start
Lesson 1 Introduction
Begin at Lesson 1; the opening lessons are free previews. To time yourself before buying, ask on the course page for Managing data in Excel, the second stage of this route: it is free by email with its practice files, and the time you take over it, building along, is a sample of your own pace.
78 of 186 lessons · 6 h 56 min
01 Microsoft Excel fundamentals: building a foundation from scratch The fundamentals from zero: the window, entering and formatting data, first formulas, SUM, cell references and the common errors.
- 1 Start here Introduction Free preview 2 min
- 2 Course overview What you will learn in this Excel and AI course Free preview 5 min
- 3 The Excel interface Ribbon, tabs, name box, formula bar and navigation Free preview 13 min
- 4 Workbooks and worksheets in Excel Add, rename, move and navigate sheets Free preview 6 min
- 5 Your first Excel spreadsheet Cells, rows, columns and data types in a budget 8 min
- 6 Number formatting in Excel Currency, date and percentage formats for a budget 5 min
- 7 Cell formatting in Excel AutoFit column width, the #### error and cell styles 6 min
- 8 Basic maths in Excel Add, subtract, multiply and divide with formulas 3 min
- 9 SUM and AutoSum in Excel Total income, expenses and savings with MAX 6 min
- 10 Relative vs absolute references in Excel Dollar signs and mixed references 3 min
- 11 Calculating percentages in Excel Each expense as a percentage of income 2 min
- 12 Common Excel errors and how to fix them DIV0, NAME, VALUE errors and IFERROR 4 min
- 13 Organising an Excel workbook Dashboard, transactions and notes sheets 2 min
03 Managing data in Excel: sort, filter and tables (Dunder Michael Paper employee database) Excel tables, sorting, filtering and clean-up with TRIM, Remove Duplicates, Flash Fill and Text to Columns on an employee list, the section given away free by email.
- 19 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) IF and IFS, AND and OR, then SUMIF, COUNTIF, SUMIFS and COUNTIFS for quick summaries, with date functions and a Ninja Challenge to finish.
- 28 Logical functions in Excel TRUE and FALSE comparisons for beginners 5 min
- 29 The IF function in Excel Pass or fail results with a single condition 3 min
- 30 IF function practice in Excel Categorise sales data with IF formulas 6 min
- 31 Nested IF and IFS in Excel Customer value tiers with nested IF 6 min
- 32 Nested IF and IFS in Excel Sales performance labels with the IFS function 5 min
- 33 AND and OR with IF in Excel Flag high-value deals with multiple conditions 8 min
- 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
- 38 The Excel function library Insert Function dialog and Formula AutoComplete 5 min
- 39 Date and time functions in Excel TODAY, NOW, MONTH and date arithmetic 6 min
- 40 Excel Ninja Challenge COUNTIF, SUMIF, IF, COUNTIFS, SUMIFS and IFS practice 8 min
07 PivotTables and PivotCharts: data analysis made easy PivotTables in short lessons: prepared data, fields, dates grouped into years, quarters and months, slicers, PivotCharts and a refresh.
- 57 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 VLOOKUP, XLOOKUP, IFERROR and INDEX with MATCH on an HR dataset, then UNIQUE, FILTER, SORT and SORTBY, ending with a lookup challenge.
- 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
15 SalesFusion: advanced data tools and a Power Query modelling system SalesFusion, the longest section of the course: Power Query from one CSV to a whole folder of files, then a Power Pivot model with DAX measures, which 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.
How long does it take to learn Excel?
With The Complete Excel Course with AI Integration from Coding Liquids, the whole way from your first spreadsheet to Power Query, VBA, Power Automate and AI is 16 hours of video across 186 lessons, every project industry standard and built with your own hands. If your goal is data analysis, the route on this page, from the fundamentals to PivotTables, lookups and Power Query, comes to 6 hours 56 minutes. Building along takes longer than the video, so count both figures as a floor, and with lifetime access the pace is yours.
Is this a good Excel course if I want to learn fast?
Yes, fast in the way that lasts. The Complete Excel Course with AI Integration keeps each lesson to one skill and lets you begin at the section a task calls for, so you watch only what you need; for analysis, the route on this page leaves the retirement simulator and the marketing dashboard for later. It is not a one-sitting overview of Excel: you build along in the workbooks from the first lesson, and that is where the skill comes from, at a pace you set.
How long does it take to learn Excel for data analysis?
6 hours 56 minutes of video for the core of it, the route on this page. The Complete Excel Course with AI Integration takes you through the entire job of analysing data in Excel, end to end, from a raw export to a finished dashboard: the fundamentals, then tables, sorting, filtering and clean-up, summaries with IF, SUMIFS and COUNTIFS, PivotTables with slicers, lookups with XLOOKUP and the dynamic arrays, and finally Power Query, Power Pivot and DAX, where Power Pivot needs Excel for Windows. The charts section, the AI section and the MarketPulse and FinanceGuard dashboards add their own time when you want them, and each ends in a workbook you built.
How long does it take to learn pivot tables?
One short section, after which a PivotTable answers a sales question in seconds. In The Complete Excel Course with AI Integration, PivotTables run from Lesson 57 to Lesson 66: preparing the data, building the table, grouping dates into years, quarters and months, slicers, PivotCharts, design and refreshing, then a challenge. The clean table they depend on is taught earlier, from Lesson 19, and the projects after them, such as MarketPulse, FinanceGuard and SalesFusion, give the practice that makes them routine.
How long does it take to learn VBA and macros in Excel?
Recording a macro is quick to learn; writing VBA takes longer, because it is programming, and The Complete Excel Course with AI Integration carries you through both in one section: recorded macros with relative references, a button and the macro-enabled file format from Lesson 137, then your own code from the VBA editor at Lesson 141, through variables, functions, If statements, loops and IsNumeric checks, to a complete validation macro with an error handler at Lesson 152. UserForms and event macros are not taught, so the section stays on VBA that checks a whole sheet for you.
How long does it take to learn Power Query?
Longer than PivotTables, because Power Query sits in the longest section of The Complete Excel Course with AI Integration, SalesFusion, where one project runs from a single CSV import to a finished report. The import itself is a short lesson, Lesson 155; the time goes on cleaning and shaping the data, then on a folder of files combined at Lesson 166, so the same steps rerun when new files arrive. Power Pivot and DAX follow near the end, from Lesson 169, and need Excel for Windows. The time repays itself: next month's report is a refresh, not a rebuild.
How many days or months will this Excel course take me?
As many as you choose, with no deadline: The Complete Excel Course with AI Integration is recorded and self-paced, with lifetime access, so there is no length in days to keep up with. As a sum, 16 hours of video watched at an hour a day is about as many days, before you build anything; building along in the practice files while the lesson plays stretches that. Whether it turns into weeks or months depends on how many days a week you give it, and every section you finish is a skill you can put to work straight away.
Does the course come with a study plan and due dates?
You get everything to plan your own weeks around your life: The Complete Excel Course with AI Integration sets out an order in which each section builds on the one before, section quizzes and Ninja Challenges that tell you a stage has stuck, and the length of every lesson in the course page's lesson list. There is no timetable, start date, due date or live class to keep pace with, so the plan is yours to set: instructor support, if you take it, starts only when you switch it on, and lifetime access keeps every lesson open for you.
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
- 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