Excel guides
Syntax, examples and FAQs for every function. All guides are always free.
Hot keys
Excel keyboard shortcuts (hot keys): 120+ most useful key combinations
The most useful Excel shortcuts in one place: copying, formatting, selecting, formulas, filters and working with sheets. Every shortcut comes with a plain-language description.
VLOOKUP
How to use VLOOKUP in Excel (with examples)
VLOOKUP searches for a value in the first column of a table and returns a value from another column in the same row. In Russian-language Excel it is called ВПР.
INDEX MATCH
How to use INDEX MATCH in Excel (a better VLOOKUP alternative)
MATCH finds the position of a value, and INDEX returns the value at that position. Together they can look up in any direction.
XLOOKUP
How to use XLOOKUP in Excel (with examples)
XLOOKUP (Excel 365 / 2021+) combines the power of VLOOKUP and INDEX+MATCH in one simple function.
IF
How to use the IF function in Excel (with examples)
IF tests a condition: it returns one result if the condition is true and another if it is false.
AND / OR
How to use AND and OR in Excel to check multiple conditions
AND returns TRUE if all conditions are met; OR returns TRUE if at least one is met.
SUM
How to use the SUM function in Excel (with examples)
SUM adds up cells, ranges and numbers and returns the total.
AVERAGE
How to calculate the average in Excel (AVERAGE, MIN, MAX)
AVERAGE returns the arithmetic mean of numbers, while MIN and MAX return the smallest and largest value.
COUNTIF
How to use COUNTIF and SUMIF in Excel: count and sum by condition
COUNTIF returns the number of cells that meet a condition, and SUMIF returns the sum of numbers in the rows that meet it.
LEFT / RIGHT
How to extract part of a text in Excel: LEFT, RIGHT, MID and LEN
LEFT takes characters from the left, RIGHT from the right, MID from the middle; LEN returns the length of the text.
CONCAT
How to combine text in Excel: CONCAT, & and TEXTJOIN
CONCAT and the & operator join several cells or strings into a single text.
TRIM
How to remove extra spaces and change text case in Excel (TRIM, UPPER, LOWER, PROPER)
TRIM removes extra spaces; UPPER, LOWER and PROPER convert text to uppercase, lowercase or title case.