Home/Spreadsheets/HR & Employees/Interactive Excel Formulas Cheat Sheet

Interactive Excel Formulas Cheat Sheet

An Excel cheat sheet with 243 formulas and functions: a searchable workbook you can filter by name or by what a function does, plus a printable PDF reference guide. It opens in Microsoft Excel, has no macros and nothing to install, and is yours to reuse as often as you like.

What you get

Type-to-filter search across all 243 functions, by name or by task
Every function with its syntax, a plain-English description and a worked example
Modern Excel covered too: XLOOKUP, LAMBDA, dynamic arrays, TEXTSPLIT and more
Print-ready cheat sheet PDFs by category, in US Letter and A4
12 categories from Logical and Lookup to Dynamic Arrays and LAMBDA
Opens in Excel

$4.99one-time, no subscription

Buy on Etsy

Instant digital download · one-time purchase · no subscription

Interactive Excel Formulas Cheat Sheet — the workbook open in Excel

What it does

Type-to-filter search across all 243 functions, by name or by task
Every function with its syntax, a plain-English description and a worked example
Modern Excel covered too: XLOOKUP, LAMBDA, dynamic arrays, TEXTSPLIT and more
Print-ready cheat sheet PDFs by category, in US Letter and A4
12 categories from Logical and Lookup to Dynamic Arrays and LAMBDA

What it looks like

Interactive Excel Formulas Cheat Sheet screenshot

Every tab in the workbook

These are the actual sheet names in the file, not a feature list.

By task
PDF reference guide

Works in

Microsoft 365 or Excel 2021 for the live type-to-search (it uses FILTER)
The full table, filters and all PDFs work in any modern version of Excel

Honest scope

This is a record-keeping template, not legal or HR advice. Leave, overtime and pay rules vary by state and by employer policy; the file reports what you enter and does not decide what anyone is entitled to.

Others in HR & Employees

Interactive Excel Formulas Cheat Sheet$4.99Buy on Etsy