How to learn Excel: a practice plan from your first formula to job-ready

Most people learn Excel the hard way: a deadline, a spreadsheet someone else built, and a lot of searching for "how to sum only some rows". It works, eventually, but it leaves gaps. You end up knowing the three functions your old job used and nothing in between.

This guide gives you a better order. It splits Excel into stages, says what to learn in each, how long it usually takes and how to know you are ready to move on. It is the same order our exercises follow, so every stage links to practice you can do in the browser right now.

Why order matters

Excel is not a list of 500 functions to memorize. It is a small number of ideas that everything else builds on. Learn them in the right order and each new function is a variation on something you already know. Learn them out of order and every function feels like a new trick.

Three ideas carry most of the weight:

1. A formula is a calculation that refers to cells, not to numbers. =B2*C2 keeps working when the quantity in B2 changes. =4*25 does not.
2. References move when you copy a formula, unless you tell them not to with $. This is what lets one formula fill a whole column.
3. Ranges and conditions: most useful functions take a range (B2:B100) and often a condition ("North", ">1000"). Once you understand SUMIF, you understand COUNTIF, AVERAGEIF and SUMIFS.

Every stage below leans on these three. If something later on feels confusing, it is usually one of them that has not clicked yet.

Stage 1: the grid (an hour or two)

Before any formulas, get comfortable with the sheet itself. You should know:

• What a cell, a row, a column and a range are, and how cells are named (B3 is column B, row 3).
• How to select a range with the mouse and with Shift+Arrow keys.
• How to type and edit text and numbers, and the difference between Enter (move down), Tab (move right) and Esc (cancel).
• That text aligns left and numbers align right by default, which is a quick way to spot a number stored as text.

Our Getting started topic covers this with short guided steps. It is free and takes about ten minutes. Start with cells, rows and columns even if you think you know it; the keyboard habits it builds pay off later.

Stage 2: first formulas (an afternoon)

Every formula starts with =. After that you can use cell references, numbers and the arithmetic operators +, -, * and /.

• Add two cells: =B2+B3.
• Multiply quantity by price: =B2*C2.
• Click cells into a formula instead of typing the references, which avoids typos.

Two habits to build now. First, never type a number into a formula if it is already in a cell. Second, when you have written a formula, change one of its input cells and watch the result update. That moment, when you see the sheet recalculate, is when formulas start to make sense.

Stage 3: the basic functions (a few days)

Functions are named formulas that take arguments in parentheses. The first ones to learn all summarize a range:

• SUM adds up a range. Practice with adding up a column, then a block of cells and two separate ranges.
• AVERAGE gives the mean, and quietly ignores empty cells.
• MIN and MAX give the smallest and largest value.
• COUNT counts numbers, COUNTA counts anything that is not empty.

That second point about AVERAGE is worth seeing once:

An empty cell is skipped, but a cell with 0 in it counts as a score of 0. If a missing score should count as zero, type 0. If it should not count at all, leave it empty. The AVERAGE skips blank cells exercise makes the point with real numbers.

Add ROUND to this stage too. =ROUND(B2*1.25,2) rounds a price to two decimals. Formatting a cell to show two decimals only changes what you see; ROUND changes the value. Practice it in rounding a price.

You are ready to move on when you can total, average and count a column without looking anything up, and you type the range rather than clicking every cell.

Stage 4: copying formulas and the dollar sign (a day)

This stage is short, but it is the one most self-taught users skip, and it causes more broken spreadsheets than anything else.

When you fill a formula down, Excel shifts every reference by one row. =B2*C2 in row 2 becomes =B3*C3 in row 3. That is almost always what you want. The exception is a reference to a single fixed cell, such as a tax rate or an exchange rate. Put a $ before the column letter and the row number, $E$1, and the reference stays fixed however far you fill.

Learn the keyboard for it now: Ctrl+D to fill down and F4 to toggle the dollar signs while editing. The fill down and right lesson drills both.

Stage 5: logic with IF (a few days)

IF lets a formula decide. It takes a test, a value if the test is true and a value if it is false: =IF(B2>=50,"Pass","Fail").

Start with pass or fail, then return a calculation rather than text with calculating a bonus. When you need more than two outcomes, put one IF inside another:

Nested IFs are read from the outside in, and the first true test wins. That is why the highest band goes first. The nested IF exercise asks exactly this. Once that makes sense, learn AND and OR for combined tests, and IFS for long chains, which reads more easily than three levels of parentheses.

You are ready to move on when you can write an IF with a comparison, text in quotes and a calculation, and you know which operator "at least", "more than" and "up to" mean.

Stage 6: conditional counts and sums (a week)

This is where Excel starts to save real time. COUNTIF counts the cells that meet a condition; SUMIF adds up the values on the rows that do.

• COUNTIF with a text condition and with a number condition.
• SUMIF with a text criterion, then with the criterion in a cell.
• AVERAGEIF works the same way for averages.
• SUMIFS and COUNTIFS take several conditions at once: region is North and product is Shoes.

Spend a whole week here if you need to. Every report you will ever build at work is some version of "total this, for that group", and these functions are how you do it without a calculator. The summary tables topic then shows how one SUMIF, with the right dollar signs, fills a whole table, which is also what a pivot table does for you. Our pivot table guide covers that link.

Stage 7: lookups (a week)

A lookup finds a value in one list and returns something from the same row: the price of a product, the department of an employee, the name for a customer number. It is the most requested skill in job ads after SUM.

Learn VLOOKUP first, because you will meet it in every older spreadsheet: =VLOOKUP(F2,A2:C5,3,FALSE) looks up F2 in the first column of A2:C5 and returns the third column. Always end it with FALSE for an exact match. Then learn XLOOKUP, which is simpler and more flexible if your Excel has it, and INDEX with MATCH, which works everywhere. Our lookup guide explains when to use which.

Practice with VLOOKUP for a price, then the XLOOKUP and INDEX and MATCH topics, and finally IFERROR to show "Unknown" instead of #N/A when a value is not found.

Stage 8: text and dates (a week)

Real data is messy. Names have stray spaces, codes are in the wrong case, and dates arrive as text. Two families of functions clean it up.

Text functions fix and split text:

• TRIM removes extra spaces, which is the first thing to try when a lookup fails on a value you can see.
• PROPER, UPPER and LOWER fix capitals.
• LEFT, RIGHT and MID take characters from the start, end or middle; FIND and SEARCH tell you where a character is.
• & and TEXTJOIN join text together.

Date functions rely on one fact: Excel stores a date as a number of days. That is why you can subtract one date from another to get the days between them. From there, learn DATE, MONTH and YEAR, EDATE and EOMONTH for months, and NETWORKDAYS for working days.

Stage 9: speed (ongoing)

By now you know enough Excel for most jobs. What separates a confident user from an average one is speed, and most of that comes from the keyboard.

• Ctrl+Arrow jumps to the end of your data, and Ctrl+Shift+Arrow selects to it.
• F2 edits a cell, Ctrl+D and Ctrl+R fill, F4 toggles $.
• Ctrl+Z undoes, Alt+= adds an AutoSum.

Five minutes of shortcut drills a day for two weeks makes them automatic. The speed-run tells you whether it is working.

Speed also comes from layout. A sheet with one header row, one record per row, no blank rows in the middle and no merged cells is faster to work with, because Ctrl+Arrow, filters, sorting and every function in this guide behave the way you expect. When a sheet you inherit is slow to work in, it is often the layout rather than you. Tidying it into a plain table first is time well spent.

How to practice so it sticks

The order matters, but the way you practice matters more. These are the habits that work, from what we see in thousands of graded answers.

Type it yourself. Watching a video of someone writing a VLOOKUP feels like learning. It is not, until you have written ten of them yourself and got three wrong. Every exercise on PracticeExcel makes you type the formula into a real grid for that reason.

Get feedback straight away. The worst way to learn a formula is to get it wrong, not notice, and repeat the mistake for a month. Practice somewhere that tells you immediately whether the answer is right and, when it is not, why.

Keep sessions short and frequent. Twenty minutes a day for three weeks beats a whole Saturday. Your memory needs the gaps between sessions to make things stick.

Mix old and new. Every session, redo one exercise from an earlier stage before starting a new one. If it is slow, you have found what to review.

Use your own data. Once you know a function, use it on something you care about: your budget, a club's membership list, your running times. Real data has the quirks that exercises leave out.

Test yourself under time pressure. A timed test shows the difference between "I can do it" and "I can do it now". The Excel test for job interviews is a good check at the end of stage 7.

When you get stuck

Everyone gets stuck, usually at the same few places. Knowing them in advance makes them shorter.

The formula shows as text. If a cell shows =SUM(B2:B5) instead of a number, the cell was formatted as text before you typed, or there is a space before the =. Change the format to General, then press F2 and Enter to make Excel read it again.

The answer is wrong, but there is no error. This is the most dangerous kind of mistake, and the most common. Check the range first: does it cover every row? Then check the references after filling down: press F2 on a cell further down the column and look at what it points to. Excel colors each reference and draws a box around the cells it refers to, which makes a range that has slid out of place easy to spot.

An error code you don't recognize. Each one tells you something specific:

• #DIV/0! means a division by zero or by an empty cell.
• #N/A means a lookup did not find its value.
• #NAME? means Excel does not recognize a function name, usually a typo, or text without quotes.
• #VALUE! means the wrong kind of value, such as text in a calculation.
• #REF! means a reference to cells that no longer exist, usually after deleting rows or columns.

You can't remember the arguments. Type the function name and the opening parenthesis, and Excel shows the arguments in a tooltip under the cell. The bold one is the argument you are typing now. That tooltip is worth reading every time until the order is automatic.

It worked yesterday and not today. Usually someone has sorted one column without the others, typed a number over a formula, or deleted a row the formula used. Undo is your friend, and so is keeping a copy of the file before big changes.

Learning Excel or Google Sheets

You do not have to choose. The grid, references, the $ sign and the common functions work the same way in both, so almost everything in this guide applies to Google Sheets too. SUM, IF, SUMIF, VLOOKUP, XLOOKUP and INDEX MATCH have the same names and arguments.

The main differences are around the edges: menus are in different places, some shortcuts differ, Google Sheets has a few functions Excel does not (QUERY, IMPORTRANGE, GOOGLEFINANCE), and Excel has features Sheets lacks (Power Query, Power Pivot, most of VBA). Learn the one you will use day to day, and pick up the other when you need it. A week of using the other one is usually enough to feel at home.

How long it really takes

People ask this more than anything else. Honest answers, assuming twenty to thirty minutes of practice most days:

That puts most people at a solid intermediate level in about six weeks, which is what most office jobs and most Excel tests expect. If you already use Excel at work, you will move through the early stages much faster; do them anyway, quickly, to find the gaps.

What to skip, for now

Excel has features you can safely ignore until you need them. Skipping them early keeps you focused on what pays off.

• VBA and macros. Useful for automating repeated work, but not needed for most roles.
• Power Query and Power Pivot. Excellent for large or messy data, but learn formulas first so you understand what they do for you.
• Array formulas the old way (Ctrl+Shift+Enter). Modern Excel handles arrays on its own.
• Every function in the list. Of more than 450 functions, most people use about 30. Our function pages cover the ones that matter.

Summary

Learn Excel in layers: the grid, simple formulas, the basic functions, references and $, IF, conditional sums and counts, lookups, then text, dates and speed. Each layer builds on the one before, and each takes days or weeks, not months. Practice by typing formulas yourself, with instant feedback, in short daily sessions, and test yourself against a clock once you reach lookups.

The practice block below follows the same order. Start at the top, and stop when the exercises feel easy, not when you have read about them.