Excel Formulas & Functions: A Practical Beginner’s Course
Build real confidence with Excel formulas and functions. From your first formula to dynamic arrays, lookups, data cleanup, and auditing errors — learn the practical skills that make spreadsheets work for you.
Course Curriculum
Start at the very beginning: what formulas and functions actually are, and why every formula starts with an equal sign. You will build your first formula, work through Excel's order of operations with arithmetic operators, and use cell references so your calculations update automatically. Then master the single most important beginner concept — absolute vs. relative references ($ signs) — and learn to copy, paste, and edit formulas efficiently without breaking them.
The everyday functions that do most of the heavy lifting in real spreadsheets. Summarize data with SUM and AVERAGE, get instant totals with AutoSum (Alt+=), and count values with COUNT, COUNTA, and COUNTBLANK. Make your spreadsheets react to data using IF and IFS, add conditional summaries with SUMIFS, read quick calculations straight off the status bar, and control precision with the ROUND family of functions.
Make your formulas readable and self-maintaining. Create named ranges so formulas read like plain English, then modify and remove them with the Name Manager. Convert raw data into structured Excel tables that auto-expand as rows are added, reference table columns with structured references (the @ symbol for the current row), and sort and filter table data in a few clicks.
Modern Excel can write a single formula that spills results across many cells at once. Understand dynamic arrays and spill ranges (and the # reference for a whole spill), extract distinct values with UNIQUE, reorder data on the fly with SORT, and pull out matching rows with FILTER. These functions replace a lot of manual work and recalculate automatically as your data changes.
Clean, control, and connect your data. Tidy messy text with functions like LEFT, RIGHT, MID, and TRIM, and split data instantly with Flash Fill. Keep data entry accurate using validation rules and dropdown lists. Then learn the two lookup functions every analyst needs — VLOOKUP (and the exact-match FALSE argument) and the more flexible XLOOKUP that can search in any direction.
Keep your worksheets trustworthy. Trace precedents and dependents to see exactly which cells feed a formula and which rely on it, step through calculations with Evaluate Formula, and decode the error indicators Excel shows you. Finally, learn a systematic approach to find and fix errors like #NAME?, #DIV/0!, #N/A, and #VALUE! before they reach your reports.
Where to go next on your Excel journey.