Your First Spreadsheet: Tracking a Weekly Budget
Where did my money go?
Every week, money leaves your wallet in tiny invisible bites: a coffee here, a bus ticket there, groceries on Saturday. By Sunday it's gone and you can't remember where. A spreadsheet fixes this in about five minutes. Excel is just a giant grid of boxes — you type what you spent in one box, how much in the next, and suddenly your week is on paper.
The reason Excel has stayed dominant for 40 years isn't formulas or charts; it's that the grid itself matches how humans naturally list things. In this lesson you'll build a real weekly budget tracker — not a toy example — and by the end you'll know how to enter data, move around, and save your work so it's there tomorrow.
Analogy: A spreadsheet is like a piece of graph paper that does math for you. Each little square is a box you can write in. Rows go across like sentences; columns go down like lists. You're not learning software — you're learning to write tidy lists that happen to live on a screen.
- Excel is a grid of cells — each cell holds one piece of information (text or a number)
- Columns are labeled with letters (A, B, C…) and rows with numbers (1, 2, 3…)
- Every cell has an address like A1 or B3 — that's how Excel knows where you are
- The formula bar at the top shows what's actually inside the selected cell
- Saving (Ctrl+S / Cmd+S) turns your work into a .xlsx file you can reopen anytime
Watch a budget appear
Before you touch anything, watch what entering a single row of a budget looks like. Pay attention to two things: where the words go, and what the formula bar shows at the top.
| A | B | C | |
|---|---|---|---|
| 1 | |||
| 2 | |||
| 3 |
Spot the pattern
Here's a second example with different data. Look at how it's organized and answer the question below.
| A | B | C | |
|---|---|---|---|
| 1 | Date | Store | Cost |
| 2 | 01/15 | Trader Joe's | 32.10 |
| 3 | 01/16 | Shell Gas | 45.00 |
| 4 | 01/17 | Chipotle | 12.75 |
What's the consistent pattern across both budget examples?
Type your first row
Click cell A1 below and create a header row. Type Day in A1, Item in B1, Amount in C1. Use Tab to move right between cells.
| A | B | C | |
|---|---|---|---|
| 1 | |||
| 2 | |||
| 3 |
Build a 3-day mini budget
Below your header row, add three real expenses from the last week. Each row needs a day (e.g., Monday), an item (e.g., Lunch), and an amount as a number (e.g., 8.50). Then save the file as WeeklyBudget.
| A | B | C | |
|---|---|---|---|
| 1 | Day | Item | Amount |
| 2 | |||
| 3 | |||
| 4 |
Why won't this add up?
Sam built a budget but the totals look wrong. In cell C2, instead of typing 4.50, Sam typed $4.50 (coffee) so it would "be clearer." In cell C3, Sam typed 12 dollars. Excel is now refusing to treat column C as numbers and any future SUM will fail.
| A | B | C | |
|---|---|---|---|
| 1 | Day | Item | Amount |
| 2 | Mon | Coffee | $4.50 (coffee) |
| 3 | Tue | Bus | 12 dollars |
| 4 | =SUM(C2:C3) | #VALUE! |
What did Sam do wrong?
Teach it back
Imagine your friend has never opened Excel. In 3-5 sentences, explain what a cell is, how rows and columns are different, and what the formula bar shows. Use your own words — no jargon you don't understand.
Keywords detected: 0/6
Boss: Build, save, and reopen
Build a complete one-week budget tracker. Make a smart decision at each step. Get all four right to ship it.
Sheet complete.
You just built, saved, and recovered a real spreadsheet. Every Excel skill from here — formulas, charts, pivot tables — is just adding power on top of this exact grid you just used.
Final score: 0 / 500 XP
Best streak: 🔥 0
📅 Spaced review schedule
Overview
This beginner Excel lesson walks you through building your first spreadsheet — a simple weekly budget tracker — without any jargon. You'll learn what cells, rows, columns, and the formula bar actually are by using them, then practice typing data, navigating with the keyboard, and saving your file. By the end you'll have a real, working budget spreadsheet you can keep using.
What you'll learn
- Identify cells, rows, columns, and the formula bar in the Excel window
- Type text and numbers into cells and move around with arrow keys and Enter
- Save a workbook with a meaningful name and reopen it later
Key concepts
Cells, rows, and columns
An Excel worksheet is a grid made up of cells. Columns run vertically and are labeled with letters (A, B, C, ... Z, AA, AB ...), while rows run horizontally and are labeled with numbers (1, 2, 3 ...). Every cell sits at the intersection of one column and one row, giving it a unique address like A1, B7, or AC42.
When you click a cell, it becomes the 'active cell' — outlined in green — and its address appears in the Name Box at the top-left of the window. This address system is how Excel keeps track of where everything lives, and it's the basis for every formula you'll ever write.
The formula bar
The formula bar sits just above the column letters. It shows the actual contents of whichever cell is currently selected. This matters because what you see in a cell isn't always what's in it — for example, a cell might display '$4.50' but the formula bar reveals it's really the number 4.5 with currency formatting applied.
Later, when cells contain formulas like =B2+C2, the cell shows the result (the number) but the formula bar shows the formula itself. Getting in the habit of glancing at the formula bar early will save you confusion later.
Entering data and navigating
To enter data, click a cell and start typing. Press Enter to confirm and move down to the next row. Press Tab to confirm and move right to the next column. The arrow keys also move the active cell one step in any direction.
A helpful pattern when entering a row of data: use Tab to move across the columns, and on the last column press Enter — Excel will jump down and back to the column where you started typing. This makes entering tabular data much faster than reaching for the mouse.
Saving a workbook
An Excel file is called a workbook and is saved with the .xlsx extension. To save, press Ctrl+S (Windows) or Cmd+S (Mac), then choose a folder and a descriptive filename like WeeklyBudget_2024. The first save asks where to put the file; every subsequent Ctrl+S silently overwrites it.
Good filename habits matter more than they seem. Avoid names like Untitled1 or Book2 — in six months, you won't know which file held what. Include a topic and a date or version: WeeklyBudget_2024, GroceryList_Jan, Q1_Expenses_v2.
Common mistakes
Mixing words into number cells (e.g., typing '$4.50 (coffee)')
Beginners often want a single cell to be self-explanatory and add notes alongside the number. But Excel treats any cell containing letters as text, which means it can't be summed.
Keep amounts as pure numbers and put descriptions in a separate column. Type 4.50 in the Amount column and coffee in the Item column.
Putting multiple pieces of information in one cell
It feels tidy to write 'Monday - Coffee - $4.50' in one cell, like a sentence. But this destroys the grid's power — you can't sort by day, filter by item, or sum amounts.
One fact per cell. Day in column A, Item in column B, Amount in column C. The grid does the organizing for you.
Forgetting to save before closing
New users assume Excel auto-saves like Google Sheets. By default, the desktop version doesn't (unless you've set up OneDrive AutoSave).
Press Ctrl+S (or Cmd+S on Mac) every few minutes. Make it a reflex like signaling before turning.
Frequently asked questions
A cell is a single box in the Excel grid where you can type one piece of information — either text or a number. Every cell has an address made of its column letter and row number, such as A1 or C7.
Columns run vertically (top to bottom) and are labeled with letters like A, B, C. Rows run horizontally (left to right) and are labeled with numbers like 1, 2, 3. In a well-organized spreadsheet, each row represents one record (like one expense) and each column represents one type of information about it (like the date or the amount).
The formula bar, located above the column letters, shows the true contents of the currently selected cell. This is useful when the cell displays formatted text (like '$4.50') but actually contains a plain number, or when a cell shows a calculated result while really holding a formula.
Press Ctrl+S on Windows or Cmd+S on Mac. The first time, Excel will ask where to save and what to name the file — choose a meaningful name like 'WeeklyBudget_2024'. After that, Ctrl+S silently saves changes to the same file.
Press Tab to move one cell to the right, Enter to move one cell down, or use the arrow keys to move in any direction. For entering rows of data, the typical flow is Tab across the columns and Enter to drop to the next row.
If you type any letters or symbols (other than allowed currency or decimal characters) along with a number — like '12 dollars' or '$4.50 (coffee)' — Excel will store the entire entry as text. Text values can't be summed in formulas. To fix it, retype the cell with just the number.
Related topics
- Writing your first formula with =SUM
- Formatting cells as currency
- Selecting and copying ranges of cells
- Using AutoFill to extend a series
- Naming and organizing worksheets within a workbook
About this tutorial
This lesson is part of the Become an Excel expert tutorial,
in the Excel for beginners module.
Last updated May 6, 2026