Knowledge Hub

Microsoft Excel

Practical Excel formulas, templates and dashboards for IE and production teams.

🔒 Some lessons and files are for members.Create account Member login

LARGE returns the nth largest value in a range.

SEQUENCE generates a series of sequential numbers.

SORT returns a sorted version of a range or array.

UNIQUE returns distinct values from a range or array.

FILTER returns only the rows that meet a condition, as a dynamic array.

TEXTJOIN joins text from multiple cells with a delimiter and can skip blanks.

REPLACE replaces characters at a specific position with new text.

PROPER capitalizes the first letter of each word in a text string.

LOWER converts all characters in a text string to lowercase.