15 Excel Formulas Every Beginner Should Know (With Examples)

Excel has over 500 functions, which is exactly why most people never get past typing numbers into cells. The truth is that the overwhelming majority of everyday spreadsheet work runs on about fifteen formulas, and once those click, Excel stops feeling like a wall and starts feeling like a tool.

This guide covers those fifteen, with a plain-English explanation of what each one does, the exact syntax, and a real example you can try right now. No jargon, no advanced array wizardry, just the formulas that carry the load.

Before the Formulas: Three Things to Know

These three concepts trip up more beginners than any function does, so get them straight first.

• Every formula starts with an equals sign. Type =SUM(A1:A10), not SUM(A1:A10). Without the equals sign, Excel treats it as text.
• A colon means “through.” A1:A10 means every cell from A1 through A10. A comma means “and these specific ones”: A1,A5,A9.
• The dollar sign locks a reference. This is the big one, covered in detail below.

The Concept That Fixes Most Broken Formulas: Absolute References

When you write =A1*B1 and drag it down, Excel helpfully shifts it to =A2*B2, then =A3*B3. That is usually what you want. But sometimes you need one part to stay put, like a tax rate sitting in a single cell.

Adding a dollar sign locks it:

The Core Five: Math Basics

1. SUM

Adds up a range. The most used function in Excel by a wide margin.

Adds every number from B2 through B20. Shortcut: select the cell below your numbers and press Alt + = to auto-insert a SUM.

2. AVERAGE

Gives you the mean of a range, ignoring empty cells and text.

3. COUNT and COUNTA

COUNT counts cells containing numbers. COUNTA counts cells that are not empty, including text.

Use COUNTA when you want “how many rows have data,” since names and text do not register with plain COUNT.

4. MIN and MAX

The smallest and largest values in a range.

5. ROUND

Rounds a number to a set number of decimal places. Essential for money.

Rounds B2 to 2 decimals. Use 0 for whole numbers. Note that formatting a cell to show 2 decimals only changes the display, while ROUND changes the actual value, which matters when you sum a column.

The Decision Makers: Logic and Conditions

6. IF

The gateway to real spreadsheet logic. Tests a condition and returns one thing if true, another if false.

Reads as: if B2 is 1000 or more, write “Target met,” otherwise write “Below target.” The structure is always =IF(test, value if true, value if false).

7. SUMIF

Adds only the values that meet a condition. Enormously useful.

Adds up every value in column B where the matching row in column A says “North.” Perfect for totals by region, category, or person.

8. COUNTIF

Counts how many cells meet a condition.

9. IFERROR

Catches errors and replaces them with something readable. This is what separates a messy sheet from a clean one.

If dividing produces an error (like dividing by zero), it shows “n/a” instead of an ugly #DIV/0!. Wrap any formula that might fail.

The Lookup: Finding Data Across Tables

10. XLOOKUP

The modern way to find a value in one column and return the matching value from another. Available in Office 2021, Office 2024, and Microsoft 365.

Reads as: take the value in E2, find it in column A, and return whatever sits beside it in column B. Look up a product code, get the price. Look up a name, get the email.

You can add a fallback for when nothing matches:

11. VLOOKUP (for older versions)

If you are on an older Excel without XLOOKUP, VLOOKUP does a similar job with clumsier syntax.

Reads as: find E2 in the first column of A2:C50, return the value from the 3rd column, and only accept an exact match (that is what FALSE does, and you almost always want it).

The Text Cleaners

12. CONCAT

Joins text from multiple cells into one.

Turns “Jane” and “Smith” into “Jane Smith.” The " " in the middle adds the space. You can also use the ampersand: =A2&" "&B2 does exactly the same thing with less typing.

13. TRIM

Strips extra spaces. This fixes an astonishing number of “why is my lookup failing” mysteries.

Data pasted from websites and other systems is full of invisible trailing spaces, and “North ” does not match “North.” TRIM removes them.

14. LEN

Counts characters in a cell.

Useful for validating things like postal codes or phone numbers, and for spotting those hidden spaces when a value looks right but behaves wrong.

15. TODAY

Inserts the current date, updating automatically every day.

Note the empty brackets. Great for age calculations, days-outstanding columns, and headers that date themselves.

Quick Reference Table

Common Beginner Mistakes

• Forgetting the equals sign. The formula shows as text instead of calculating.
• Missing dollar signs. Formulas produce garbage when copied down. Press F4 to lock references.
• Numbers stored as text. If SUM returns zero, your “numbers” may be text. Look for a green triangle in the corner of the cell.
• Trailing spaces. Lookups fail silently because “North ” and “North” are different. Wrap in TRIM.
• Rounding by formatting instead of ROUND. The display shows 2 decimals but the underlying value has more, so totals look off by a cent.
• Forgetting FALSE in VLOOKUP. Without it, VLOOKUP returns approximate matches and quietly wrong answers.

Which Excel Version Do You Need?

Every formula here except XLOOKUP works in any modern Excel. XLOOKUP requires Office 2021, Office 2024, or Microsoft 365, and it is a meaningful enough upgrade that it is worth factoring in if you do lookups regularly.

You do not need a subscription to get these. A one-time Office license includes the full desktop Excel with all of the above:

If you are weighing a one-time purchase against the Microsoft 365 subscription, our Microsoft 365 vs Office 2024 comparison runs the real cost math.

Where to Go Next

Once these fifteen feel natural, the next tier is worth exploring: SUMIFS and COUNTIFS (multiple conditions), FILTER and SORT (dynamic arrays in Office 2021 and newer), TEXTSPLIT, and PivotTables, which do in three clicks what would take a dozen formulas.

You will also move faster with keyboard shortcuts. Our guide to the best Microsoft Office keyboard shortcuts covers the ones that save the most time, and our hidden Office features piece has more tools most people never find.

Frequently Asked Questions

What are the most important Excel formulas for beginners?

SUM, AVERAGE, COUNT, COUNTA, MIN, MAX, IF, SUMIF, COUNTIF, XLOOKUP (or VLOOKUP), CONCAT, TRIM, LEN, TODAY, ROUND, and IFERROR. These fifteen cover the vast majority of everyday spreadsheet work.

What is the difference between XLOOKUP and VLOOKUP?

XLOOKUP is the modern replacement. It can search in any direction, does not break when you insert columns, and has a built-in “not found” option. VLOOKUP only looks rightward and breaks if column positions change. XLOOKUP requires Office 2021, Office 2024, or Microsoft 365.

Why does my formula break when I copy it down?

Almost always missing dollar signs. By default Excel shifts references as you copy, so a fixed value like a tax rate moves too. Lock it with $A$1, or select the reference in the formula and press F4 to cycle through the options.

Why does SUM return zero when there are numbers in the cells?

Your numbers are probably stored as text, which SUM ignores. Look for a small green triangle in the top-left corner of the cells. Select them, click the warning icon, and choose Convert to Number.

What does #DIV/0! mean and how do I hide it?

It means a formula tried to divide by zero or by an empty cell. Wrap the formula in IFERROR to show something readable instead, for example =IFERROR(B2/C2, “n/a”).

Why is my VLOOKUP or XLOOKUP not finding a match that exists?

Usually invisible trailing spaces in your data, especially if it was pasted from a website or another system. “North ” does not match “North.” Wrap the lookup value in TRIM to strip them.

Do I need Microsoft 365 to use these formulas?

No. Every formula here works in a one-time Office license. XLOOKUP needs Office 2021 or newer, and both Office 2024 Professional Plus ($20) and Office 2021 include it. There is no subscription required.

What is the difference between COUNT and COUNTA?

COUNT only counts cells containing numbers. COUNTA counts any non-empty cell, including text. Use COUNTA when you want to know how many rows have data in a name or category column.

Should I use ROUND or just format the cell to 2 decimals?

They are different. Formatting only changes what you see, while the full value stays underneath, so a column of formatted values can total slightly off. ROUND changes the actual value. Use ROUND when the number feeds into further calculations.

What is the fastest way to sum a column?

Click the cell directly below your numbers and press Alt + =. Excel inserts a SUM formula with the range already guessed. Press Enter to confirm.

Final Thoughts

Excel rewards a small amount of learning enormously. Fifteen formulas and one concept (absolute references) will carry you through most of what people actually do with spreadsheets at work and at home. Everything beyond that is refinement.

All of these run in the full desktop version of Excel, no subscription needed. A one-time Office 2024 Professional Plus license at $20 gives you Excel, Word, PowerPoint, Outlook, and the rest permanently, with XLOOKUP and every modern function included.