Excel for Beginners Cheat Sheet: The First 15 Things You Need to Learn
Starting with Excel can feel overwhelming. You are looking at a massive grid of blank boxes, and it is hard to know where to begin. This beginner’s cheat sheet breaks down the absolute fundamentals. Learn the basic layout, the essential terminology, and the 5 everyday formulas that will make you look like a pro on day one.
[BUTTON: Download Beginner Printable PDF]
1. The Anatomy of Excel: Basic Terms
Before writing formulas, you need to understand how Excel is structured. Think of it as a map with coordinates.
| Term | What it Means | Example / Visual |
|---|---|---|
| Workbook | The entire Excel file you open. It can hold multiple individual sheets. | Your saved file: Budget_2026.xlsx |
| Worksheet (Tab) | A single page inside your workbook. You switch between them at the bottom left. | “January Sales”, “Q2 Expenses” |
| Cell | A single box where rows and columns meet. Each cell has an address. | B4 (Column B, Row 4) |
| Formula Bar | The long white bar at the top of Excel. It shows what is actually inside a cell. | Displays =SUM(A1:A5) instead of the final number. |
| Range | A collection of two or more cells selected together. | A1:A10 (All cells from A1 down to A10) |
2. Fast Keyboard Shortcuts for Day One
Mouse clicks waste time. Master these five simple shortcuts to instantly move and edit data faster than your coworkers.
| Action | Windows Shortcut | Mac Shortcut | Why You Need It |
|---|---|---|---|
| Undo Last Action | Ctrl + Z |
Cmd + Z |
The ultimate “safety net” when you make a mistake. |
| Redo / Repeat | Ctrl + Y |
Cmd + Y |
Repeats the last formatting action or action you just deleted. |
| Instant AutoSum | Alt + = |
Cmd + Shift + T |
Automatically writes the SUM formula for a column of numbers. |
| Edit Active Cell | F2 |
Control + U |
Lets you change text inside a cell without rewriting everything. |
| Copy & Paste | Ctrl + C / Ctrl + V |
Cmd + C / Cmd + V |
Moves data instantly from one place to another. |
3. The 5 Basic Formulas Every Beginner Must Know
All Excel formulas begin with an equals sign (=). If you do not type =, Excel will just treat your formula as normal text.
1. SUM (Add numbers together)
Instead of typing =A1+A2+A3, use SUM to add an entire range.
- How to type it:
=SUM(B2:B10) - What it does: Adds every single number between cell B2 and B10.
2. AVERAGE (Find the middle ground)
Calculates the mathematical mean of your selected numbers.
- How to type it:
=AVERAGE(C2:C20) - What it does: Adds the numbers and divides by the total count automatically.
3. COUNT (Count cells with numbers)
Tells you how many items are in your list, ignoring blank boxes or text.
- How to type it:
=COUNT(A2:A100) - What it does: Gives you a quick tally of how many entries have numeric data.
4. MAX & MIN (Find the highest and lowest)
Locates the biggest or smallest number in a dataset instantly.
- How to type it:
=MAX(D2:D50)or=MIN(D2:D50) - What it does: Great for finding the highest sales figure or lowest expense.
4. Golden Rules for Excel Beginners
- Keep Headers Simple: Use row 1 for your column titles (like Date, Name, Amount). Keep them bold and short.
- Never Mix Text and Numbers: If you write “10 USD” in a cell, Excel cannot use it in a formula. Write “10” and use the Currency Button on the home ribbon to add the symbol.
- The Magic Fill Handle: Look at the bottom-right corner of a selected cell. See that tiny green square? Click and drag it down to automatically copy formulas or patterns instantly.
5. Frequently Asked Questions (FAQ)
Why does my Excel cell show ###?
Do not panic. Your formula is not broken. ### simply means the column is too narrow to display the number. Hover your mouse between the column letters at the top (e.g., between B and C) and double-click to automatically resize it.
How do I start a new line of text inside one cell?
If you press Enter, Excel moves you to the cell below. To start a new line inside the same cell, hold down Alt and press Enter (Windows) or hold Option and press Return (Mac).
How do I clear formatting without deleting text?
If a sheet has messy colors and borders, select the cells, go to the Home tab, click the Clear button (the pink eraser icon on the right side), and select Clear Formats.