100% free Certificate included Downloadable templates

Free Excel Course: From Beginner to Advanced

Learn Excel from scratch all the way to PivotTables, XLOOKUP, Power Query, macros, Power Pivot and financial functions, with worked exercises, interactive quizzes and a free certificate.

  • 16lessons
  • 3h 9minof reading
  • 64review questions
  • 25worked exercises

No sign-up needed: just start reading. Create a free account to save your progress and get your certificate.

What you’ll learn

  • Navigate Excel with keyboard shortcuts (Windows and Mac) and organize data so it never breaks
  • Write formulas with SUM, AVERAGE, MAX, MIN, COUNT and percentages
  • Master relative, absolute and mixed references with the $ sign and F4
  • Format numbers professionally, use conditional formatting and build Excel tables
  • Make decisions with IF, IFS, AND, OR and IFERROR
  • Look up data with VLOOKUP, XLOOKUP and INDEX/MATCH
  • Summarize data with SUMIFS, COUNTIFS and AVERAGEIFS, and clean text and dates
  • Create drop-down lists, validation rules and protected sheets
  • Build PivotTables, charts and a one-page dashboard
  • Use FILTER, SORT, UNIQUE, TAKE and LET (dynamic arrays)
  • Automate data cleanup with Power Query
  • Record macros and write simple VBA code
  • Calculate loan payments, amortization schedules, NPV and IRR
  • Answer what-if questions with Goal Seek, data tables, scenarios and Solver
  • Relate tables and write DAX measures with Power Pivot
  • Pass the Excel skills test in a job interview
A clear goal

Every lesson starts by telling you what you’ll be able to do.

Real examples

Real-life cases from U.S. households and small businesses.

Instant quizzes

Check what you learned with immediate feedback.

Worked exercise

Practice first, then compare with the solution.

Course syllabus

4 levels · 16 lessons · 3h 9min of content

1 Level 1Beginner 4 lessons · 47 min
  1. 1
    Introduction to Excel: The Interface, Cells and How to Organize Data

    The parts of the Excel window, data types, essential Windows and Mac shortcuts, and five rules for organizing data without errors.

    14 min
  2. 2
    Basic Excel Formulas: SUM, AVERAGE, MAX, MIN and Percentages

    How to write formulas, the most-used functions, percentages and sales tax, and how to fix the most common errors.

    10 min
  3. 3
    Relative, Absolute and Mixed Cell References in Excel (the $ Sign)

    Why formulas shift when you copy them and how to lock them with $, F4 and named cells.

    11 min
  4. 4
    Cell Formatting, Conditional Formatting and Excel Tables

    Number formats, automatic highlighting with conditional formatting and tables that grow on their own.

    12 min
2 Level 2Intermediate 4 lessons · 43 min
  1. 5
    Excel IF Function: Nested IF, IFS, AND, OR and IFERROR

    How to make Excel decide with one or several conditions, using real examples like grades, discounts and bonuses.

    11 min
  2. 6
    VLOOKUP and XLOOKUP: How to Look Up Data Between Tables

    VLOOKUP step by step, XLOOKUP, INDEX and MATCH, tiered commission lookups and how to fix #N/A errors.

    10 min
  3. 7
    SUMIFS, COUNTIFS and Excel Text and Date Functions

    Sum and count with multiple criteria, date ranges, summary reports, text cleanup and date calculations.

    11 min
  4. 8
    Data Validation, Drop-Down Lists and Sheet Protection in Excel

    Drop-down lists (including dependent lists), formula-based rules, error alerts and how to protect sheets and workbooks.

    11 min
3 Level 3Advanced 4 lessons · 48 min
  1. 9
    PivotTables, Charts and Dashboards in Excel

    Create PivotTables, group dates, add slicers and timelines, choose the right chart and build a dashboard in 15 minutes.

    11 min
  2. 10
    FILTER, SORT, UNIQUE and LET: Excel Dynamic Array Functions

    Spilled formulas, filters with several conditions, an automatic top 5, a search box and readable formulas with LET.

    11 min
  3. 11
    Power Query in Excel: Import and Clean Data Automatically

    Get data from CSV files, workbooks and folders, clean it, unpivot it, merge queries and refresh with one click.

    13 min
  4. 12
    Excel Macros: What They Are, Examples and How to Create Them with VBA

    Record macros, read VBA code, write loops and conditions, add buttons and decide between macros and Power Query.

    13 min
4 Level 4Expert 4 lessons · 52 min
  1. 13
    Excel Financial Functions: PMT, Amortization Schedules, NPV and IRR

    Loan payments with PMT, APR vs. APY, amortization schedules, FV, PV, RATE, NPV and IRR to evaluate projects.

    14 min
  2. 14
    What-If Analysis in Excel: Goal Seek, Scenarios, Data Tables and Solver

    Answer "what if" questions: hit targets with Goal Seek, compare scenarios, build two-variable data tables and optimize with Solver.

    13 min
  3. 15
    Power Pivot and the Excel Data Model: Relationships and DAX Measures

    Relate tables without VLOOKUP, write measures with SUMX, RELATED and CALCULATE, and build reports with CUBE functions.

    12 min
  4. 16
    Excel Test for Job Interviews: 10 Practice Exercises with Answers

    A timed practice test with the exercises employers ask most, time-saving shortcuts and how to show your Excel skills on a resume.

    13 min

About this course

This free Excel course takes you from beginner to advanced in 16 lessons built around what people actually use at work: formulas, absolute references, the IF function, VLOOKUP and XLOOKUP, SUMIFS and COUNTIFS, data validation, PivotTables, dynamic array functions like FILTER and UNIQUE, Power Query, macros and VBA, financial functions, Goal Seek and Solver, and Power Pivot. It ends with a timed practice test modeled on the Excel assessments many U.S. employers give job candidates.

The course is organized in four levels (Beginner, Intermediate, Advanced and Expert). Every lesson uses realistic American examples (invoices with sales tax, sales commissions, overdue invoices, loan amortization with APR, a coffee roaster's sales data), includes interactive quizzes that grade you instantly and ends with a practice exercise and its solution. You can read every lesson without signing up; create a free account to save your progress and download your certificate when you finish.

It works with Excel for Microsoft 365, Excel 2024, 2021, 2019 and 2016, on Windows and Mac. Functions that only exist in recent versions are clearly flagged, with an alternative for older versions, and differences on a Mac or in Google Sheets are pointed out where they matter.

Includes a free practice file: an Excel workbook with 300 sample sales orders, a product catalog, student grades and messy customer data to clean, with yellow input cells for the exercises in each lesson.

Downloadable resources

Templates and practice data you’ll use throughout the course. Free, no sign-up.

Frequently asked questions

Is this Excel course really free?
Yes. All 16 lessons are free and you can read them without registering. If you create a free account, you can track your progress, mark lessons as completed and download a certificate of completion when you finish.
Do I need to know anything about Excel before I start?
No. The first lesson starts from zero: what a cell is, how to move around a sheet and how to organize your data. The course then moves level by level up to PivotTables, Power Query, macros and Power Pivot.
Does it work on a Mac or in Google Sheets?
Yes for most of it. Formulas, conditional formatting, tables and PivotTables work almost the same in Excel for Mac, and most formulas also work in Google Sheets. Lessons point out Mac shortcuts and the main differences. Power Pivot is only available in Excel for Windows, and the Power Query and macro lessons work best on Windows.
Which version of Excel do I need for the advanced lessons?
PivotTables, Power Query and macros work in Excel 2016 and later. XLOOKUP, FILTER, SORT, UNIQUE and LET need Microsoft 365 or Excel 2021 and later, and a few newer functions like TAKE and HSTACK need Microsoft 365 or Excel 2024. Each lesson tells you what to use if your version doesn't have a function.
My Excel uses semicolons or different function names. Will the formulas work?
The course uses U.S. English Excel, with English function names and commas between arguments, like =SUMIFS(D:D,B:B,"West"). If your computer uses another language or regional setting, Excel may expect semicolons or translated function names when you type, but files you open are translated automatically.
How long does it take to finish the course?
Reading all 16 lessons takes about two and a half hours. With the practice exercises and the downloadable workbook, plan on 15 to 20 hours spread over four or five weeks.
Will it help me pass an Excel test in a job interview?
Yes. The last lesson is a practice test with the 10 exercises that show up most often in pre-employment Excel assessments (SUMIF, XLOOKUP, PivotTables, percentages, conditional formatting and more), with solutions, check totals and time-management tips.