Free Excel articles & tutorials
Practical, plain-English guides for every level — no sign-up required.
How to create a chart in Excel (and pick the right one)
A beginner's guide to inserting a chart in Excel and choosing the right chart type for your data — bar, line, pie, and when to avoid each.
20 Excel keyboard shortcuts that actually save time
The keyboard shortcuts worth memorizing for navigation, selection, editing, and formulas — grouped by what they're for, not just an alphabetical dump.
How to create a pivot table in Excel (step-by-step)
A beginner's guide to building your first pivot table: preparing your data, choosing rows and values, and the mistakes that trip up almost everyone.
Getting started with Power Query: import and clean data automatically
How to pull data into Excel with Power Query, apply repeatable cleaning steps, and load the result — without touching a single formula.
Excel's Quick Analysis tool: instant totals, charts, and formatting
A one-click way to total, chart, and format a selection without building anything manually — how to use Excel's most overlooked analysis shortcut.
Record your first macro in Excel (no coding required)
How to turn on the Developer tab, record a macro of repetitive steps, and run it again with one click — no VBA knowledge needed.
3 ways to remove duplicates in Excel
Remove duplicate rows using the built-in button, UNIQUE, or Power Query — and how to pick the right one.
How to use VLOOKUP in Excel (with examples)
A plain-English guide to VLOOKUP: the syntax, a worked example, the most common errors, and when to use XLOOKUP instead.