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

MATCH returns the position of a value in a range.

LEN returns the number of characters in a text string, including spaces.

LEFT returns the first N characters from a text string.

INDEX returns a value from a table based on row and column numbers.

IFS evaluates multiple conditions and returns the value of the first true one.

IFERROR returns a custom value when a formula produces an error.

IF returns one value if a condition is true and another if false.

FIND returns the position of text inside another text, case-sensitive.

COUNTIFS counts cells that meet multiple conditions at once.