How to use Excel: a complete beginner’s guide
New to Excel? Learn how to use Excel step by step: the screen, entering data, your first formulas, SUM, IF and VLOOKUP, plus the shortcuts and habits that make beginners fast.
Excel from zero
On this page
- What Excel is (and what it is good at)
- Step 1: Find your way around the screen
- Step 2: Enter and edit data
- Step 3: Write your first formula
- Step 4: Learn the functions you will use every day
- Step 5: Pick up a few shortcuts early
- Common beginner mistakes (and how to avoid them)
- The fastest way to learn Excel: practise
What Excel is (and what it is good at)
Microsoft Excel is a spreadsheet: a grid of cells where you store data and write formulas that calculate with it. Change a number and every formula that uses it updates instantly. That is why Excel runs budgets, sales reports, schedules, stock lists and most of the numbers in an office.
You do not need to be good at maths to use Excel well. You need to know where things go, a handful of functions, and a few habits. This guide covers all three, in the order beginners should learn them.
Step 1: Find your way around the screen
- Cells are the boxes. Each has an address made of its column letter and row number, such as
B3. - Columns run down and are labelled A, B, C… Rows run across and are numbered 1, 2, 3…
- The Name Box (top left) shows the address of the selected cell. The formula bar next to it shows what is really in the cell.
- A workbook is the file. Each workbook has one or more worksheets, shown as tabs at the bottom.
Step 2: Enter and edit data
Click a cell, type, and press Enter to move down or Tab to move right. To change a cell, select it and press F2 (or double-click it) to edit what is already there, rather than typing over it.
- Put one kind of thing per column (dates in one, amounts in another) and give every column a header in row 1.
- Type numbers as plain numbers. Use formatting for currency or percentages instead of typing “£” or “%” as text.
- Leave no blank rows inside a table. Excel uses blank rows to decide where a table ends.
Step 3: Write your first formula
Every formula starts with an equals sign. After it you can do arithmetic with cell addresses, and Excel works out the answer.
=B2*C2To copy a formula down, select the cell and drag the small square in its corner (the fill handle), or select the range and press Ctrl+D. Excel shifts the cell addresses for each row automatically. These are called relative references.
Step 4: Learn the functions you will use every day
Functions are ready-made formulas. You give them a range and they do the work. These cover most everyday spreadsheets:
| Function | What it does | Example |
|---|---|---|
| SUM | Adds up a range | =SUM(D2:D20) |
| AVERAGE | The average of a range | =AVERAGE(C2:C20) |
| COUNT / COUNTA | Counts numbers / non-empty cells | =COUNTA(A2:A20) |
| MIN / MAX | Smallest / largest value | =MAX(D2:D20) |
| SUMIF | Adds only rows that match a condition | =SUMIF(B2:B20,"North",D2:D20) |
| IF | Returns one thing or another | =IF(D2>100,"High","Low") |
| XLOOKUP | Finds a value in another table | =XLOOKUP(F2,A2:A20,C2:C20) |
Start with SUM using AutoSum (Alt+=), then AVERAGE, COUNT, MIN and MAX. Once those feel natural, learn SUMIF and IF, and then a lookup. Every function has its own page in the Excel functions list. If your Excel is older than 2021, learn VLOOKUP instead of XLOOKUP.
Step 5: Pick up a few shortcuts early
You do not need hundreds of shortcuts. These save beginners the most time:
| Shortcut | What it does |
|---|---|
| Ctrl+Arrow | Jump to the edge of the data |
| Ctrl+Shift+Arrow | Select to the edge of the data |
| Ctrl+Home / Ctrl+End | Go to A1 / the last used cell |
| Ctrl+C / Ctrl+V | Copy / paste |
| Ctrl+Z | Undo |
| F2 | Edit the active cell |
| F4 | Toggle $ in a reference while editing |
On a Mac, use Cmd where Windows uses Ctrl for most of these.
Common beginner mistakes (and how to avoid them)
- Typing numbers as text. A number aligned to the left, or with a green triangle, is probably text and will not add up.
- Forgetting the equals sign. Without
=at the start, Excel shows your formula as plain text. - Hard-coding values. Write
=B2*$F$1, not=B2*0.2, so a changed rate updates everywhere. - Merging cells in data. Merged cells break sorting, filtering and copying. Use “Center Across Selection” for headings instead.
- Not checking the answer. Spot-check one result by hand before you trust a whole column.
The fastest way to learn Excel: practise
Reading a guide (or watching a video) gives you the idea. The skill only sticks once you have done it yourself a few times and seen what goes wrong. Short daily practice beats long sessions: 15 to 30 minutes a day for two or three weeks is enough to be comfortable with everything above.
Our free Excel for beginners path takes you through each step in this guide with hands-on tasks in a live spreadsheet, graded instantly. Start with lesson 1 and work through it in order, or browse the whole free Excel course.
Try it in a live spreadsheet
Practise these formulas in interactive lessons with instant grading.
Sara Lind
Course editor at FluentExcel