Microsoft Excel
Free Excel Training & Interactive Practice
From your first cell to advanced pivot tables — a step-by-step Excel curriculum designed for the modern office.
Excel Basics: The Ribbon, Cells, and Saving
Excel is the world's most widely used spreadsheet program — the daily home of accountants, analysts, admins, and virtually every o…
12 min • Start lesson →
Your First Formulas: SUM, AVERAGE, and Basic Math
Formulas are what turn a spreadsheet from a fancy grid into a calculator. Every formula starts with an equals sign =.…
15 min • Start lesson →
Lookups: VLOOKUP and XLOOKUP Explained
Lookups let one table pull matching data from another — the workhorse behind price lists, employee lookups, and merged reports.…
20 min • Start lesson →
Pivot Tables in Under 20 Minutes
A Pivot Table summarizes thousands of rows into a small, meaningful report — sums by month, counts by region, averages by product …
20 min • Start lesson →
Beginner Excel: Interface, Rows, Columns & Navigation
This is your first real tour of Excel. You'll learn the Ribbon, the Name Box, the Formula Bar, how to move around a workbook with …
15 min • Start lesson →
Intermediate Excel: Formulas, Cell References & Tables
Intermediate Excel is where the real productivity lives: writing formulas that update themselves, using absolute references so cop…
20 min • Start lesson →
Advanced Excel: Nested IFs, Dynamic Arrays & Auditing
Advanced Excel is where analysts, controllers, and power users spend their days. This lesson covers nested IFs (and when to drop t…
25 min • Start lesson →
SUM, AVERAGE, COUNT, COUNTA, MIN, MAX
The six workhorse aggregate functions of Excel. Learn them well and 40% of daily spreadsheet work becomes instant.…
12 min • Start lesson →
IF and IFS: Decision-Making in Formulas
IF is Excel's most-asked interview question. Get comfortable with it and you can automate decisions all day.…
12 min • Start lesson →
SUMIF, COUNTIF, AVERAGEIF
Conditional aggregates — the fastest way to slice numbers without a Pivot Table.…
12 min • Start lesson →
VLOOKUP, HLOOKUP, XLOOKUP
Lookups pull data from one table into another. XLOOKUP is the modern replacement; VLOOKUP is still everywhere so you must know bot…
15 min • Start lesson →
INDEX and MATCH
Before XLOOKUP, INDEX/MATCH was the flexible lookup combo. Still essential — it appears in nearly every legacy workbook.…
12 min • Start lesson →
Text Functions: LEFT, RIGHT, MID, CONCAT, TEXT
Real data is messy. Text functions let you slice, combine, and format strings without leaving Excel.…
12 min • Start lesson →
TODAY, NOW, ROUND, ROUNDUP, ROUNDDOWN, IFERROR
A tidy roundup of utility functions you'll use in almost every workbook.…
10 min • Start lesson →
Pivot Tables Deep Dive: Grouping, Slicers, Pivot Charts
A dedicated tour of Pivot Tables beyond the basics — grouping dates, adding calculated fields, using Slicers, and pairing with Piv…
20 min • Start lesson →
Charts, Tables & Dashboards
Pick the right chart, style it professionally, and combine several into a single-screen dashboard.…
15 min • Start lesson →
Conditional Formatting
Conditional formatting turns raw numbers into a visual story — heat maps, data bars, duplicate detection, and custom rules based o…
12 min • Start lesson →
Excel Keyboard Shortcuts That Actually Matter
You don't need 200 shortcuts. You need the 20 that show up hourly. Learn these and your daily Excel time drops by a third.…
10 min • Start lesson →