Introduction to Excel: The Interface, Cells and How to Organize Data | Free Excel Course: From Beginner to Advanced

What you'll learn

Find your way around Excel: workbooks, worksheets, cells and ranges.
Enter numbers, text and dates with the right data type so Excel can calculate with them.
Use the keyboard shortcuts (Windows and Mac) and the fill handle to work twice as fast.
Organize your data as a clean list that's ready for formulas, filters and PivotTables.

📥 Practice this lesson

Download the course practice file now: you'll use it in almost every lesson. Each sheet tells you which lesson it belongs to, and the yellow cells are where you type your formulas.

practice-excel.xlsx · 300 sample sales orders, a product catalog, student grades and messy data to clean

Excel shows up in job postings for administration, accounting, sales, operations and data analysis more than almost any other software skill. You don't need to know all of it: roughly 20% of its features handle 80% of real-world tasks, and this course goes straight to that 20%. In this first lesson you'll learn how a spreadsheet is organized, how to move around it quickly and how to enter data without creating problems you'll have to fix later.

1,048,576rows per worksheet, and 16,384 columns (A through XFD)

3kinds of cell content: numbers, text and formulas

10keyboard shortcuts cover most of your day-to-day work

Learn the screen
Know your data types
Move with shortcuts
Fill series
Organize data as a list

What Excel is and how people use it at work

Excel is a spreadsheet: a grid where you store data and run calculations that update automatically when you change a number. On the job it's used for four things:

Record data

Sales, inventory, timesheets, expenses, customer lists.

Example: a hardware store in Tucson logs every sale of the day on its own row.

Calculate

Totals, commissions, sales tax, profit margins, grades.

Example: the sales tax on every invoice, calculated automatically.

Analyze

Compare months, find your best-selling product, catch errors and duplicates.

Example: which of five Chicago-area stores sold the least in March.

Present

Charts and summaries for your manager, clients or investors.

Example: a one-page monthly sales recap for the leadership team.

The basics work the same in Excel 2016 through 2024 and Microsoft 365, on Windows and Mac. Modern functions you'll meet later (XLOOKUP, FILTER, UNIQUE, LET) need Excel 2021 or later, or Microsoft 365; for older versions we'll show you an alternative. Most of it also works in Google Sheets.

The parts of the Excel window

Learn the names of these areas; we'll use them throughout the course:

Element	What it is	What it's for
Ribbon	The tabs across the top: Home, Insert, Formulas, Data…	Every tool lives here, grouped by topic.
Name Box	The small box to the left of the formula bar	Shows the active cell (say, `B4`); type an address to jump there.
Formula bar	The long field next to fx	Shows the real content: the formula, even when the cell shows its result.
Columns	Letters: A, B, C… up to XFD	Each column usually holds one kind of data (date, product, price).
Rows	Numbers: 1, 2, 3… up to 1,048,576	Each row usually holds one record (one sale, one customer).
Sheet tabs	Tabs at the bottom: Sheet1, Sheet2…	Separate topics inside one file (January, February, Summary).
Status bar	The strip along the very bottom	Shows the sum, average and count of whatever you've selected, with no formula needed.

An Excel file is called a workbook. A workbook contains worksheets (or just sheets). Each sheet is a grid of cells, and each cell is named by its column and row: the cell in column C, row 5 is C5. A group of cells is a range, written with a colon: A1:A10 is the first ten cells of column A.

RibbonTabs with every tool, grouped by topic.
Name Box B4Tells you which cell you're in and lets you jump to another.
Formula barShows the real content: the formula, not just the result.
Cell gridColumns are letters, rows are numbers. The active cell is highlighted.
Sheet tabsEach sheet is a separate grid inside the same workbook.

If B4 shows 120 and the formula bar says =C4*D4, that 120 is a calculated result, not a typed number.

Data types: the mistake that ruins the most spreadsheets

Excel tells apart three kinds of content, and knowing which is which saves hours:

Numbers (including dates and times, which are numbers behind the scenes). They align to the right by default.
Text. It aligns to the left.
Formulas. They always start with an equal sign, =.

The classic mistake

Typing $1,500 USD or 1500 dollars by hand. Excel stores it as text and can no longer add it up. Type only the number (1500) and apply the Currency format afterward. Visual clue: if a number hugs the left edge of its cell, be suspicious.

Dates work the same way. U.S. Excel expects month first, so 3/15/2026 aligns to the right: it's a date. Type 15/03/2026 (the day-first format used abroad) and there's no month 15, so it stays on the left as text.

Here's how Excel sees what you type (alignment is your first clue):

You type	Excel stores it as	Alignment
`1500`	Number (can be added)	Right
`1500 dollars`	Text (can't be added)	Left
`3/15/2026`	Date: a number formatted as a date	Right
`=B2*C2`	Formula	Depends on the result

A small green triangle in a cell's corner warns of a "number stored as text." Click the yellow diamond and choose Convert to Number.

1. What's the right way to enter a price of $1,250 in a cell?

$1,250 USD, with the symbol and currency typed in
1250, then apply the Currency format
1250 dollars

Type the number and apply the format afterward. Extra words turn the entry into text that Excel can't calculate with.

Move fast: the shortcuts you'll actually use

You don't need to memorize a hundred shortcuts. These ten cover most daily work. On a Mac, most Ctrl shortcuts use Cmd instead:

Windows	Mac	What it does
`Ctrl` + `Arrow`	`Cmd` + `Arrow`	Jumps to the edge of the data block in that direction.
`Ctrl` + `Shift` + `Arrow`	`Cmd` + `Shift` + `Arrow`	Selects to the edge of the block. Perfect for selecting a column with thousands of rows.
`Ctrl` + `Home`	`Ctrl` + `Fn` + `←`	Goes back to cell A1.
`F2`	`Ctrl` + `U`	Edits the active cell without erasing it.
`Ctrl` + `Z` / `Ctrl` + `Y`	`Cmd` + `Z` / `Cmd` + `Y`	Undo / redo.
`Ctrl` + `C` / `V` / `X`	`Cmd` + `C` / `V` / `X`	Copy / paste / cut.
`Ctrl` + `;`	`Ctrl` + `;`	Enters today's date.
`Alt` + `Enter`	`Option` + `Return`	Starts a new line inside the same cell.
`Ctrl` + `Space` / `Shift` + `Space`	Same	Selects the entire column / the entire row.
`Ctrl` + `S`	`Cmd` + `S`	Save. Use it often if AutoSave is off.

The fill handle: your first automation

When you select a cell you'll see a small square in its bottom-right corner. That's the fill handle. Drag it down and Excel continues the series:

Type January and drag: you get February, March, April…
Type 1 and 2 in two cells, select both and drag: 3, 4, 5…
Type a date and drag: the following days.
If the cell contains a formula, Excel copies it and adjusts it to each row (you'll see exactly how in the lesson on references).

Pro tip: double-click the fill handle and Excel fills down as far as the neighboring column has data. With 5,000 rows, that saves a minute of dragging.

2. You type "January" in A1 and drag the fill handle down. What happens?

"January" is copied into every cell
You get an error
Excel fills in February, March, April…

The fill handle recognizes series like months, weekdays or numbered patterns and continues them.

How to organize data so everything else works

The formulas, filters and PivotTables in this course work smoothly when your data follows these five rules. When it doesn't, everything gets harder:

One header row, in row 1, with short, unique names: Date, Customer, Product, Quantity, Price.
One record per row. Never squeeze two sales into one row.
One data type per column. The Price column holds only numbers.
No blank rows or columns in the middle of your data.
No merged cells inside the data. Merging looks nice, but it breaks sorting, filtering and copying formulas.

The golden rule

Keep data and reports apart: one sheet stores the raw records as a list, another does the calculations and charts. New data then never breaks your summary.

3. Which of these habits makes it hardest to analyze a data list later?

Merging cells inside the data table
Putting the headers in row 1
Entering one record per row

Merged cells break sorting, filters and PivotTables. A clean list has headers in a single row and one record per row.

Worked example: from notebook to list at a hardware store in Tucson

Linda copied her hardware store's sales notebook into Excel exactly as it was: a merged title for each day, several products on one row and the daily total mixed in with the sales. It looked tidy, but it couldn't answer a simple question: how many pounds of nails did I sell this month?

Before: a copy of the notebook
MONDAY, MARCH 2 (merged cells)
Nails 2 lb + 1 hammer	$45	Jake
(blank row to separate days)
TOTAL MONDAY	$45

She rebuilt it with the five rules: one row per product, the date in its own column and the amount calculated with a formula.

Date	Product	Quantity	Unit price	Amount	Salesperson
3/2/2026	Nails (lb)	2	6.50	13.00	Jake
3/2/2026	Hammer	1	32.00	32.00	Jake
3/3/2026	Electrical tape	3	4.50	13.50	Linda

It matches the notebook: 2 × $6.50 + $32.00 = $45.00. Now the amount is =C2*D2, and filtering the Product column shows every sale of nails for the month. Daily totals will go on a separate sheet, using next lesson's formulas.

4. You select your 10 amounts. The status bar says Count: 10 and Sum: 1,250, but your receipts add up to $1,430. What's going on?

Excel adds incorrectly when there are decimals
One or more amounts (worth $180 in total) are stored as text
The status bar only adds the rows that fit on the screen

Count includes text; Sum includes only numbers. You're missing $1,430 − $1,250 = $180, typed as text (for example, "180 dollars").

Common beginner mistakes (and what to do instead)

Typing "45 dollars" or "$45 USD" in a cell.

Type 45 and apply the Currency format: it looks the same and you can calculate with it.

Leaving blank rows to separate days or months.

Put the date in its own column. To see one day, use a filter.

Putting subtotals inside the data list.

Keep the list "raw" and calculate totals on another sheet or with a PivotTable.

Merging cells to center a title.

Use Format Cells → Alignment → Center Across Selection: it looks the same and breaks nothing.

Saving and file formats

The standard format is .xlsx. Use .xlsm only for workbooks with macros, and .csv to exchange data with other systems (a CSV keeps only the values of one sheet: no formatting or formulas). With Microsoft 365 and OneDrive, AutoSave is on and you can restore earlier versions from File → Info → Version History.

Practice exercise

Create a new workbook and, on Sheet1, build a list of one week of expenses with these columns: Date, Description, Category, Amount. Enter at least 10 rows (groceries, gas, coffee, a streaming subscription…).

Use the fill handle for the dates.
Type the amounts without dollar signs or words.
Rename the sheet to Expenses (double-click the tab).
Select the whole Amount column with Ctrl + Shift + ↓ (Mac: Cmd + Shift + ↓) and look at the status bar at the bottom right: Excel already shows the sum, average and count without a single formula.

See solution

Every date and amount should be right-aligned. If the status bar shows "Count" but no "Sum," your amounts were stored as text; if the sum is lower than your receipts, at least one was. Find it (it's left-aligned) and retype it with digits only. Keep this file for the next lessons.

Summary

A workbook contains sheets; a sheet contains cells named by column and row (C5).
Type numbers without words or symbols and apply the format afterward. U.S. Excel reads dates month first.
Formulas always start with =.
Keep data as a list: headers in row 1, one record per row, no merged cells.
Totals don't go inside the list: calculate them separately so you can add data without breaking anything.

Next lesson: Basic Excel Formulas: SUM, AVERAGE, MAX, MIN and Percentages. You'll use your expense list to write your first formulas and calculate totals, percentages and sales tax.