Excel rewards people who learn a few foundational ideas early — everything else, including most of the tricks elsewhere on this site, builds on these seven.
1. Cells, rows, columns, and the Name Box
Every cell has an address (like B7), and the Name Box — the small field to the left of the formula bar — always shows where you are and lets you jump anywhere by typing a cell reference directly into it. It’s also where you create named ranges once you’re ready for that.
2. Every formula starts with an equals sign
Type = and Excel switches into formula mode, letting you click cells to reference them instead of typing addresses from memory. This one habit — clicking instead of typing — cuts down on typos more than almost anything else.
3. Relative vs. absolute references
Drag a formula like =A1*B1 down a column, and normally both references shift down with it. Add a dollar sign ($A$1) to lock a reference so it stays fixed no matter where the formula is copied — essential the moment you’re multiplying a whole column against one fixed value, like a tax rate. The F4 key cycles through locking options automatically.
4. Formatting a cell is not the same as formatting its data
Typing 1500 and formatting the cell as currency displays $1,500.00, but the actual stored value is still 1500 — formulas referencing that cell use the real number, not the display. This distinction is why changing how something looks never breaks a calculation.
5. Sorting and filtering live on the Data tab
Select your data, turn on Filter, and small dropdown arrows appear on every column header, letting you sort or narrow down rows without touching a formula. It’s the fastest way to explore a dataset before deciding what to build with it.
6. A chart is built from a selection, not from scratch
Select the data you want to visualize first, then Insert > a chart type. Excel builds it from whatever’s selected, so a clean selection (headers included) makes for a clean chart with almost no cleanup afterward.
7. Where to go from here
With those seven ideas in place, tricks like Flash Fill, Recommended PivotTables, and named ranges stop feeling like separate tricks and start feeling like the obvious next step.