10 Excel Formulas Every Professional Should Know
Unosheet Ltd••1 min read
10 Excel Formulas Every Professional Should Know
Excel is a powerful tool for data analysis and automation. Below are 10 essential formulas every professional should master.
1. SUM
Adds up values in a range.
=SUM(A1:A10)
2. AVERAGE
Calculates the average (arithmetic mean) of a range.
=AVERAGE(A1:A10)
3. IF
Returns different values based on a condition.
=IF(A1>100, "High", "Low")
4. VLOOKUP
Searches for a value in a table.
=VLOOKUP(1001, A2:C10, 2, FALSE)
5. HLOOKUP
Searches for a value in a row.
=HLOOKUP("Sales", A1:D3, 2, FALSE)
6. INDEX
Returns a value from a specific cell in a range.
=INDEX(A2:C5, 2, 1)
7. MATCH
Returns the position of a value in a range.
=MATCH(50, A1:A10, 0)
8. CONCATENATE (or CONCAT)
Joins multiple text values into one.
=CONCATENATE(A1, " ", B1)
9. LEFT, MID, RIGHT
Extracts part of a text string.
=LEFT(A1, 5) | =MID(A1, 3, 4) | =RIGHT(A1, 3)
10. LEN
Counts the number of characters in a string.
=LEN(A1)