SORT Function in Excel: Sort Data With a Formula
SORT returns a sorted copy of a range; the original stays untouched and the result re-sorts as data changes.
Read article →Category Archives: Excel Functions A–Z
Every Excel function explained with syntax, examples, common errors and powerful combinations — from beginner to expert.
FILTER Function in Excel: Return Every Row That Matches
FILTER Function in Excel: Return Every Row That Matches
FILTER returns all rows (or columns) that meet a condition, and the result updates live as data changes.
Read article →HLOOKUP Function in Excel: Look Up Across the Top Row of a Table
HLOOKUP Function in Excel: Look Up Across the Top Row of a Table
HLOOKUP is VLOOKUP turned sideways: it searches the top row and returns a value from a row below.
Read article →TRIM Function in Excel: Remove Extra Spaces
TRIM Function in Excel: Remove Extra Spaces
TRIM removes leading and trailing spaces and reduces multiple spaces between words to one. Essential after copying data from websites and ERPs.
Read article →XLOOKUP Function in Excel: The Modern Lookup That Replaces VLOOKUP
XLOOKUP Function in Excel: The Modern Lookup That Replaces VLOOKUP
XLOOKUP finds a value in one range and returns the matching item from another. It looks in any direction, defaults to exact match, and…
Read article →SWITCH Function in Excel: Match One Value Against a List
SWITCH Function in Excel: Match One Value Against a List
SWITCH compares one value with a list and returns the matching result — cleaner than nested IFs for exact matches.
Read article →MINIFS Function in Excel: Smallest Value Meeting Conditions
MINIFS Function in Excel: Smallest Value Meeting Conditions
MINIFS returns the minimum of values where all conditions are true.
Read article →MAXIFS Function in Excel: Largest Value Meeting Conditions
MAXIFS Function in Excel: Largest Value Meeting Conditions
MAXIFS returns the maximum of values where all conditions are met; MINIFS returns the minimum.
Read article →TEXTJOIN Function in Excel: Join Text With a Separator, Skipping Blanks
TEXTJOIN Function in Excel: Join Text With a Separator, Skipping Blanks
TEXTJOIN joins a range of text with a delimiter and can ignore empty cells.
Read article →CONCAT Function in Excel: Join Text From Cells and Ranges
CONCAT Function in Excel: Join Text From Cells and Ranges
CONCAT joins text from several cells or whole ranges. It replaces the older CONCATENATE. The & operator does the same for a few cells.
Read article →XIRR Function in Excel: Real Return on SIPs and Irregular Cash Flows
XIRR Function in Excel: Real Return on SIPs and Irregular Cash Flows
XIRR returns the annualised return for cash flows on specific dates — the right way to measure SIP and mutual-fund returns.
Read article →NPV Function in Excel: Net Present Value of Future Cash Flows
NPV Function in Excel: Net Present Value of Future Cash Flows
NPV discounts future cash flows to today’s value at a given rate — the core of investment appraisal.
Read article →