Top 10 Excel Formulas Everyone Should Learn in 2025

Top 10 Excel Formulas You Must Know in 2025 ✨

Working with Excel becomes much easier when you know the right formulas. Most office reports, data entry tasks and analysis work depend on a few powerful functions. This guide explains the top ten Excel formulas with clear examples, simple tables and real situations you can practice. Whether you are a student, office worker or preparing for a job, these formulas will help you work faster and more accurately.

1. SUM Formula

Use: Add numbers quickly.

Formula:

=SUM(A2:A6)

Sample Table:

A (Sales)

120

340

210

185

Result:

=SUM(A2:A6) → 950

2. AVERAGE Formula

Use: Find the average value.

Formula:

=AVERAGE(B2:B6)

Sample Table:

B (Marks)

Result:

=AVERAGE(B2:B6) → 84

3. COUNT & COUNTA

COUNT: Counts only numbers

COUNTA: Counts numbers + text

Sample Table:

Michael

Emma

Results:

=COUNT(C2:C6) → 3

=COUNTA(C2:C6) → 5

4. IF Formula

Use: Check a condition and return result.

Formula:

=IF(D2>=60,"Pass","Fail")

Sample Table:

Student Marks

John 55

Olivia 75

Results:

John → Fail

Olivia → Pass

5. VLOOKUP Formula

Use: Search value from a table.

Formula:

=VLOOKUP(F2,A2:C6,3,FALSE)

Employee Table:

Emp ID Name Salary

201 John 4200

202 Emma 3800

203 Robert 4500

204 Olivia 4000

205 William 4600

Example:

If F2 = 203

=VLOOKUP(203,A2:C6,3,FALSE) → 4500

6. XLOOKUP Formula

Modern replacement for VLOOKUP.

Formula:

=XLOOKUP(F2,A2:A6,C2:C6,"Not Found")

If F2 = 205

Result → 4600

7. CONCAT & TEXTJOIN

CONCAT

Formula:

=CONCAT(A2," ",B2)

Sample Table:

First Name Last Name

James Miller

Sophia Clark

Results:

James Miller

Sophia Clark

TEXTJOIN

Formula:

=TEXTJOIN(", ",TRUE,A2:A4)

Sample Data:

Apple

Orange

Banana

Result:

Apple, Orange, Banana

8. TRIM Formula

Removes extra spaces.

Formula:

=TRIM(A2)

Example:

A2 = " New York "

Result → "New York"

9. SUMIF & COUNTIF

SUMIF Example

Formula:

=SUMIF(A2:A6,"New York",B2:B6)

Sample Table:

City Sales

New York 900

Chicago 650

New York 720

Dallas 500

New York 580

Result → 900 + 720 + 580 = 2200

COUNTIF Example

Formula:

=COUNTIF(C2:C6,"Approved")

Status

Approved

Pending

Approved

Rejected

Approved

Result → 3

10. FILTER Formula

Used for extracting specific rows.

Formula:

=FILTER(A2:C6,C2:C6="Pending")

Sample Table:

Task Owner Status

Invoice John Completed

Timesheet Emma Pending

Report Michael Pending

Audit File Olivia Closed

Checklist Daniel Pending

Result (Pending):

Conclusion

These formulas help you work faster and handle more data with confidence. Practice using the sample tables and you'll become comfortable in no time.

Comments

Why Dettol Burns When You Apply It on Wounds

Dettol is one of the most common antiseptics we use at home, but almost everyone feels a sharp burn when they put it on a cut. This reaction is normal and happens because Dettol contains strong germ-killing ingredients. When these ingredients touch broken skin, the exposed nerve endings react immediately, which creates the burning feeling. The main antiseptic in Dettol is chloroxylenol. It kills bacteria effectively, but it also irritates fresh wounds for a few seconds. Dettol may also contain alcohol, which adds to the sting because alcohol evaporates quickly and tends to irritate open skin. Fresh cuts are already inflamed, so even a mild antiseptic can feel aggressive when applied. The burning sensation usually settles in a short time. It doesn’t mean the wound is getting worse. If the cut is large or if someone has very sensitive skin, using saline water or a mild antiseptic wash is a more comfortable choice.

🌟 Supercalifragilisticexpialidocious: Meaning, History & Fun Facts

🌟 Supercalifragilisticexpialidocious : Meaning, History & Fun Facts 🔤 What does it mean? Supercalifragilisticexpialidocious is a playful, made-up word that means fantastic , wonderful , or extraordinarily good . It's used to express extreme joy, especially when ordinary words just aren’t enough. 🎬 Origin This magical word comes from the 1964 Disney film Mary Poppins , where it was sung by Julie Andrews and Dick Van Dyke . The song made the word world-famous! 🧩 Word Breakdown (Just for Fun) Super – Above Cali – Beauty Fragilistic – Delicate Expiali – To atone Docious – Educable or teachable Put together: “Atoning for being educable through delicate beauty beyond expectations!” 📘 Is it a real word? It's a nonsense word , but was added to the Oxford English Dictionary in 1986 as a humorous term. It’s used in fun, creative, or silly contexts. 🎉 Fun Fact The word has 34 letters and is one of the longest words in...

How Painkillers Know Where the Pain Is: Full Explanation

Introduction Many people wonder how a single pill can reduce headache, body pain, toothache, or joint pain. Does the tablet really know where the pain is? The truth is simple. Painkillers don’t have a brain. They don’t search for the problem. Your body itself guides the medicine to the right place. How Pain Happens in the Body Pain starts when the body releases chemicals called prostaglandins. These chemicals create : Inflammation Swelling Heat Pain signals to the brain When prostaglandins increase, you feel more pain. What Happens After You Swallow a Painkiller After you take a tablet: 1. It reaches the stomach. 2. It dissolves. 3. The medicine enters your bloodstream. 4. The blood carries it to every part of your body. The tablet doesn’t choose any body part. It just travels everywhere. So How Does the Medicine Know Where to Work? Very simple: Painkillers block the prostaglandin chemicals. Wherever prostaglandins are high, the medicine becomes active. For example: If prostaglan...

Global Gk

Search This Blog