Excel Lessons
Practical, step-by-step Excel lessons — from the basics through advanced data analysis.
Dynamic Arrays: FILTER, SORT, and UNIQUE
Three newer functions that can return many results from a single formula, spilling automatically into nearby cells.
Read lesson →PivotTables for Advanced Analysis
Calculated fields, grouping, and slicers — going beyond a basic PivotTable summary.
Read lesson →Introduction to Macros
Record a repetitive task once, then replay it with a single click forever after.
Read lesson →Getting Started with Excel
A tour of the Excel interface — the ribbon, cells, rows, columns, and sheets.
Read lesson →Entering and Editing Data
How to type, edit, and correct data in a worksheet without making a mess of it.
Read lesson →Your First Formulas
Every Excel formula starts with an equals sign — here's how basic math works in a spreadsheet.
Read lesson →The SUM Function
The most-used function in Excel — add up a range of numbers in one step.
Read lesson →The IF Function
Make your spreadsheet respond differently depending on a condition.
Read lesson →Basic Cell Formatting
Make a spreadsheet readable — fonts, colors, borders, and number formats.
Read lesson →