7 Excel Formulas That Save You Hours Every Week

Excel is still the world's most popular data tool, and a handful of formulas can save you hours every week. You don't need to be an expert — just these friendly few. Let's meet them.

First, what a formula even is

A formula is an instruction that starts with an equals sign =. It tells Excel to calculate something for you instead of doing it by hand. Type =2+2 in a cell and Excel shows 4. That's a formula. Everything below is just that idea, made more useful.

1. SUM — add things up

=SUM(B2:B10)

Adds every number from B2 down to B10. Perfect for totals like monthly sales or expenses.

2. AVERAGE — find the typical value

=AVERAGE(B2:B10)

Gives the average. Great for "what's our usual daily order count?"

3. IF — make decisions

=IF(B2>=50, "Pass", "Fail")

Reads as: if the score in B2 is 50 or more, write "Pass," otherwise "Fail." IF lets Excel think for you.

4. COUNTIF — count only what matters

=COUNTIF(C2:C100, "Mumbai")

Counts how many cells say "Mumbai." Handy for "how many customers are from each city?"

5. VLOOKUP (or XLOOKUP) — find matching info

=VLOOKUP("A101", A2:D100, 3, FALSE)

Looks up item "A101" and returns the value from the 3rd column — like finding a price from a product code. If your Excel has the newer XLOOKUP, it's even simpler and worth learning.

6. TRIM — clean messy text

=TRIM(A2)

Removes those annoying extra spaces that sneak into copied data. A tiny formula that fixes a huge headache.

7. TEXTJOIN — stitch text together

=TEXTJOIN(" ", TRUE, A2, B2)

Combines a first name and last name into a full name with a space between. Great for tidying up lists.

The mindset that matters most

Every time you catch yourself doing something repetitive by hand in Excel, pause and ask: "Is there a formula for this?" There almost always is. That single habit is what separates people who use Excel from people who fly in it.