How to use Excel, from a blank sheet to your first real report

Updated August 15, 2026

Nearly everyone learns Excel in the same way: someone sends you a file, you make it work, and you never find out what you were supposed to do instead. It gets the job done and it caps out at a very specific point — the file gets big, or someone asks a question the sheet cannot answer, and there is no obvious way forward.

The single most valuable thing to learn first is not a formula. It is how to lay data out. Get that right and sorting, filtering, pivot tables and charts all work immediately. Get it wrong and you spend years working around it.

1. Lay the data out the way Excel expects

Excel has strong opinions about data, and it does not tell you what they are. There are four rules:

1. One row per record. One sale, one employee, one invoice, one row.
2. One column per field, with a short heading in the first row. Date, Customer, Region, Amount.
3. No blank rows or columns inside the data. A blank row tells Excel your data has ended.
4. No merged cells anywhere near it. Merged cells break sorting, filtering and pivot tables, and they are the number-one cause of “why won’t it let me”.

Anything else — titles, notes, totals, the summary you are building — goes on a different sheet, not above or beside the data.

This feels fussy until the first time you sort a list with a merged cell in it and the rows come apart.

2. Turn it into a Table

With the cursor anywhere in the data, press Ctrl+T. That converts the range into an Excel Table, and it changes four things at once:

• Headers stay visible as you scroll.
• Filter arrows appear on every column.
• Formulas that reference it use column names — =[@Amount]*0.05 instead of =D2*0.05.
• It grows automatically. Add a row at the bottom and every formula, chart and pivot table built on it includes the new data.

That last one is the reason to do it. Without a Table, “the report doesn’t include last month” is a permanent recurring problem.

Give the Table a sensible name in Table Design → Table Name while you are there. Sales reads better than Table1 in every formula you write afterwards.

3. Move around without scrolling

Two keystrokes, and they change how the application feels:

• Ctrl + an arrow key jumps to the edge of the filled data in that direction. Ctrl+↓ goes to the bottom of the column instantly, however many thousand rows it is.
• Ctrl+Shift + an arrow key does the same thing while selecting.

Add Ctrl+Home to return to A1 and you can stop scrolling permanently. The rest are on the shortcut sheet, but those three do most of the work.

4. Sort and filter to answer the easy questions

With a Table, the filter arrows are already there. Click one and you can show only the rows you want — one region, one month, amounts over a threshold.

Two things worth knowing early:

• Select the numbers and read the status bar. The count, sum and average of whatever is selected appear at the bottom right of the window, respecting the filter. A large share of the questions people write formulas for can be answered by selecting a column and looking down there.
• Copying filtered data copies the hidden rows too, unless you press Alt+; first to select visible cells only. This catches everybody once.

5. Your first pivot table

This is the step that changes what Excel is for. A pivot table summarises a list without you writing anything.

Click inside your Table, then Insert → PivotTable → OK. You get an empty frame and a field list. Drag a text field such as Region into Rows, and a number field such as Amount into Values. That is a total by region, in about four seconds.

Then drag Month into Columns and you have a cross-tab. Drag Product into Rows underneath Region and you have a breakdown within each region. Nothing was typed, and none of it can be wrong in the way a hand-built formula can.

When the underlying data changes, right-click the pivot table and choose Refresh. Because the source is a Table, new rows are included automatically.

6. Make it usable by someone else

A pivot table answers the question you built it for. Add a slicer — PivotTable Analyze → Insert Slicer — and it answers the twelve follow-up questions without you touching it. A slicer is a set of buttons that filters the pivot table, and one slicer can drive several pivot tables at once, which is what turns three tables into a dashboard. That is covered in the slicers guide.

7. Formulas, once you need them

By this point you can summarise data without a single formula, which is the right order — formulas are for calculation, not summarising.

When you do need them, start with the four that cover most work: SUM, IF, SUMIFS and XLOOKUP. The formulas guide covers those and the reference behaviour underneath them, which matters more than the function names.

Where this stops

Everything above is the material of Introduction to Excel and the first part of Excel Intermediate 1. Doing it with an instructor is faster than doing it from a guide, mainly because the useful question is always about your file rather than the example — and in a class capped at 10 there is time for the instructor to open it.

What comes after: cleaning and combining data from several sources with Power Query, which is Advanced Data Management, and building reports that refresh rather than get rebuilt. If you want to know which of those you are ready for, the skill assessment will tell you.