Introduction

Microsoft Excel is a spreadsheet application. Instead of writing paragraphs down a page like Word, you place values in a grid of cells. That grid makes it easy to calculate totals, compare lists, track budgets, grade scores, and organize inventories.

This lesson covers Excel essentials: workbooks and worksheets, rows and columns, typing into cells, simple formulas, and saving your file. Numbers feel intimidating only when you skip the grid rules. Learn the map first; calculations become friendly quickly. Strong keyboard skills from TYPE10X practice also help you move across cells without relying only on the mouse.

Once Excel feels comfortable, you will be ready for charts and tables later in this track.

Learning Objectives

By the end of this lesson, you will be able to:

Describe workbooks, worksheets, rows, columns, and cells
Enter labels and numbers accurately into cells
Reference cells in simple formulas that start with =
Use AutoFill for patterns and copy formulas down a column
Save and reopen an .xlsx workbook with clear sheet names

Main Lesson

What Excel is for

Excel shines when your work involves lists, numbers, dates, or anything you might recalculate. Teachers track scores. Clubs track dues. Small businesses track sales. Scientists record measurements. Students plan project budgets.

If the task is a letter or essay, use Word. If the task is a slide talk, use PowerPoint. If the task asks “what is the total, average, or difference?”, Excel is usually the right tool.

Workbooks, worksheets, and cells

An Excel file is called a workbook. Inside a workbook you can have multiple worksheets (tabs), each a separate grid. Each grid has:

Columns labeled with letters (A, B, C…)
Rows labeled with numbers (1, 2, 3…)
Cells at the intersection, named by column letter + row number (A1, B2, C10)

Click a cell to make it active. The name box (usually near the top left) shows the active cell’s address. Type into the cell or into the formula bar above the sheet.

Term	Meaning	Example
Workbook	The whole Excel file	`club-budget.xlsx`
Worksheet	One tab/grid inside the file	Sheet1, Sales, Grades
Cell	One box for data	B5
Range	A group of cells	A1:A10
Formula	Calculation starting with =	`=B2+B3`

Entering and editing data

Click a cell
Type text or a number
Press Enter to move down, or Tab to move right
To edit, double-click the cell or press F2, change the value, then Enter

Text is left-aligned by default; numbers are right-aligned. That visual cue helps you spot mistaken text-as-number problems (for example, typing a space before a value).

Put labels (headers) in row 1: Item, Quantity, Price, Total. Put related records in the rows below. Keep one fact per cell—do not combine “Apples 12” in one cell if you need quantity and name separately.

Selecting cells and ranges

Click and drag to select a rectangle of cells. Click a row number or column letter to select the whole row or column. Hold Ctrl (Windows) or Cmd (Mac) to select non-adjacent cells. Selected ranges matter because formulas and charts operate on ranges.

Simple formulas

Every Excel formula starts with an equals sign =.

Examples:

=5+3 returns 8
=A1+A2 adds the values in A1 and A2
=B2*C2 multiplies quantity by price
=SUM(B2:B10) adds all numbers from B2 through B10

If you change an input cell, formulas that refer to it recalculate automatically. That is the magic of spreadsheets: update once, outputs refresh.

Order of operations follows math rules. Use parentheses when needed: =(A1+A2)/2 averages two cells correctly.

AutoFill and copying formulas

If you type January in A1 and drag the fill handle (small square at the cell’s corner) downward, Excel may continue months. For formulas, enter =B2C2 in D2, then drag down: Excel usually adjusts to =B3C3, =B4*C4, and so on. Relative references save hours of retyping.

Basic formatting for clarity

Use the Home tab to:

Bold header labels
Adjust column width by dragging the boundary between column letters
Apply number formats (Currency, Percent, Date) when appropriate
Add light borders or Align Center for headers

Formatting should make data easier to read—not decorate randomly. Later lessons expand formatting ideas from Document Formatting into Office-wide habits of clarity.

Multiple sheets and saving

Rename a sheet by double-clicking its tab (Budget, Members, Notes). Add sheets with the + button. Save the workbook with File → Save As as an .xlsx file. Use names like science-data-2026-07.xlsx. Press Ctrl+S / Cmd+S often.

A starter spreadsheet workflow

In A1:D1 type headers: Item, Qty, Price, Line Total
Enter three items in rows 2–4
In D2 enter =B2*C2 and AutoFill down
In B6 enter Total Qty and in B7 =SUM(B2:B4)
Save as excel-basics-practice.xlsx

Key Definitions

Spreadsheet — A grid-based tool for organizing and calculating data.
Workbook — An Excel file that can contain one or more worksheets.
Worksheet — A single grid tab inside a workbook.
Cell reference — The address of a cell, such as C4.
Range — A block of cells, written like A1:A10.
Formula — An expression beginning with = that calculates a result.
Function — A named calculation such as SUM or AVERAGE.
AutoFill — Dragging a cell’s handle to continue a pattern or copy formulas.
Relative reference — A cell address that adjusts when a formula is copied.
Number format — How a value is displayed (currency, percent, date) without changing the underlying number.

Examples

Example 1: Class supply list

Columns for Supply, Needed, Have, Still Required. Still Required uses =B2-C2 for each row so shortages update when inventory changes.

Example 2: Allowance tracker

Date, Description, Amount In, Amount Out, Balance. Balance formulas keep a running total for personal finance practice.

Example 3: Sports stats

Player names in column A, points in column B, =AVERAGE(B2:B12) under the list for team average.

Example 4: Linking skills

You type long labels faster after typing practice, then use Excel for the numeric analysis Word cannot do well.

Real-World Scenarios

Scenario A — Bake sale

The PTA lists muffins, cookies, and drinks with prices and counts sold. Excel line totals and a grand SUM replace handwritten calculator errors.

Scenario B — Science lab

Partners record trial measurements in columns. When one wrong number is fixed, dependent formulas and later charts update.

Scenario C — First internship

A café asks a student to update weekly inventory. Knowing cell addresses and SUM makes training smoother than hunting through Word tables alone.

Tips

Tip: Always start formulas with =. Without it, Excel treats your entry as plain text.

Tip: Put headers in row 1 and keep consistent data types down each column.

Tip: Widen columns until labels are fully visible before sharing a sheet.

Warnings

Warning: Deleting a row that formulas depend on can cause #REF! errors. Undo immediately if you see them.

Warning: Looking at a cell that “shows” a rounded currency amount can hide more decimal places underneath—use number formats carefully for money.

Did You Know

Did you know: Excel has millions of rows available in modern workbooks, but beginners should keep sheets tidy and only as large as needed.

Did you know: If a formula cell shows the text of the formula instead of a result, check whether the cell was formatted as Text or whether you omitted =.

Common Mistakes

Forgetting = so “calculations” stay as labels
Mixing units in one column (prices and notes together)
Leaving Sheet1, Sheet2, Sheet3 unnamed forever
Saving over the only copy of data without a backup
Typing spaces before numbers, which can break math

Interactive Exercise

Three-Item Budget (15 minutes)

Build a sheet for a small event:

Headers: Category, Planned, Actual, Difference
Three categories (Food, Supplies, Transport)
Difference formula =B2-C2 filled down
SUM of Planned and Actual at the bottom
Save as event-budget-practice.xlsx and rename the sheet to Budget

Practice Questions

What is the difference between a workbook and a worksheet?
How do you write a formula that adds cells A1 and A2?
Why are header rows useful?
What does AutoFill help you do with formulas?
When should you choose Excel instead of Word?

Mini Challenge

Create a five-row grade list with columns Student, Score1, Score2, Average. Use a formula for Average. Bold the headers. Save and screenshot or print preview the sheet for your teacher.

Summary

Excel organizes data in workbook files made of worksheet grids. Cells have addresses like B2; formulas begin with = and recalculate when inputs change. Clear headers, careful data entry, AutoFill, and regular saves turn Excel from a mysterious grid into a reliable calculator and organizer. Next you will learn presentation slides in PowerPoint, then return to Office-wide skills like charts and tables.

Student Checklist

[ ] I can explain workbook, worksheet, cell, and range
[ ] I can enter labels and numbers cleanly
[ ] I can write basic = formulas and use SUM
[ ] I can AutoFill formulas and rename sheets
[ ] I saved an .xlsx practice file
[ ] I completed the exercise and practice questions

Teacher Notes

Project a live formula: change an input and watch the result update.
Insist on headers before numbers—structure first.
Provide a starter CSV or typed list for students who type slowly; still require formulas they write themselves.
Cross-link to charts after students have one clean numeric range.

FAQ

Q: Is Excel the same as Google Sheets?

They share spreadsheet concepts (cells, formulas, sheets). Menus differ, but learning Excel basics transfers well to Sheets and vice versa.

Q: What does #### mean in a cell?

Usually the column is too narrow to display the number. Widen the column.

Q: What is the difference between .xlsx and .csv?

.xlsx is Excel’s full workbook format. .csv is plain text with commas—good for sharing simple tables, but it may lose formulas and formatting.

Q: What should I learn next?

Continue to PowerPoint Basics, then return for charts and tables when you are ready to visualize data.

Q: Can Excel replace a calculator?

For repeated or linked calculations, yes—Excel is usually better because results update and remain documented.

Related Lessons

Next Lesson CTA

You can navigate cells, enter data, and write simple formulas. Next, learn to present ideas on slides: continue to PowerPoint Basics and build a clear, short presentation.

Excel Basics