FDM STUDIO CO.

Mastering a few key formulas in Microsoft Excel can completely transform how you work with data. Whether you’re managing budgets, analysing business data, or tracking school marks, these formulas will save you time and reduce errors.

Below are 20 essential Excel formulas every beginner (and even intermediate user) should know.

1. SUM

Adds a range of numbers.

=SUM(A1:A10)

2. AVERAGE

Finds the mean of values.

=AVERAGE(B1:B10)

3. COUNT

Counts cells that contain numbers.

=COUNT(C1:C10)

4. COUNTA

Counts all non-empty cells.

=COUNTA(A1:A10)

5. MAX

Returns the highest value.

=MAX(D1:D10)

6. MIN

Returns the lowest value.

=MIN(D1:D10)

7. IF

Returns one value if a condition is true, another if false.

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

8. SUMIF

Adds values based on a condition.

=SUMIF(A1:A10,">50")

9. COUNTIF

Counts cells that meet a condition.

=COUNTIF(B1:B10,"Yes")

10. AVERAGEIF

Calculates average based on a condition.

=AVERAGEIF(C1:C10,">50")

11. VLOOKUP

Searches for a value in a table (vertical lookup).

=VLOOKUP(F1,A1:D10,2,FALSE)

12. HLOOKUP

Searches horizontally across rows.

=HLOOKUP(F1,A1:D10,2,FALSE)

13. XLOOKUP (Modern replacement for VLOOKUP)

More flexible lookup function.

=XLOOKUP(F1,A1:A10,B1:B10)

14. CONCAT / CONCATENATE

Joins text together.

=CONCAT(A1," ",B1)

15. LEFT

Extracts characters from the left.

=LEFT(A1,3)

16. RIGHT

Extracts characters from the right.

=RIGHT(A1,2)

17. MID

Extracts text from the middle.

=MID(A1,2,5)

18. LEN

Counts the number of characters in a cell.

=LEN(A1)

19. TRIM

Removes extra spaces from text.

=TRIM(A1)

20. TODAY

Returns the current date.

=TODAY()

Conclusion

These 20 formulas form the foundation of almost everything you’ll do in Microsoft Excel. Once you understand how to use them, you’ll be able to analyse data faster, build cleaner reports, and automate repetitive tasks.