Start learning
My learning

The Complete Excel Course with AI Integration

Excel course for complete beginners

For people who have never used Excel, or who open it and feel lost. The Complete Excel Course with AI Integration starts at the Excel window and your first spreadsheet and assumes nothing. This page picks out the beginner's path: the opening sections, from typing into a cell to your first PivotTable, each one ending with something you built.

See the plans Watch free lessons

Taught by Sagnik Bhattacharya and Virginia Thorn

What you will be able to do

At work, you will be able to:

  • Find your way around Excel: the ribbon, workbooks and sheets, cells, rows and columns.
  • Enter data and format it as money, dates and percentages.
  • Write your first formulas: add, subtract, SUM and AutoSum, percentages, and cell references that stay put when you copy a formula.
  • Fix the common errors (DIV/0, NAME and VALUE) instead of being stopped by them.
  • Keep a list in order with tables, sorting and filtering, and clean it up.
  • Make decisions and totals with IF, SUMIF and COUNTIF, draw the right chart, and summarise a table with a PivotTable.

Projects

What you will build.

The course has 14 projects. These five matter most here.

  • Personal budget tracker in Excel: spending by category with income, expense and saving totals beside a pie chart of expenses.

    Project 01

    Personal Budget Tracker

    Your first workbook: where the money goes each month.

    Your first workbook: income, expenses and savings, with a chart of where the money goes.

  • Nine Excel chart types from the Marketing Engagement Dashboard: combo, bar, funnel, Pareto, waterfall, histogram, box and whisker, sunburst and treemap.

    Project 04

    Marketing Engagement Dashboard

    Nine charts, each picked for the question it answers.

    The common chart types, each built once, so you know which one to reach for.

  • Excel PivotTables and a PivotChart of sales data (SalesPlusPerformance): net sales by product category as a column chart, with State, Region and City filters.

    Project 05

    SalesPlusPerformance

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

    Your first PivotTables: sales by category, region and month without writing a formula.

  • Project 02

    Dunder Michael Paper Company employee database

    A long employee list sorted, filtered and cleaned: the everyday work of most office jobs.

  • Project 03

    Sales Goal Tracker

    Formulas that decide and total: IF for a yes or a no, SUMIF and COUNTIF for quick summaries.

Lessons

The lessons that matter, in course order.

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

Where to start

Lesson 1 Introduction

Begin at Lesson 1. Free preview lessons on the course page let you try the teaching before you decide. After the beginner's path the same course goes on to lookups, dashboards, AI, macros and Power Query.

66 of 186 lessons · 5 h 44 min

01 Microsoft Excel fundamentals: building a foundation from scratch 13 lessons · 1 h 5 min The foundation: the Excel window, workbooks and sheets, entering data, formatting numbers and cells, your first formulas with SUM and AutoSum, percentages, cell references and fixing common errors.
  1. 1 Start here Introduction Free preview 2 min
  2. 2 Course overview What you will learn in this Excel and AI course Free preview 5 min
  3. 3 The Excel interface Ribbon, tabs, name box, formula bar and navigation Free preview 13 min
  4. 4 Workbooks and worksheets in Excel Add, rename, move and navigate sheets Free preview 6 min
  5. 5 Your first Excel spreadsheet Cells, rows, columns and data types in a budget 8 min
  6. 6 Number formatting in Excel Currency, date and percentage formats for a budget 5 min
  7. 7 Cell formatting in Excel AutoFit column width, the #### error and cell styles 6 min
  8. 8 Basic maths in Excel Add, subtract, multiply and divide with formulas 3 min
  9. 9 SUM and AutoSum in Excel Total income, expenses and savings with MAX 6 min
  10. 10 Relative vs absolute references in Excel Dollar signs and mixed references 3 min
  11. 11 Calculating percentages in Excel Each expense as a percentage of income 2 min
  12. 12 Common Excel errors and how to fix them DIV0, NAME, VALUE errors and IFERROR 4 min
  13. 13 Organising an Excel workbook Dashboard, transactions and notes sheets 2 min
02 Project: personal budget tracker 5 lessons · 29 min Your first project, a personal budget tracker: totals and averages, colour-coded warnings, a monthly summary by category, a pie chart, and a calculator that shows how a monthly investment grows.
  1. 14 SUM and AVERAGE in Excel Personal budget tracker totals and average expense 4 min
  2. 15 Conditional formatting in Excel Highlight rules, data bars and icon sets 3 min
  3. 16 Monthly expense summary in Excel Category totals for a personal budget tracker 7 min
  4. 17 Excel charts for beginners Pie chart of budget expenses by category 8 min
  5. 18 SIP growth calculator in Excel FV function for mutual fund investment growth 7 min
03 Managing data in Excel: sort, filter and tables (Dunder Michael Paper employee database) 9 lessons · 1 h 1 min Working with a long list: Excel Tables, sorting, filtering, cleaning data, removing duplicates, Flash Fill, freezing the header row and printing.
  1. 19 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) 13 lessons · 1 h 17 min The formulas people use every day: IF and its relatives for decisions, COUNT, SUMIF and COUNTIF for quick summaries, their versions with several conditions, and dates.
  1. 28 Logical functions in Excel TRUE and FALSE comparisons for beginners 5 min
  2. 29 The IF function in Excel Pass or fail results with a single condition 3 min
  3. 30 IF function practice in Excel Categorise sales data with IF formulas 6 min
  4. 31 Nested IF and IFS in Excel Customer value tiers with nested IF 6 min
  5. 32 Nested IF and IFS in Excel Sales performance labels with the IFS function 5 min
  6. 33 AND and OR with IF in Excel Flag high-value deals with multiple conditions 8 min
  7. 34 SUM, COUNT and COUNTA in Excel SUM with FILTER and counting numbers with COUNT 7 min
  8. 35 SUM, COUNT and COUNTA in Excel COUNTA, unique counts and completeness checks 4 min
  9. 36 SUMIF and COUNTIF in Excel Conditional sum and count with one criterion 8 min
  10. 37 SUMIFS and COUNTIFS in Excel Sum and count with multiple criteria 7 min
  11. 38 The Excel function library Insert Function dialog and Formula AutoComplete 5 min
  12. 39 Date and time functions in Excel TODAY, NOW, MONTH and date arithmetic 6 min
  13. 40 Excel Ninja Challenge COUNTIF, SUMIF, IF, COUNTIFS, SUMIFS and IFS practice 8 min
05 Text functions and data validation (enhancing data quality) 7 lessons · 35 min Tidy text and consistent entries: joining and cleaning text with functions, and drop-down lists that stop wrong data being typed.
  1. 41 CONCAT, the & operator and TEXTJOIN in Excel Combine text from multiple cells 6 min
  2. 42 TRIM, UPPER, LOWER and PROPER in Excel Clean messy text and fix capitalisation 6 min
  3. 43 FIND, SEARCH and SUBSTITUTE in Excel Locate and replace text with formulas 5 min
  4. 44 Text to Columns wizard in Excel Split a column by a comma delimiter 4 min
  5. 45 Data validation in Excel Create drop-down lists for consistent data entry 4 min
  6. 46 Ninja Challenge: problem Clean messy data with text functions and validation 4 min
  7. 47 Ninja Challenge: solution PROPER, Text to Columns and drop-down lists 7 min
06 Data visualisation: charts and graphs 9 lessons · 45 min Charts: which one to choose and how to build it well, from column, line and pie charts to sparklines and the funnel, waterfall and treemap charts.
  1. 48 Choosing the right Excel chart Column, line, pie, combo and modern chart types 4 min
  2. 49 Column charts in Excel Insert, format and label a column chart 5 min
  3. 50 Line charts in Excel Show trends over time with a line chart 4 min
  4. 51 Pie charts in Excel Show proportions and parts of a whole 4 min
  5. 52 Combo charts in Excel Column and line chart with a secondary axis 4 min
  6. 53 Formatting charts in Excel Titles, data labels, colours and chart styles 7 min
  7. 54 Sparklines in Excel Line, column and win-loss mini charts in cells 5 min
  8. 55 Funnel, Pareto and waterfall charts in Excel Modern charts for business data 5 min
  9. 56 Histogram, box and whisker, treemap and sunburst Advanced Excel chart types 6 min
07 PivotTables and PivotCharts: data analysis made easy 10 lessons · 33 min PivotTables: summarise thousands of rows in a few clicks, filter with slicers, add a PivotChart, and refresh when the data changes.
  1. 57 PivotTables 101 in Excel What a PivotTable does and the sales dataset 5 min
  2. 58 Preparing data for PivotTables Clean data with TRIM, PROPER, find and replace 5 min
  3. 59 Create your first PivotTable in Excel Insert a PivotTable from a sales table 1 min
  4. 60 PivotTable fields in Excel Rows, values, columns and Value Field Settings 2 min
  5. 61 PivotTable summaries in Excel Sales by product category and grouping by date 4 min
  6. 62 Slicers in Excel Filter PivotTables with clickable buttons 3 min
  7. 63 PivotCharts in Excel Create interactive charts from a PivotTable 5 min
  8. 64 PivotTable design Tab Report layouts, PivotTable styles and number formats 5 min
  9. 65 Refresh a PivotTable in Excel Update pivots when source data changes 2 min
  10. 66 Excel Ninja Challenge PivotTable sales by region, category and monthly trend 1 min

Questions

Asked before starting.

Is there an Excel course for complete beginners?

Yes. The Complete Excel Course with AI Integration from Coding Liquids assumes nothing: its first lesson opens Excel, its first project is a personal budget tracker, and the beginner's path on this page, 66 lessons and 5 hours 44 minutes of video, goes on through tables, IF and SUMIF and charts to your first PivotTables.

How long does it take to learn the basics of Excel with this course?

The beginner's path of The Complete Excel Course with AI Integration is 5 hours 44 minutes of video in 66 lessons. Building along in the starter workbooks takes longer than watching, and you set the pace: the course comes with lifetime access.

Do I need to be good at maths?

No. The maths in the beginner's path of The Complete Excel Course with AI Integration is adding, subtracting, multiplying, dividing and percentages, and Lesson 8 shows how a formula does that working for you.

Can I try it before paying?

Yes. Free preview lessons play in full on the page of The Complete Excel Course with AI Integration, so you can see how it is taught before you decide, and a 14-day money-back guarantee covers the purchase.

What comes after the beginner lessons?

The rest of The Complete Excel Course with AI Integration goes on project by project: lookups on an HR workbook, a project tracker, AI with Copilot, ChatGPT and Claude, a marketing dashboard, a budget vs actual dashboard, an investment and retirement model, macros and VBA, Power Query with DAX, and Power Automate. In all it runs to 186 lessons and 16 hours.

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.

See the plans Watch free lessons

The same course

For another job, level or topic.

By job

By level and topic