Learn Excel Formulas for Beginners: A Step-by-Step Path

Most people who "can't do Excel" are missing a handful of ideas, not hundreds of functions. If you learn them in the right order, every new formula builds on the last one and nothing feels like magic.

This guide gives you that order. Each step has one idea, one example you can type into any sheet, and a link to a deeper guide when you're ready.

Step 1: Every formula starts with =

Type = into a cell and Excel stops treating what follows as text. It starts calculating.

=4200+3900

That works, but it's a trap. If one of those numbers changes, your answer is wrong and nobody notices.

Step 2: Point at cells instead of typing numbers

Cells have addresses: column letter plus row number. B2 is column B, row 2. So instead of typing the numbers, you point at them:

=B2+B3

Now when B2 changes, the answer updates by itself. This one habit is the difference between a spreadsheet and a calculator. If the vocabulary is new, read Excel terms explained first.

Step 3: Ranges and SUM

A range is a block of cells written as first cell, colon, last cell: B2:B13 means B2 down to B13. Functions take ranges:

=SUM(B2:B13)

That adds twelve months of sales in one go. See the full SUM guide for shortcuts like AutoSum.

Step 4: The everyday summary functions

Once SUM makes sense, these work the same way:

Learn more in AVERAGE and MIN and MAX.

Step 5: Mix cells and operators

Real questions mix things. Profit is sales minus costs:

=B2-C2

Revenue is price times quantity: =B2*C2. Excel follows normal maths order (multiply and divide before add and subtract), so use brackets when you mean something else. More in order of operations.

Step 6: Fill down, and lock cells with $

Write a formula once, then drag the small square in the corner of the cell (the fill handle) down the column. Excel copies the formula and shifts every reference by one row each time. That's usually what you want.

Sometimes it isn't. If every row divides by a total in B14, the copies will drift to B15, B16 and break. Lock it with dollar signs:

=B2/$B$14

This is the single most common mistake in job tests. The full explanation is in absolute references.

Step 7: Decisions with IF

IF picks between two answers depending on a test:

=IF(B2>=5000,"Target hit","Below target")

Read the IF function guide next, then COUNTIF and SUMIF, which count or add only the rows that match a condition.

Step 8: Look things up

Lookups pull a value from a table: the price of a product, the name for an employee ID. Start with VLOOKUP, then learn XLOOKUP, its modern replacement.

How to actually make it stick

Reading about formulas feels productive, but you remember them by writing them. A few minutes of practice every day beats a three-hour video once. Write each formula yourself, get it wrong, find out why, and fix it.

That's exactly how Cellio works: 2-minute lessons where you tap cells to build the formula on a real sheet, and every answer is calculated, so you see whether it really works. Steps 1 to 6 above are live in the app today, and IF and lookups are coming next. If you want a schedule, try the 10-minutes-a-day plan.

Frequently asked questions

What is the first formula I should learn in Excel?

SUM. It teaches you the = sign, cell references and ranges, which every other formula uses.

How many formulas do I need to know?

For most office jobs, around 15 to 20: SUM, AVERAGE, MIN, MAX, COUNT, IF, COUNTIF, SUMIF(S), VLOOKUP or XLOOKUP, IFERROR, a few text and date functions, plus $ references.

Are Excel formulas the same in Google Sheets?

Almost all beginner formulas are written identically. See Excel vs Google Sheets formulas for the few differences.

Can I learn Excel formulas on my phone?

Yes. The Excel mobile app works for practice, and apps like Cellio are built for learning on a phone with tap-to-build formulas.