How to use the Excel Formulas Cheat Sheet
- 1. Search or browseType a word like the function or task you need, or pick a section.
- 2. CopyEach snippet has its own Copy button, so you can paste it straight into your editor.
- 3. DownloadSave the whole Excel Formulas cheat sheet as plain text or Markdown for offline revision.
What's in it
It's written for office, MIS and analyst work in Excel 365, with notes where a formula needs a newer version. The 39 snippets are organised into 10 sections: Maths, Conditional, Lookup, Text, Dates, Dynamic arrays, Errors, References, Finance, Shortcuts.
Example
Search "EMI" to find =PMT(10%/12, 60, -500000), which gives the monthly instalment for a ₹5 lakh loan at 10% a year over 5 years, about ₹10,624. Search "slab" for an XLOOKUP that finds the next smaller match, useful for tax slabs or grade bands.
Tips for using it
- Use Excel Tables and structured references; formulas stay correct when rows are added.
- Wrap lookups in IFNA rather than IFERROR so real mistakes still show.
A quick look, one snippet per section
- Maths:
=SUM(A2:A10)(add a range) - Conditional:
=IF(B2>=40, "Pass", "Fail")(simple condition) - Lookup:
=XLOOKUP(E2, A:A, C:C, "Not found")(look up in any direction (Excel 2021/365)) - Text:
=TRIM(A2) · =PROPER(A2) · =UPPER(A2)(clean and case) - Dates:
=TODAY() · =NOW()(current date / date-time) - Dynamic arrays:
=UNIQUE(A2:A100)(distinct values) - Errors:
=IFERROR(B2/C2, 0) · =IFNA(XLOOKUP(...), "-")(handle errors) - References:
A1 · $A$1 · $A1 · A$1 (F4 cycles)(relative, absolute, mixed) - Finance:
=PMT(10%/12, 60, -500000)(monthly EMI for ₹5 lakh at 10% for 5 years)
Search the box above for the rest of the Excel Formulas snippets, or download the full sheet.
Frequently asked questions
Do these work in Google Sheets?
Most do; TEXTBEFORE, TEXTAFTER and LET may differ.
Which Excel version?
Microsoft 365. Older versions lack XLOOKUP, FILTER and other dynamic array functions.
Is the Excel Formulas cheat sheet free?
Yes. You can search, read and copy every snippet in the Excel Formulas cheat sheet without signing up. The first time you download it, we ask once for your name and WhatsApp number; after that downloads and every other Uncodemy tool open straight away.