Microsoft Excel is one of the most important tools in data analysis. Whether you're cleaning data, building reports, or preparing datasets for pipelines, Excel skills are essential.
BASIC EXCEL FUNCTIONS
➤ SUM
Adds values in a range
=SUM(A1:A10)
➤ AVERAGE
Finds the mean
=AVERAGE(A1:A10)
COUNT
Counts numeric values
=COUNT(A1:A10)
Logical Functions
➤ IF
=IF(A1>50, "Pass", "Fail")
Returns values based on a condition
➤ AND
=AND(A1>50, B1="Yes")
Checks multiple conditions
➤ OR
=OR(A1>50, B1="Yes")
Returns TRUE if one condition is met
** Lookup & Reference Functions**
➤ VLOOKUP
=VLOOKUP(A2, A1:C10, 3, FALSE)
Searches vertically
➤ HLOOKUP
=HLOOKUP(A2, A1:C3, 2, FALSE)
Searches horizontally
➤ INDEX + MATCH (Better alternative)
=INDEX(B1:B10, MATCH(A2, A1:A10, 0))
➤ LEN
Counts characters
=LEN(A1)
CONCAT / CONCATENATE
Join text
=CONCAT(A1, " ", B1)
These are some of the formulae's used daily in excel
Top comments (0)