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.