Excel Formulas Cheat Sheet PDF for Beginners: The Hidden Limits

Searching for an Excel formulas cheat sheet PDF for beginners is a smart first move. A good one saves you from retyping syntax you only need twice a month. But a printed list has limits, and you find them the first time a copied formula returns an error. This guide covers which formulas belong on your sheet, where PDFs mislead you, and how to build a one-page version around your own work.

What belongs on a beginner cheat sheet

Start small. A beginner sheet needs about a dozen formulas, grouped by the job they do rather than by the alphabet. Corporate Finance Institute's formulas cheat sheet sorts its list into dates, lookups, math, financial and conditional functions, with a copyable example for each. For a bigger library, Exceljet's collection of more than 1,000 formula examples walks through each task step by step.

The table below shows a starter set based on the example patterns in the CFI list. The lookup value sits in E2 here, because a value placed inside its own search range simply finds itself. Swap the ranges for your own data before you use any of them.

Read each formula left to right. The function name comes first, then the arguments inside parentheses, separated by commas. In =SUMIF(A2:A100,"North",B2:B100), the first argument is where to look, the second is what to look for, and the third is what to add up. Once you can read one formula, the rest follow the same pattern.

Financial functions look scary, but PMT is friendly. The formula =PMT(0.05/12,60,-10000) divides a 5% yearly rate by 12 months, assumes 60 payments, and enters the loan as a negative number so the payment comes back positive. Those figures are examples, so use your own loan details. To see these functions working together, Contextures' loan payment schedule template lists monthly payment details from the loan information you type at the top.

Where a PDF cheat sheet lets you down

Lists follow the alphabet, but your problems do not

Most cheat sheets organise by function name. You, on the other hand, start with a task: add up sales for one region, find a price, or flag late invoices. That mismatch means you scan a long list for a name you do not know yet. A task-first index fixes it, and the table above is a small example.

Version gaps cause #NAME? errors

Before you trust any Excel formulas cheat sheet PDF for beginners, check which Excel version it assumes. Microsoft's alphabetical function list tags newer functions with the release that introduced them. IFS and MAXIFS arrived in 2019, FILTER and LET in 2021, and LAMBDA in 2024, while GROUPBY is listed for Microsoft 365. In an older copy of Excel, a function it does not recognise returns a #NAME? error. Press Ctrl+F on that page and type the function name to see where yours stands.

Google Sheets covers many of the same functions, though not every one, so test any formula in your own file before you rely on it.

Copy and paste damage

PDFs often turn straight quotation marks into curly ones. Excel rejects curly quotation marks around text but accepts straight ones, so a formula copied from a PDF can fail even though it looks right. Stray line breaks and extra spaces cause trouble too. Paste the formula into the formula bar, retype the quotation marks by hand, and check that every opening parenthesis has a partner.

Build your own Excel formulas cheat sheet PDF for beginners

Your best reference is the one built from formulas you already got working. Add a tab named Cheats to your workbook with four columns: Task, Formula, Note and Version. Each time a formula works, paste it in with a plain-English note about what the ranges mean. Ten useful rows beat a hundred you never open.

Task | Formula | Note
Sum by region | =SUMIF(A2:A100,"North",B2:B100) | Use straight quotes
Find a price | =XLOOKUP(E2,A2:A100,C2:C100,"Not found") | Needs a recent Excel
Find a price, older Excel | =INDEX(C2:C100,MATCH(E2,A2:A100,0)) | 0 means exact match
Count big orders | =COUNTIF(B2:B100,">100") | Criteria go in quotes

The Version column matters more than it looks. Note whether a formula needs a recent Excel or works everywhere, so you never send a colleague a file that breaks on their machine. If the INDEX and MATCH pair is new to you, the INDEX and MATCH lesson on Formula Foundry explains it from scratch.

When the tab looks right, export it. In Excel, choose File, then Save As, and pick PDF as the file type. In Google Sheets, choose File, then Download, then PDF. Check the export options so the PDF holds only the Cheats tab and not every sheet in the workbook.

Mistakes a cheat sheet rarely mentions

Syntax is the easy part. These four slips cause many of the errors beginners hit, and none of them show up in a plain list of functions.

• Unlocked references. Copy =SUMIF(A2:A100,"North",B2:B100) one row down and the ranges shift to A3:A101. Write $A$2:$A$100 to keep them fixed.
• Missing exact match settings. VLOOKUP needs FALSE as its last argument, and MATCH needs 0, to ask for an exact match. Leave them off and you can get a wrong answer with no error at all.
• Numbers stored as text. COUNT only counts cells that hold real numbers, so text that looks like a number gives a lower total than you expect.
• Ranges that stop short. =SUM(B2:B100) ignores row 101. If your data keeps growing, use a whole-column reference such as =SUM(B:B) or an Excel table.

When describing the result beats memorising syntax

A cheat sheet helps when you know the function name. It helps less when you only know the outcome you want. For that case, an Excel formula builder lets you describe the job in plain English and returns a formula, and Formula Foundry's Excel formula builder works this way. Read the result, test it on three or four rows where you already know the answer, and then paste it into your Cheats tab with a note.

Google Sheets users get an extra option, since one array formula can fill a whole column at once. The guide on using array formulas in Google Sheets shows how that works and when it saves you from dragging.

Download any Excel formulas cheat sheet PDF for beginners you like, then treat it as a starting point. Pick the five formulas from your last week of work, put them on your own Cheats tab, and add one row every time a formula finally works. After a month, you will own a reference that fits your spreadsheets better than any generic list.

Action Steps

1. List your recurring tasks: Write down the five spreadsheet jobs you repeat most, such as totals by region, price lookups, or date math.
2. Create a Cheats tab: Add a tab with four columns: Task, Formula, Note and Version, and paste in each formula as soon as it works.
3. Check version support: Look up any newer function, such as XLOOKUP, FILTER or LET, in Microsoft's function list to confirm your Excel includes it.
4. Retype quotation marks after pasting: If you copy a formula from a PDF, replace the quotation marks by hand and confirm the parentheses pair up.
5. Export to PDF: Use File, then Save As in Excel or File, then Download in Google Sheets, and include only the Cheats tab.

Frequently Asked Questions

What should an Excel formulas cheat sheet include for beginners?

Start with SUM, AVERAGE, COUNTIF, SUMIF, IF, a lookup function such as XLOOKUP or INDEX and MATCH, IFERROR, and a date function like EDATE. Group them by task so you can find the right one quickly.

Why does a formula from a cheat sheet PDF give an error when I paste it?

Copied text often carries curly quotation marks, stray spaces or line breaks. Retype the quotation marks, remove extra spaces, and check that your Excel version supports every function in the formula.

Do Excel and Google Sheets use the same formulas?

Many functions work in both, including SUM, AVERAGE, COUNTIF and SUMIF, but not every function exists in both programs. Test a formula in your own file before you rely on it.

How do I save my own cheat sheet as a PDF?

In Excel, choose File, then Save As, and pick PDF as the file type. In Google Sheets, choose File, then Download, then PDF. Check the export options so only your cheat sheet tab is included.