Microsoft Excel is one of the most powerful tools for data management, analysis, and reporting. Whether you’re a student, job seeker, small business owner, or beginner data analyst, knowing the right formulas can save you hours of work.
In this post, we’ll cover the top 10 Excel formulas every beginner should master in 2025 — with examples and use cases.
🧮 1. SUM() – Add Numbers Quickly
Purpose: Adds up values in a range of cells.
Formula:
=SUM(A1:A5)
Example:
If cells A1 to A5 contain 10, 20, 30, 40, 50 → the result is 150.
Use Case: Total sales, expenses, or marks calculation.
🔢 2. AVERAGE() – Find the Mean Value
Purpose: Calculates the average (mean) of numbers.
Formula:
=AVERAGE(B1:B5)
Example:
If B1:B5 = 50, 60, 70, 80, 90 → Result = 70.
Use Case: Average marks, performance score, or daily revenue.
📉 3. MIN() & MAX() – Find Smallest and Largest Value
Purpose:
MIN()finds the smallest value.MAX()finds the largest value.
Formula:
=MIN(C1:C10)
=MAX(C1:C10)
Example:
Sales range ₹1,000–₹9,000 → MIN = 1,000, MAX = 9,000.
Use Case: Identify best and worst-performing products or months.
🔍 4. COUNT() – Count Numeric Cells
Purpose: Counts how many cells have numbers.
Formula:
=COUNT(D1:D10)
Example:
If D1–D10 contain 7 numeric values → result is 7.
Use Case: Count how many items sold, entries made, or transactions recorded.
🧾 5. COUNTA() – Count All Non-Empty Cells
Purpose: Counts all filled cells (numbers or text).
Formula:
=COUNTA(E1:E10)
Example:
If 8 out of 10 cells have data → result = 8.
Use Case: Check how many fields are filled in a form or dataset.
⚠️ 6. IF() – Make Logical Decisions
Purpose: Returns one value if a condition is TRUE, another if FALSE.
Formula:
=IF(F1>=40, "Pass", "Fail")
Example:
If F1 = 65 → Result = “Pass”.
Use Case: Result status, bonus eligibility, attendance check.
🚫 7. IFERROR() – Handle Errors Gracefully
Purpose: Avoids showing error messages like #DIV/0! or #N/A.
Formula:
=IFERROR(A1/B1, "Error Found")
Example:
If B1 = 0 → Result = “Error Found” instead of #DIV/0!.
Use Case: Clean reports and dashboards with no ugly error codes.
📅 8. TODAY() & NOW() – Get Current Date and Time
Purpose:
TODAY()shows current date.NOW()shows date + time.
Formula:
=TODAY()
=NOW()
Use Case: Auto-update report date, attendance, or invoice generation time.
🔗 9. CONCATENATE() / CONCAT() – Join Text
Purpose: Combines text from multiple cells.
Formula:
=CONCAT(A1, " ", B1)
Example:
If A1 = “Ajeet” and B1 = “Singh” → Result = “Ajeet Singh”.
Use Case: Merge first and last names, create product codes, or custom messages.
🔍 10. VLOOKUP() – Search Data in a Table
Purpose: Finds data from a specific column in a table.
Formula:
=VLOOKUP(A2, B2:D10, 3, FALSE)
Example:
Look up employee name (A2) and fetch salary from table.
Use Case: Employee details, product prices, or student marks lookup.
💡 Bonus Tip for 2025: Try XLOOKUP()
If you’re using Excel 2021 or Microsoft 365, replace old VLOOKUP with XLOOKUP() — it’s faster, smarter, and works both left and right.
✅ Final Thoughts
Learning these 10 Excel formulas is your first step toward becoming an Excel pro.
Once you master them, you’ll save time, reduce errors, and make your data work for you.
Stay tuned — in the next post, we’ll cover “10 Intermediate Excel Formulas for Career Growth in 2025.”