7 Excel Formulas That Save You Hours Every Week
You do not need to be an Excel expert, just these seven friendly formulas. SUM, IF, COUNTIF, VLOOKUP and more, each with a plain-English example.
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.
IF is the gateway to "smart" spreadsheets. Once it clicks, you'll start spotting dozens of places to use it.
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.
Don't memorise these. Bookmark this page, and each time you face a task, come back and grab the right one. After using each a few times, they'll stick naturally.
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.
Ready to turn reading into a career?
Get your free data-readiness score and a personalised roadmap in 10 minutes.
🎯 Take the free assessment📖 Keep reading
Excel's Agent Mode Is Here. Does That Mean You Can Skip Learning Excel?
Excel can now build your budget tracker from one sentence. Here is what Agent Mode actually does, what it costs, and why you still need to know your formulas.
Read article →Is Excel Still Worth Learning in 2026, Now That AI and Python Exist?
Copilot can write your formulas and Python can crunch millions of rows. So is Excel still worth your time? Here is the honest answer, backed by real numbers.
Read article →Is RAG Dead in 2026? What the Debate Actually Means for You
A viral post says RAG is dead. The truth is messier and more useful to know. Here is what actually changed, in plain English, and whether you should still bother learning retrieval.
Read article →