✅ 1. SUM() – Add Numbers Easily
Adds all numbers in a selected range.
Example:=SUM(A1:A10)
Adds values from A1 to A10.
✅ 2. AVERAGE() – Find the Mean Value
Gives the average of numbers.
Example:=AVERAGE(B2:B8)
Calculates the average of B2 to B8.
✅ 3. XLOOKUP() – Modern Lookup Function (Excel 365)
Searches for a value and returns the matching result (better than VLOOKUP).
Example:=XLOOKUP(A2, A1:A10, B1:B10)
Looks for A2 in column A and returns matching data from column B.
✅ 4. FILTER() – Filter Data Dynamically
Returns only the rows that match a condition.
Example:=FILTER(A1:C20, C1:C20>50)
Shows rows where column C values are greater than 50.
✅ 5. SORT() – Sort Data Automatically
Sorts data in ascending or descending order.
Example:=SORT(A1:A10)
Sorts the list from A1 to A10.
✅ 6. UNIQUE() – Remove Duplicate Values
Returns only unique values from a range.
Example:=UNIQUE(A1:A20)
Shows only non-repeated items.
✅ 7. IF() – Logical Checking
Returns a result based on a condition.
Example:=IF(B2>=40, "Pass", "Fail")
Shows “Pass” if B2 is 40 or more.
✅ 8. TEXT() – Format Numbers as Text
Changes the display format of a number.
Example:=TEXT(A1, "dd-mm-yyyy")
Converts date into the format 15-11-2025.
✅ 9. CONCAT() – Join Text Easily
Joins text from two or more cells.
Example:=CONCAT(A1, " ", B1)
Combines A1 and B1 with a space.
✅ 10. TODAY() – Show Current Date
Returns today’s date based on your system.
Example:=TODAY()
Displays something like 14-11-2025.