Excel Lessons
Practical, step-by-step Excel lessons — from the basics through advanced data analysis.
Sorting and Filtering Data
Put your data in order, and hide the rows you don't need to see right now.
Read lesson →Understanding Cell References: Relative vs. Absolute
Why copying a formula sometimes breaks it — and how a dollar sign fixes that.
Read lesson →Creating Your First Chart
Turn a table of numbers into a chart that's actually easy to read at a glance.
Read lesson →The COUNT and COUNTA Functions
Count how many cells actually have something in them — numbers, or anything at all.
Read lesson →Freezing Panes and Printing Your Worksheet
Keep your headers visible while you scroll, and get a printed page that actually looks right.
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 →