How to Use Excel – Step by Step Tutorial

I remember opening Excel for the first time and just staring at it. Grids everywhere. Eight tabs on the ribbon. Each tab hiding what felt like a hundred buttons I was never going to touch. It's overwhelming in a way that makes you want to close the laptop and find something else to do.

But here's the thing — and I've confirmed this over years of using it daily — you need maybe 5% of what Excel can do. For real. The other 95% exists for people in finance doing things I don't understand.

So when I sit down with someone who's never used Excel before, I tell them to ignore the ribbon completely for the first hour. Just click around. Type stuff into cells. Move with arrow keys. Get a feel for how the grid works — rows are numbered, columns are letters, and the top-left cell is A1. That's the naming system and it never changes.

Navigation is the first thing worth actually learning. Tab goes right, Enter goes down, and Ctrl+arrow keys jump to the edge of whatever data you've got. That last shortcut alone saves me probably 20 minutes a day. Not exaggerating.

The formulas you actually need

Excel has something like 500 functions built in. I use maybe a dozen regularly. The rest I google when the rare situation calls for it.

=SUM is the obvious starting point — =SUM(A1:A10) adds everything in a range. Tallying expenses, adding up scores, whatever. First one everyone learns and for good reason.

=AVERAGE does what it says — =AVERAGE(A1:A10) gives you the mean. I use this constantly for things like average daily traffic numbers or figuring out what my typical grocery spend looks like.

=COUNT counts cells that have numbers in them. =COUNT(A1:A10) tells you how many days had any data at all. Simple but I reach for it more than I'd expect.

=IF is where things start getting useful — =IF(A1>100,"Over","Under") checks a condition and returns one thing or another. I use it to flag stuff that needs attention, like line items that went over budget or students who scored below a cutoff.

=VLOOKUP is the one everyone struggles with. =VLOOKUP(A1,D:F,2,FALSE) searches for a value in a table and pulls back a matching column. The thing that trips people up — and I wasted an entire afternoon on this once — is that the column you're searching has to be the leftmost column in your range. If it's not, every result comes back as an error and you'll think you're going crazy. XLOOKUP fixes this and it's better in basically every way, but it only works in Excel 2021 and newer. So VLOOKUP is still worth knowing for compatibility, annoyingly.

=SUMIF adds things conditionally — =SUMIF(A:A,"Food",B:B) totals only the rows that match. I use this one a lot for breaking down spending by category.

And honestly, I'm not sure there's a seventh formula I'd put in the "learn first" bucket. Maybe CONCATENATE if you do a lot of text work. But those six cover most of what lands on my desk.

Making spreadsheets not look terrible

Most people approach formatting by clicking colors at random until something feels "nice." I did that for years. Here's what actually matters.

Format as Table — Ctrl+T — is the single biggest readability improvement you can make. It adds alternating row shading that makes scanning across columns way easier. Do this first.

Bold headers on a slightly darker background. Your eye finds column names instantly instead of hunting for them. Takes 10 seconds.

Number formatting. The difference between seeing 1234567.89 and $1,234,567.89 is the difference between squinting at digits and immediately understanding what you're looking at. Right-click, Format Cells, pick the right category.

Conditional formatting for spotting outliers. Highlight the top 3 and bottom 3 values so trends jump out at you without scanning cell by cell. I use this on every report I build.

Freeze the top row. View > Freeze Panes > Freeze Top Row. Never lose sight of your headers during long scrolls. Sounds minor. Isn't.

But the real trick nobody mentions: don't format anything until you're completely done entering data. If you format early, you'll redo everything when you inevitably add three more columns. I format last, always. Learned that one the hard way.

Shortcuts that become muscle memory

Excel is one of those tools where using the mouse genuinely makes you slower. The people who look fast in Excel aren't smarter — they just stopped reaching for the mouse.

Ctrl+; inserts today's date. Weirdly useful. I use it every time I'm logging something.

Ctrl+Shift+L toggles filters on and off. No ribbon clicking required.

Ctrl+Space selects the entire column. Shift+Space selects the entire row. Super handy when you need to format or delete a whole section.

Ctrl+T converts whatever you've selected into a formatted table. Already mentioned but worth repeating.

F4 repeats your last action. And inside formulas it toggles absolute references — $A$1 vs A1. This one took me way too long to discover.

Alt+= auto-sums the numbers directly above or to the left. So the workflow becomes Alt+= then Enter and you've summed a column in under a second. Once your fingers know this you'll never manually type =SUM(...) again.

Charts that don't hurt to look at

Default Excel charts are ugly. Grey plot backgrounds, gridlines everywhere, legends floating in weird positions. Fixing them is fast.

Click the chart, hit the + icon that appears next to it, and uncheck everything that isn't essential. Then right-click the chart background, set it to No Fill. Suddenly it looks clean instead of like something printed in 2003.

For anything with time on the bottom axis — months, years, dates — use a line or column chart. For part-to-whole stuff like budget breakdowns or market share, use a horizontal bar chart. Not a pie chart. Pie charts with more than 3 slices are genuinely useless and tbh I don't know why Excel even lets you make them. Maybe there's some edge case I'm not thinking of.

Pivot tables without the fear

Pivot tables sound advanced. They're not. They're just drag-and-drop summaries. Select your data, Insert > PivotTable, and you get a blank canvas with fields listed on the right.

Drag one field to "Rows" — those become your categories. Drag another to "Values" — that's what gets calculated. That's literally the whole thing. Excel defaults to summing, but right-click any cell in the Values area and you can switch to Average, Count, Max, Min, whatever fits.

The patterns I come back to constantly: sales by region, expenses by category, website traffic by source, survey responses by demographic. Basically anytime the question is "how much of X, per Y."

One thing that confused me for literal years: pivot tables don't auto-refresh. If you change the source data, right-click inside the pivot table and hit Refresh. Otherwise you're staring at old numbers and making decisions on outdated info without realizing it. I've done that. Multiple times.

Sorting without destroying your data

The number one way beginners wreck spreadsheets: selecting a single column, sorting it alphabetically, and permanently disconnecting all the related data in the other columns. If you do nothing else, select your entire data range before sorting. Or just use Format as Table — it handles range expansion automatically and prevents this whole category of disaster.

Filters are safer for day-to-day work. Click the dropdown on a column header and you can show only rows matching whatever condition: text containing "urgent," numbers above 500, dates in the last 30 days. Combined with Ctrl+Shift+L to toggle them, filters become the fastest way to slice data without touching a formula.

Protecting yourself from... yourself

Three habits that have genuinely saved me from redoing hours of work.

Ctrl+S constantly. Autosave exists but it's not always on, especially with files opened from email or downloads. I hit it every few minutes without thinking now.

Never work directly in the original file when making big changes. Right-click the sheet tab > Move or Copy > check Create a copy. Duplicate first, experiment on the copy, delete it when you're done. So simple but most people don't do it.

Name your sheets something meaningful. "Sheet1" through "Sheet7" is impossible to navigate when you open the file three months later. I name every sheet the second I create it now.

Spend two minutes organizing upfront and you avoid the 45-minute headache of untangling which version was the right one. This isn't a hypothetical — I've lived it.

The stuff tutorials never mention

The gap between someone who "knows Excel" and someone who's actually productive comes down to two things: keyboard comfort and a small mental catalog of go-to formulas. Not 50 formulas. Not every ribbon tab memorized. Just the core half-dozen that map to actual tasks you do repeatedly.

What bugs me about most Excel advice is how it presents learning as linear — beginner, then intermediate, then advanced. It's not like that at all. You'll use =SUM and =INDEX(MATCH(MATCH(...))) on the same day because different problems need different tools. The real skill isn't knowing more functions. It's knowing which function fits the question in front of you. And that intuition comes from messing around with real data and real problems, not from watching tutorials.

If you're just starting, grab some actual numbers — a bank statement, a simple budget, workout logs, whatever you have — and try answering three questions: what's the total, what's the average, what's the trend over time. By the time you work through those, you'll have accidentally learned more than most people do in a week of watching videos. And you'll have actually done something useful with your own data, which is kind of the whole point.