Why your first spreadsheet should be a real one
Most people open Excel for the first time because someone hands them a list: sales from last month, a stock count, a budget, a sign-up sheet. The list is usually already there. What is missing is the answer: how much did we sell, which product earned the most, what is the total? If you have ever typed numbers into a calculator and then copied the result back into a spreadsheet, this lesson is for you. You will learn the three ideas that everything else in Excel is built on: cell addresses, formulas that point at cells, and adding a whole column with one function.
We work with one small, fictional business throughout the course: an online stationery shop that sells notebooks, pens, planners and sticky notes. In this first lesson you take the shop's June sales list, six products with units sold and a price, and turn it into revenue per product, total units and total revenue. Then you answer a question that sounds trivial but catches many beginners: which product brought in the most money? The answer is not the product that sold the most units, and seeing why is a good first lesson in letting the spreadsheet do the thinking.
You do not need any prior knowledge. The interactive lab above works in your browser, checks every cell you fill in and tells you what went wrong if a formula is off. Everything you learn there works the same way in Microsoft Excel on Windows and Mac, in Excel for the web, and almost identically in Google Sheets and LibreOffice Calc.
The core idea: cells, addresses and formulas
A worksheet is a grid. Columns are labelled with letters (A, B, C …) and rows with numbers (1, 2, 3 …). Every box in the grid is a cell, and every cell has an address made of its column letter and row number. B2 is the cell in column B, row 2. D8 is column D, row 8. When you click a cell, its address appears in the Name Box at the top left, just above column A.
A cell can hold three kinds of content. Text such as "Notebook A5" is a label for humans. A number such as 340 is data. A formula is a calculation, and it always starts with an equals sign. If you type =340*12.5, Excel shows 4,250. That is correct, but it is a calculator, not a spreadsheet. The moment someone corrects the units sold, your 4,250 is wrong and nobody notices.
The spreadsheet way is to point at the cells that hold the numbers: =B2*C2. This formula says "take whatever is in B2 and multiply it by whatever is in C2". Today that is 340 × 12.50 = 4,250.00. Tomorrow, if B2 changes to 350, the result updates to 4,375.00 by itself. This is the single most important habit in Excel: formulas refer to cells, they do not contain typed numbers. The lab checks for exactly this. A typed 4250 in D2 is marked as a value, not a formula.
The four basic operators are + (add), - (subtract), * (multiply) and / (divide). Excel uses an asterisk for multiplication, not an x, and a forward slash for division. To finish a formula press Enter, which also moves the cursor one cell down, ready for the next row.
Copying a formula: why Excel "moves" your references
Six products need six revenue formulas, but you only write one. When you copy =B2*C2 from D2 to D3, Excel does not paste the identical text. It keeps the relationship: "the cell two columns to the left times the cell one column to the left, in my own row". In D3 that becomes =B3*C3, in D4 =B4*C4, and so on down to =B7*C7. References that shift like this are called relative references, and they are the default.
The quickest way to copy down is the fill handle, the small square at the bottom-right corner of the selected cell. Drag it down to D7, or simply double-click it: Excel fills down as far as the column to the left has data. Later in the course you will meet the opposite case, a reference that must not move when you copy (a discount rate in one fixed cell). That is what the dollar sign in $B$10 is for, and it is the topic of lesson 2.
Adding a column with SUM and AutoSum
You could add six revenue cells with =D2+D3+D4+D5+D6+D7. It works, but it is long, easy to mistype and it breaks when you insert a seventh product. The SUM function does the same job in one short formula: =SUM(D2:D7). The colon means "from … to", so D2:D7 is the range of all cells from D2 down to D7. A function is simply a named calculation that Excel already knows; you give it the input in brackets, and it returns the result.
AutoSum writes the SUM formula for you. Click the empty cell directly below a column of numbers and press Alt + = on Windows (Cmd + Shift + T on a Mac). Excel guesses the range above, shows it with a moving dashed border, and you confirm with Enter. Always glance at the guessed range before you press Enter: if there is an empty cell or a heading in the way, Excel may pick the wrong block.
Worked example: June sales of the stationery shop
Here is the complete result of this lesson, with the exact formula behind every calculated cell. The numbers are the same as in the lab above (the shop and its figures are fictional). Prices are in the shop's currency, shown with two decimals.
| Product | Units sold (B) | Price (C) | Formula in column D | Revenue (D) |
|---|---|---|---|---|
| Notebook A5 | 340 | 12.50 | =B2*C2 | 4,250.00 |
| Gel pens (5-pack) | 520 | 6.90 | =B3*C3 | 3,588.00 |
| Planner 2027 | 180 | 24.00 | =B4*C4 | 4,320.00 |
| Sticky notes | 610 | 3.80 | =B5*C5 | 2,318.00 |
| Washi tape set | 260 | 9.50 | =B6*C6 | 2,470.00 |
| Fountain pen | 75 | 39.00 | =B7*C7 | 2,925.00 |
| Total | 1,985 =SUM(B2:B7) | =SUM(D2:D7) | 19,871.00 |
Look at the totals: the shop sold 1,985 units for a total revenue of 19,871.00. That also tells you the average price per unit sold, a useful number for any shop: =D8/B8 gives about 10.01. Note that this is not the same as the average of the six prices, because cheap products sold in much higher quantities.
Now the question from task 4: which product brought in the most revenue? Many beginners pick Sticky notes, because 610 units is by far the highest number in column B. But sticky notes cost only 3.80, so their revenue is just 2,318.00, the lowest of all six. The winner is the Planner 2027: only 180 units, but at 24.00 each they add up to 4,320.00, narrowly ahead of the Notebook A5 at 4,250.00.
The second chart makes the difference visible. For each product it compares its share of all units sold with its share of total revenue. Sticky notes are almost a third of everything that left the warehouse, but bring in only about an eighth of the money. The planner and the fountain pen do the opposite. In a real business this kind of view drives decisions about stock, shelf space and advertising budget, and it all starts with one multiplication per row.
=D2/$D$8, and the dollar signs keep the total fixed while you copy the formula down.Step by step: build it in Excel
- Open a blank workbook: File › New › Blank workbook (or Ctrl + N, Mac Cmd + N).
- Type the headings in row 1: Product in A1, Units sold in B1, Price in C1, Revenue in D1. Press Tab to move right after each one.
- Type the six products, their units and prices into A2:C7. Type numbers without currency symbols or thousands separators; formatting comes later.
- Click D2, type
=B2*C2and press Enter. Tip: instead of typing B2, you can type=, click B2, type*, click C2 and press Enter. - Click D2 again and double-click the fill handle (or select D2:D7 and press Ctrl + D, Mac Cmd + D) to copy the formula down to D7.
- Type Total in A8. Click B8 and press Alt + = (Mac: Cmd + Shift + T). Check that Excel suggests
=SUM(B2:B7), then press Enter. - Do the same in D8: AutoSum should suggest
=SUM(D2:D7). Do not sum column C. A total of prices means nothing. - Format the money columns: select C2:D8 and choose Home › Number › Currency or Number with 2 decimals (shortcut Ctrl + Shift + ! for number format with thousands separator).
- Make the header and total rows bold with Ctrl + B (Mac Cmd + B) and widen columns by double-clicking the border between the column letters.
- Check your work: press Ctrl + ` (the key left of 1) or use Formulas › Show Formulas to see every formula instead of its result. Press it again to switch back.
- Save with Ctrl + S (Mac Cmd + S) and give the file a clear name such as stationery-sales-2026-06.xlsx.

Common beginner mistakes and how to spot them
- Typing the result instead of a formula. If you type 4250 into D2, the sheet looks right today but never updates. Spot it: click the cell and look at the formula bar. A real formula starts with
=. Show Formulas (Ctrl + `) reveals all of them at once. - Forgetting the equals sign.
B2*C2without=is just text, and Excel shows the letters instead of a number. Spot it: the cell is left-aligned and shows the formula text. - Summing the wrong thing.
=SUM(B2:B7)*SUM(C2:C7)multiplies total units by the sum of all prices. That gives 1,985 × 95.70 = 189,964.50, almost ten times the real revenue. Revenue must be calculated per row and then added. Spot it: a total that is wildly larger than any single row times the number of rows. - AutoSum grabbing the wrong range. If there is a blank row in your data, AutoSum stops at the gap. Spot it: read the range in the formula, for example
=SUM(D5:D7)instead of=SUM(D2:D7). - Numbers stored as text. Values pasted from a website or PDF may be text that looks like a number. They are usually left-aligned and may show a small green triangle, and SUM ignores them. Spot it: the status bar Count is higher than the Sum seems to include.
- Confusing most units with most revenue. The most-sold item is not automatically the most valuable. Spot it: always compare the value column (D), not the volume column (B), when the question is about money.
Quick reference: what you used in this lesson
| Function or shortcut | What it does | Example from the lab |
|---|---|---|
= | Starts every formula | =B2*C2 |
+ - * / | Add, subtract, multiply, divide | =D8/B8 (average price per unit) |
SUM(range) | Adds all numbers in a range | =SUM(D2:D7) → 19,871.00 |
A1:B7 | A range: every cell from the first to the last address | B2:B7 = six units cells |
| Alt + = (Mac Cmd + Shift + T) | AutoSum: writes a SUM for the column above | B8 → =SUM(B2:B7) |
| Fill handle (double-click) | Copies a formula down to the end of the data | D2 → D3:D7 |
| Ctrl + D (Mac Cmd + D) | Fills the top cell of a selection down | Select D2:D7, press Ctrl + D |
| F2 | Edits the active cell in place | Fix a typo in D2 |
| Ctrl + ` | Shows formulas instead of results | Check that column D holds formulas |
| Ctrl + Z / Ctrl + Y | Undo / redo | Undo a wrong paste |
Does this work in Google Sheets and on a Mac?
Yes. Cell addresses, the equals sign, the four operators, relative references and SUM behave the same in every spreadsheet program. The differences are mostly keyboard shortcuts: on a Mac, Cmd replaces Ctrl for most commands, and AutoSum is Cmd + Shift + T. In Google Sheets, AutoSum lives under Insert › Function › SUM or the Σ button in the toolbar, and the fill handle works the same way. A workbook you build in the lab or in Excel opens in Sheets without any changes to these formulas, so what you learn here is not tied to one product.
Real-world uses of what you just learned
- Small online shop or market stall: monthly units × price per product, a total, and a quick look at which items carry the revenue. Exactly the sheet you built above.
- Invoices and quotes: quantity × unit price per line, then a SUM for the subtotal. Every invoice template you will ever see is built on these two formulas.
- Household budget: one row per expense, a monthly amount, and SUM for the total. Multiply a monthly cost by 12 with
=B2*12to see the yearly figure. - Event or club organisation: number of tickets × price per ticket type, plus a total of attendees and money collected.
- Stock count in a small warehouse: units on hand × cost per unit gives the value of the stock per item and in total.
What you will build in the rest of this course
This lesson is the foundation. The remaining 19 lessons use the same stationery shop and grow its workbook into a small, complete report, one new skill at a time.
Relative & Absolute References: Shares and a Discount. You calculate each product's share of total revenue, the numbers behind the second chart above, and a 15 % sale price for every product. You learn when a reference must stay fixed and how one dollar sign (and the F4 key) prevents the most common copy-down error in Excel.
SUM, AVERAGE, MIN & MAX: Six Months of Sales. You summarise the shop's first half-year: the total, the average month, the best and the weakest month and what a typical order is worth. Four functions that answer most of the questions a manager asks first.
IF: Let Excel Decide (Reorder & Bonus). You let Excel flag every product that has to be reordered and decide whether the team earned its monthly bonus. This is where a spreadsheet starts making decisions instead of only adding numbers.
SUMIF & COUNTIF: Totals by Category. You turn twelve single orders into a summary by category: revenue and number of orders for paper, pens and planners, without sorting or filtering anything by hand.
XLOOKUP: Fill In Product and Price Automatically. You build an order form that finds the product name and price from a product code. No more copying prices from one list into another, and no more outdated prices on an order.
Your First Charts: Column and Line. You present the half-year as a column chart of revenue and a line chart of orders, each with a clear title, and learn which chart type fits which question.
Mid-course project: Mini Dashboard with Profit, Margin & Conditional Formatting. You finish the half-year report with profit and margin per month, the best months highlighted in green and a sparkline of the revenue trend, a one-page summary you could hand to a business owner. Every cell is checked by the lab, and there is a certificate at the end.
Summary
Every cell has an address such as B2. A formula starts with = and points at cells instead of containing typed numbers, so it updates when the data changes. Write a formula once and copy it down with the fill handle; relative references move with it. Add a column with =SUM(D2:D7) or let AutoSum (Alt + =) write it for you. And when the question is about money, look at the money column: the stationery shop's best seller by units is its weakest product by revenue.
Now scroll up and do it yourself in the lab: four tasks, about fifteen minutes, and every cell is checked the moment you press Enter. If a formula is wrong, the hint tells you why.
Frequently asked questions
How do I write my first formula in Excel?
Click a cell, type an equals sign, then the calculation, for example =B2*C2, and press Enter. Point at cells instead of typing numbers so the result updates when the data changes.
What is the shortcut for AutoSum in Excel?
On Windows press Alt + = in the cell below a column of numbers, on a Mac press Cmd + Shift + T. Excel writes a SUM formula for the range above; check the range and press Enter.
How do I copy a formula down a whole column?
Select the cell with the formula and double-click the fill handle, the small square at its bottom-right corner. Excel copies it down as far as the neighbouring column has data and adjusts the row numbers in each copy.
What does the colon mean in =SUM(D2:D7)?
The colon defines a range: every cell from D2 to D7. =SUM(D2:D7) adds those six cells, which is shorter and safer than typing =D2+D3+D4+D5+D6+D7.
Why does my Excel formula show as text instead of a result?
Usually the equals sign is missing, or the cell was formatted as Text before you typed the formula. Add the = at the start, or change the format to General and re-enter the formula.
Is this beginner Excel lesson really free?
Yes. This first lesson and its interactive lab are free and run in your browser, no Excel installation needed. The lab checks every cell you fill in and explains mistakes.
Keep going: Excel for Beginners: Your First Real Spreadsheet
This free lab is lesson 1 of 20. Unlock the other 19 hands-on labs, the final exam and your certificate for a one-time $9.90.
- Relative & Absolute References: Shares and a Discount
- SUM, AVERAGE, MIN & MAX: Six Months of Sales
- IF: Let Excel Decide (Reorder & Bonus)
- SUMIF & COUNTIF: Totals by Category
- XLOOKUP: Fill In Product and Price Automatically
- Your First Charts: Column and Line
- Mid-course project: Mini Dashboard with Profit, Margin & Conditional Formatting
- Percent Change & Running Totals: July to December
- SUMIFS & COUNTIFS: A Category × Channel Table
- IF with AND & OR: Free Gifts and Priority Packing
- Dates in Excel: Days to Ship & Late Orders
- Text Formulas: Clean Product Names and Build SKU Codes
- Setting Prices: Markup, .90 Endings & Margin
- An Error-Proof Order Form: IFERROR & Data Validation
- Repeat Customers: COUNTIF per Row, Duplicates & Revenue Share
- Charts for Parts of a Whole: Pie and Stacked Columns
- Top Sellers: RANK, LARGE & a Bar Chart of All Products
- Planning 2027: Assumptions, ROUND & What-If
- Final Project: The Second Half-Year Dashboard