Welcome to Excel — Your First Day at Work

What Excel really is (and why every job uses it)

Microsoft Excel is a spreadsheet — at its heart, a giant electronic table that can store numbers and text, do calculations for you, and turn rows of data into answers, charts, and reports. Think of it as a calculator, a notebook, and a filing cabinet rolled into one screen.

It matters because Excel is the quiet engine behind an enormous amount of real work. Whatever team you join at NorthPeak Retail, someone nearby is living in a spreadsheet:

• Finance builds the budget and tracks every dollar of Budget vs Actual spending each month.
• Sales records each order — who sold what, in which region — and totals up Revenue.
• HR keeps the employee list: names, departments, hire dates, and salaries.
• Operations watches the warehouse — how many Summit Tents are in stock and when to reorder.

You don't need to be a "numbers person" to be great at Excel. You need to understand the grid and learn to ask it clear questions. That starts right here.

The grid: columns, rows, and cells

When you open a worksheet, you see a grid of empty boxes. That grid is built from two simple ingredients:

• Columns run up and down (vertically) and are labelled with letters across the top: A, B, C, and so on. After Z they continue AA, AB … all the way to XFD (that's 16,384 columns).
• Rows run left and right (horizontally) and are labelled with numbers down the left side: 1, 2, 3 … up to row 1,048,576.

Wherever a column and a row cross, you get a single box called a cell. A cell is the smallest unit in Excel — the place where one piece of information lives. One cell might hold a salesperson's name, the next might hold a number like 240, and the one beside it might hold a formula that adds things up.

Here is NorthPeak's Q1 sales sheet. Notice the lettered column headers across the top and the numbered rows down the side — exactly the grid we just described:

Look at the box holding Priya Shah. It sits in column A, row 2. The box holding her revenue of 18,240 sits in column D, row 2. Each piece of data has its own home — and in the next section you'll learn how to name that home.

The cell address: how to name any box

Every cell has a unique name, called its cell address (or cell reference). The rule never changes: column letter first, then row number. No spaces, no comma.

So the cell where column A meets row 1 is called A1. The cell where column D meets row 2 is D2. Reading the NorthPeak grid above:

• A2 holds Priya Shah.
• B2 holds North.
• D2 holds Priya's revenue, 18,240.
• A1 holds the column heading Salesperson.

Why does this matter so much? Because an address is how you talk to Excel. Every formula you ever write will refer to cells by their address. When you eventually type something like =D2*1.1, you're saying "take whatever is in cell D2 and multiply it by 1.1." Excel doesn't care what the number is — it cares where it lives. Master the address and formulas suddenly make sense.

You can find any cell's address in the Name Box — the small white box at the far left, just above the column letters. Click a cell and its address appears there instantly. It's the fastest way to confirm exactly where you are.

The active cell: where you are right now

Out of all those millions of cells, exactly one is selected at any moment — the cell with the bold green-or-blue border around it. That's the active cell. It's simply "where you are standing" in the worksheet. Anything you type goes into the active cell, and the Name Box always shows its address.

In the diagram at the top of this lesson, the active cell is C3 — you can see its highlighted border, and notice that its column header (C) and row number (3) light up too, so you can spot your position even in a huge sheet. Click a different box and that one becomes active instead; only one cell can be active at a time.

Ranges: talking about many cells at once

A single address points to one cell. But real work usually involves a block of cells — for example, "all the revenue figures" or "everyone in the North region." A rectangular block of cells is called a range, and you name it with the top-left address, a colon, and the bottom-right address.

So A1:B5 means "start at cell A1, go down and across to cell B5, and include every cell in that rectangle." Read the colon as the word "through": A1 through B5.

The highlighted rectangle above is the range A1:B5 — two columns wide (A and B) and five rows tall (1 to 5), so it covers 10 cells in total. Ranges are how you tell Excel "do this to all of these at once." When you later write =SUM(D2:D5), the range D2:D5 is your way of saying "add up every revenue figure from row 2 through row 5."

A couple of handy variations you'll meet soon: A1:A100 is a tall, one-column range (a whole column of data), and A1:F1 is a wide, one-row range (a single header row). Same rule every time — top-left, colon, bottom-right.

Worksheet vs workbook: tabs inside a file

So far we've talked about one grid. But a single Excel file can hold many grids, and it helps to use the right word for each:

• A worksheet (also called a sheet or tab) is one grid of cells. You switch between sheets using the tabs along the bottom of the window.
• A workbook is the whole file — the container that holds all your worksheets together. When you save, you save the entire workbook as one .xlsx file.

Think of it like a paper notebook: the workbook is the notebook itself, and each worksheet is one page inside it. NorthPeak's NorthPeak_Q1_Sales.xlsx workbook might contain three tabs — a Sales sheet, a Products sheet, and a Summary sheet — all living inside the one file.

Saving your work as an .xlsx file

None of your work is safe until it's saved. The modern Excel file format is .xlsx — that's the three-letter extension at the end of the file name (as in NorthPeak_Q1_Sales.xlsx). It's the standard, reliable format you should use for almost everything.

To save, follow these steps:

1. Open the Save dialog. Press Ctrl + S, or go to File ▸ Save As. The very first time you save a new workbook, Excel asks where to put it.
2. Pick a location. Choose a folder you'll remember — your Documents folder, OneDrive, or a shared team drive.
3. Name the file clearly. Use something descriptive like NorthPeak_Q1_Sales so future-you knows what's inside without opening it.
4. Confirm the file type. Make sure "Save as type" reads Excel Workbook (*.xlsx), then click Save.
5. Save often after that. Once named, a quick Ctrl + S re-saves instantly with no questions asked. Do it every few minutes.