Excel Tutorials for Beginners

Why learn Excel

Excel isn't just for accountants. HR coordinators track headcount and PTO in it, sales reps build pipelines in it, marketers track campaign budgets in it, and warehouse supervisors count inventory in it. It's the single most common piece of software in office work outside of email, and it's the tool hiring managers assume you already know when a job posting says "proficient in Microsoft Office."

The good news: you don't need to learn everything. A relatively small set of skills — navigating the interface, entering data cleanly, formatting it so it's readable, and writing a handful of formulas — covers the vast majority of what real jobs require. This guide walks through that core skill set in order, the same order you'd want to learn it in a classroom or on the job.

If you want structured, click-along practice instead of just reading, pair this guide with the interactive lessons at /excel, starting with /lessons/excel-basics-getting-started and /lessons/excel-formulas-sum-average.

The Excel interface

Before you type a single number, it helps to know what you're looking at. Excel organizes your work into workbooks, which are the files you save (with a .xlsx extension). Each workbook contains one or more worksheets — the tabs along the bottom of the screen. Think of a workbook as a three-ring binder and each worksheet as one page in it.

Every worksheet is a grid of rows (numbered 1, 2, 3…) and columns (lettered A, B, C… then AA, AB, and so on). The box where a row and column intersect is called a cell, and every cell has an address, like B4 or A1. That address is how formulas refer to data, so getting comfortable reading cell addresses is the first real Excel skill.

Entering and editing data

Click a cell to select it, then type. Press Enter to confirm and move down, Tab to confirm and move right, or Escape to cancel without saving your entry. To edit an existing cell instead of replacing it entirely, double-click it or select it and press F2 — this drops your cursor right into the text so you can make a small change.

Excel automatically tries to guess what kind of data you're entering. Type 1/15 and it becomes a date. Type $500 and it becomes currency. Type 25% and it becomes a percentage. This is convenient most of the time, but it also causes one of the most common beginner headaches (see the Common Mistakes section below) when Excel "corrects" something you didn't want corrected — like turning a part number such as 03-15 into a date.

1. Click cell A1 and type a label, such as "Item".
2. Press Tab to move to B1 and type "Amount".
3. Press Enter to drop down to A2 and continue entering rows of data.
4. Select a range by clicking a cell and dragging to the last cell, or click the first cell and Shift+click the last cell.
5. To select an entire column or row, click its letter or number header.

Formatting cells

Formatting changes how a value looks without changing the underlying number — this distinction matters. A cell can contain the number 1500.5 but display as $1,500.50, and any formula referencing that cell still uses the real number 1500.5, not the rounded display.

The fastest way to format a cell is Ctrl+1, which opens the Format Cells dialog with tabs for Number, Alignment, Font, Border, and Fill. For everyday formatting, the Home tab's Number group has one-click buttons for currency, percentage, comma-separated thousands, and adding or removing decimal places.

Sorting, filtering, and tables

Once you have more than a handful of rows, you'll want to sort and filter rather than scroll and squint. Select your data, then on the Home or Data tab use Sort & Filter to sort A-to-Z, Z-to-A, or by a custom order (like sorting a status column as Open, In Progress, Closed).

Filtering adds a dropdown arrow to each header so you can show only the rows that match a condition — for example, only expenses over $100, or only orders from a specific region — without deleting or moving any data.

1. Click any cell inside your data range.
2. Go to Data → Filter (or press Ctrl+Shift+L) to add filter dropdowns to every header.
3. Click a dropdown arrow and check or uncheck values, or use Number/Text Filters for conditions like "greater than."
4. Convert the range to a real Table with Ctrl+T — this locks in headers, auto-extends formulas to new rows, and adds banded row shading automatically.
5. Use Freeze Panes (View tab) to lock header rows or ID columns in place so they stay visible while you scroll through hundreds of rows.

Saving and reopening files

Save with Ctrl+S early and often — Excel doesn't autosave by default unless the file is stored on OneDrive or SharePoint with AutoSave toggled on. The first time you save a new file, Excel asks for a file name and location; after that, Ctrl+S just updates the same file silently.

Use File → Save As (or F12) if you want to save a copy under a new name, switch formats (for example, to CSV for importing into another system), or keep an original template untouched while working on a new version.

Formula basics

Every formula starts with an equals sign. Type =5+3 into a cell and press Enter, and Excel shows 8. The real power comes from referencing other cells instead of typing raw numbers: =B2+B3 adds whatever is currently in B2 and B3, and if either value changes later, the total updates automatically.

Excel follows standard order of operations (parentheses, then multiplication/division, then addition/subtraction), so =2+3*4 returns 14, not 20. When in doubt, use parentheses to make the intent explicit: =(2+3)*4.

1. Click the cell where you want the result to appear.
2. Type = to start the formula.
3. Click the cells you want to include (or type their addresses) and add operators (+, -, *, /) between them.
4. Press Enter to calculate the result.
5. Click the cell again to see the formula itself in the Formula Bar.

SUM, AVERAGE, COUNT, MIN, and MAX

Functions are pre-built formulas for common calculations. These five cover a huge share of everyday spreadsheet work and are the natural next step after basic +/-/*// formulas. Practice them hands-on in /lessons/excel-formulas-sum-average and /lessons/excel-fn-sum-average-count.

Relative vs. absolute references

By default, references are relative: if you write =B2*C2 in cell D2 and copy it down to D3, Excel automatically adjusts it to =B3*C3. That's usually exactly what you want when applying the same formula down a whole column.

But sometimes you need one part of a formula to stay fixed no matter where you copy it — for example, a single tax rate cell that every row's formula should reference. That's what absolute references (dollar signs) are for. Adding $ before the column letter, row number, or both locks that part in place: $B$2 never changes when copied anywhere.

Real business examples

Two examples that show these skills working together, the way they actually show up in an office job.

Common beginner mistakes

A short list of the errors nearly every new Excel user makes at least once — and how to avoid them.

• Typing numbers as text (with a leading apostrophe or after Excel auto-formats them) so SUM silently ignores them — check that numbers are right-aligned, which signals Excel is treating them as actual numbers.
• Letting Excel auto-convert part numbers or codes like 03-15 into dates — format the cell as Text first if you're entering codes, not dates.
• Merging cells for visual layout, which then breaks sorting and formulas — use "Center Across Selection" (Format Cells → Alignment) instead.
• Hardcoding a number that should be a formula (like typing 1,204 instead of =SUM(B2:B20)) — if the data changes, the hardcoded number silently goes stale.
• Forgetting to lock a reference with $ before copying a formula across many rows, producing wrong results in every row but the first.
• Not saving before closing, especially in files without AutoSave enabled — get in the habit of Ctrl+S after any meaningful change.

Practice exercise

Build this from scratch to lock in everything above — it takes about 15 minutes and mirrors a real task you might be handed on day one of an office job.

1. Create a new workbook and label A1:D1 as Item, Quantity, Unit Price, and Line Total.
2. Enter five made-up products with quantities and prices in rows 2–6.
3. In D2, write =B2*C2 and copy it down to D6.
4. In D8, calculate the grand total with =SUM(D2:D6).
5. In F1, type a tax rate like 7%, then in E2 write =D2*$F$1 and copy it down — confirm the reference to F1 doesn't shift.
6. Format column D and E as Currency, and F1 as Percentage.
7. Sort the whole table by Line Total, highest to lowest, using Sort & Filter.
8. Save the file as practice-invoice.xlsx and reopen it to confirm everything saved correctly.

Key takeaways

Excel rewards a small, well-practiced core skill set far more than memorizing every feature it offers.

• Workbooks contain worksheets; cells are identified by column-letter + row-number addresses like B4.
• Formatting changes display only — the underlying value formulas use doesn't change.
• Every formula starts with =, and functions like SUM/AVERAGE/COUNT/MIN/MAX cover most everyday math.
• Use $ (absolute references) whenever a formula needs to keep pointing at one fixed cell as you copy it elsewhere.
• Ctrl+T tables, Filter, and Freeze Panes make growing datasets manageable without extra formulas.
• Save constantly, and format numbers as Text before typing codes Excel might misread as dates.

Frequently asked questions