Free download

Excel cheat sheets you can print

4 pages, 29 functions, one worked formula each. Every formula is checked against a LogicExcel lesson, so when one does not stick you can practise it free in a live spreadsheet.

What is inside

Page 1

12 formulas every office job uses

SUM, AVERAGE, COUNTIF, SUMIF, IF, XLOOKUP, VLOOKUP, TRIM, PROPER, CONCAT, UNIQUE, FILTER

For example, add up a column: =SUM(B2:B6) practise it in lesson 1

Page 2

Excel lookups on one page

VLOOKUP, HLOOKUP, XLOOKUP, MATCH, INDEX, FILTER

For example, look down the first column: =VLOOKUP("Ike", A1:B4, 2, 0) practise it in lesson 11

Page 3

Clean up messy text in Excel

TRIM, PROPER, UPPER, LOWER, LEN, LEFT, RIGHT, MID, SEARCH, CONCAT, TEXTJOIN

For example, remove extra spaces: =TRIM(A2) practise it in lesson 89

Page 4

Count and sum by a rule

COUNT, COUNTIF, COUNTIFS, SUM, SUMIF, SUMIFS, AVERAGE, MAX, MIN, LARGE

For example, how many numbers: =COUNT(A2:E2) practise it in lesson 25

Would you rather start practising now? Every exercise is free and needs no account: see all the Excel exercises.