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...

Why Do We Dream? The Mystery Behind Our Sleeping Mind

💤 Why Do We Dream? The Mystery Behind Our Sleeping Mind Photo Credit: AI-generated with OpenAI's ChatGPT. Free to use. Dreams have fascinated humans for thousands of years. Some believe dreams are messages from the subconscious, while others think they are just random brain activity. So, what does science say? 1. What Are Dreams? Dreams are thoughts, images, and sensations that occur during sleep—especially during a phase called REM (Rapid Eye Movement) sleep. This is when the brain is most active. 2. Why Do We Dream? Experts are still studying dreams, but some popular theories include: Memory Processing: Our brain stores and sorts information from the day. Emotional Balance: Dreams may help us deal with stress, sadness, or joy. Problem Solving: Some people get new ideas or solutions from dreams. 3. Can Dreams Predict the Future? There is no scientific proof that dreams can predict the future. However, because they reflect our thoughts and fears, ...

Global Gk

Search This Blog