Tabellab

You are not signed in — the lab works, but your progress is not saved. Sign up

Lesson 1 of 20 is free. Unlock all 20 hands-on labs, the final exam and your certificate.

Buy course — $9.90
Read first

In Excel

  • Click a cell and start typing. Enter confirms and moves down, Tab moves right.
  • Copy a formula down by dragging the small square at the bottom right of the cell (the fill handle) or by double-clicking it.
  • AutoSum: select the cell below a column of numbers and press Alt + = (Mac: Cmd + Shift + T), then Enter.
Loading the spreadsheet…

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.

Write once, copy down: Excel shifts the row numbersB UnitsC PriceD Revenue234012.50=B2*C235206.90=B3*C3418024.00=B4*C456103.80=B5*C562609.50=B6*C677539.00=B7*C7Fill handle:drag or double-clickthe corner of D2Row 2 → 3 → 4 …references follow
One formula in D2, copied down with the fill handle. Excel adjusts the row number in every copy, so each product multiplies its own units by its own price.

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.

June sales with the formulas behind the results
ProductUnits sold (B)Price (C)Formula in column DRevenue (D)
Notebook A534012.50=B2*C24,250.00
Gel pens (5-pack)5206.90=B3*C33,588.00
Planner 202718024.00=B4*C44,320.00
Sticky notes6103.80=B5*C52,318.00
Washi tape set2609.50=B6*C62,470.00
Fountain pen7539.00=B7*C72,925.00
Total1,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.

June revenue per product (units × price)01,0002,0003,0004,0005,0004,250NotebookA53,588Gel pens(5-pack)4,320Planner20272,318Stickynotes2,470Washitape set2,925Fountainpen
Revenue per product in June. The Planner 2027 (highlighted) earns the most money although it sold the second-fewest units.

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.

Share of units vs share of revenue0 %10 %20 %30 %17.121.4Notebook26.218.1Gel pens9.121.7Planner30.711.7Sticky notes13.112.4Washi tape3.814.7Fountain penShare of units soldShare of revenue
Share of units vs share of revenue, in percent. Units are B2/B8, revenue is D2/D8 for each product. Volume and value tell different stories.

You will calculate shares like these yourself in lesson 2. The formula is =D2/$D$8, and the dollar signs keep the total fixed while you copy the formula down.

Step by step: build it in Excel

  1. Open a blank workbook: File › New › Blank workbook (or Ctrl + N, Mac Cmd + N).
  2. 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.
  3. Type the six products, their units and prices into A2:C7. Type numbers without currency symbols or thousands separators; formatting comes later.
  4. Click D2, type =B2*C2 and press Enter. Tip: instead of typing B2, you can type =, click B2, type *, click C2 and press Enter.
  5. 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.
  6. Type Total in A8. Click B8 and press Alt + = (Mac: Cmd + Shift + T). Check that Excel suggests =SUM(B2:B7), then press Enter.
  7. Do the same in D8: AutoSum should suggest =SUM(D2:D7). Do not sum column C. A total of prices means nothing.
  8. 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).
  9. 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.
  10. 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.
  11. Save with Ctrl + S (Mac Cmd + S) and give the file a clear name such as stationery-sales-2026-06.xlsx.
Select D2:D7 with the mouse and look at the status bar at the bottom of the Excel window. It shows the Sum, Average and Count of the selection without any formula. It is the fastest way to double-check a total.

Excel for Beginners course illustration: a first spreadsheet with sales data, formulas and totals
Excel for Beginners: you build one small shop workbook step by step, from the first formula to a mini dashboard.

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*C2 without = 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 shortcutWhat it doesExample 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:B7A range: every cell from the first to the last addressB2:B7 = six units cells
Alt + = (Mac Cmd + Shift + T)AutoSum: writes a SUM for the column aboveB8 → =SUM(B2:B7)
Fill handle (double-click)Copies a formula down to the end of the dataD2 → D3:D7
Ctrl + D (Mac Cmd + D)Fills the top cell of a selection downSelect D2:D7, press Ctrl + D
F2Edits the active cell in placeFix a typo in D2
Ctrl + ` Shows formulas instead of resultsCheck that column D holds formulas
Ctrl + Z / Ctrl + YUndo / redoUndo 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*12 to 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.

  1. Relative & Absolute References: Shares and a Discount
  2. SUM, AVERAGE, MIN & MAX: Six Months of Sales
  3. IF: Let Excel Decide (Reorder & Bonus)
  4. SUMIF & COUNTIF: Totals by Category
  5. XLOOKUP: Fill In Product and Price Automatically
  6. Your First Charts: Column and Line
  7. Mid-course project: Mini Dashboard with Profit, Margin & Conditional Formatting
  8. Percent Change & Running Totals: July to December
  9. SUMIFS & COUNTIFS: A Category × Channel Table
  10. IF with AND & OR: Free Gifts and Priority Packing
  11. Dates in Excel: Days to Ship & Late Orders
  12. Text Formulas: Clean Product Names and Build SKU Codes
  13. Setting Prices: Markup, .90 Endings & Margin
  14. An Error-Proof Order Form: IFERROR & Data Validation
  15. Repeat Customers: COUNTIF per Row, Duplicates & Revenue Share
  16. Charts for Parts of a Whole: Pie and Stacked Columns
  17. Top Sellers: RANK, LARGE & a Bar Chart of All Products
  18. Planning 2027: Assumptions, ROUND & What-If
  19. Final Project: The Second Half-Year Dashboard

Buy course — $9.90 See the full course