Start with the interface and the basics
Before formulas, get comfortable with how a spreadsheet is laid out: cells, rows, columns, and how a cell reference like B2 works. Learn to enter and edit data, copy and paste (including paste-special for values), and use the fill handle to drag a pattern or formula across cells. Understand the difference between a relative reference (B2) and an absolute one ($B$2), because it's the source of most beginner formula errors.
These fundamentals feel small but they're the grammar of Excel - everything else builds on them, and getting them solid makes the rest far less confusing.
Learn the essential formulas
A handful of functions do most of the heavy lifting. Start here and you'll handle the majority of everyday tasks:
- ✓SUM, AVERAGE, MIN, MAX, COUNT - basic maths across a range of cells.
- ✓IF - make a cell respond to a condition ('Pass' or 'Fail' based on a mark).
- ✓A lookup function - VLOOKUP or the newer XLOOKUP - to pull a value from another table by matching a key.
- ✓COUNTIF and SUMIF - count or add only the cells that meet a condition.
- ✓Basic text functions like CONCAT / & to join text, and TRIM to clean it up.
Practice this now
Related reading
Organise data: formatting, sorting and filtering
Data is only useful if you can read and navigate it. Learn to format cells clearly - number and currency formats, dates, borders and simple colour - so a sheet is legible at a glance. Conditional formatting (automatically highlighting cells that meet a rule) is a quick win that makes patterns jump out.
Then master sorting and filtering. Sorting arranges rows by a column (highest marks first, alphabetical by name); filtering hides everything except the rows you care about (only students who failed, only sales from one region). Together these turn a wall of numbers into something you can actually work with.
Visualise and analyse: charts and pivot tables
Once you can handle data, learn to communicate and analyse it. Charts - a bar chart for comparisons, a line chart for trends over time, a pie chart for proportions - turn numbers into a picture people instantly understand. Knowing which chart fits which data is a small skill that makes your work look professional.
Pivot tables are the feature that genuinely impresses. They let you summarise a large table in seconds - total sales by region, average marks by class - without writing a single formula, just by dragging fields. They look intimidating but are quick to learn, and they're the skill that separates a basic user from a useful one.
Practice this now
Related reading
How to actually learn Excel
- ✓Learn by doing - build a real sheet (a budget, marks tracker, or event planner) rather than just watching tutorials.
- ✓Master one skill at a time in the order above; don't jump to pivot tables before formulas.
- ✓Use keyboard shortcuts as you go - they compound into real speed over time.
- ✓When stuck, search the exact task ('how to VLOOKUP in Excel') - the answer always exists.
- ✓Practise with the free spreadsheet you already have (Google Sheets works for almost all of this).