Meet your spreadsheet
Get comfortable with the tools you’ll use in every Excel workbook.
By the end, you’ll be able to:
- Tell a workbook from a worksheet
- Recognize the ribbon, formula bar and Name Box
- Choose a sensible structure for a small dataset
A workbook is your file. A worksheet is one sheet inside it.
Excel organizes information in a grid so you can store values, calculate results and explore patterns. A workbook is the file you save, commonly with an .xlsx extension. Each workbook can contain multiple worksheets, which you switch between using the sheet tabs.
Imagine a small shop. Its workbook might be named Shop-sales.xlsx. Inside it, a Sales worksheet stores individual orders, a Products worksheet stores prices and a Summary worksheet shows monthly totals. Start with a single sheet while you learn.
Five parts of the interface to recognize
- Ribbon
- The command area, organized into tabs such as Home, Insert and Data. Home contains common formatting tools.
- Name Box
- Usually sits to the left of the formula bar. It shows the active cell’s address, such as B3. You can also type an address there to jump to a cell.
- Formula bar
- Shows the contents or formula of the selected cell. A cell may display a calculated result while the formula bar shows the formula behind it.
- Worksheet grid
- The working area. Lettered columns and numbered rows meet at cells, each with its own address.
- Sheet tabs
- Switch between worksheets. Rename a sheet to describe what it contains, such as Sales or Budget.
Windows, Mac and Excel for the web arrange some controls differently. These core ideas apply across them. You do not need a paid Excel installation to complete the exercises on this site.
Worked example: a tiny sales list
Use one row for headings and one row per record. For example, the first row could contain Item, Units and Price. Each row beneath it describes one item. Keep units in the Units column and prices in the Price column.
This structure makes later sorting, filtering and calculations easier. Avoid inserting decorative blank rows inside the list, combining several values into one cell, or using color as the only way to record a category.
- Create a blank workbook.
- Rename the first worksheet Sales.
- Enter Item, Units and Price in cells A1, B1 and C1.
- Enter Notebook, 8 and 4 in the next row.
- Save the workbook as Shop-sales.xlsx.
Keep your work safe
Saving behavior depends on where you work. Desktop files saved locally need to be saved regularly. Excel for the web normally saves to your online storage automatically. Check the file name and save status before you close your work.
Use descriptive file names and worksheet names. A future colleague should be able to understand the file without asking you what Sheet7 means.
Give it a try.
Work through each exercise, check your answer and use a hint whenever you need one. Formula tasks check changed inputs, including boundary cases.
0 of 3 exercises complete
Take this with you
A workbook contains worksheets. Consistent rows, clear headings and descriptive names create a useful foundation.
Practice in Excel
Download the course workbook, follow the tasks, save your completed .xlsx and check its supported formula tasks here. Native Excel features use a separate review checklist.
Download practice workbook Check my workbook ↗Technical references and lesson review
Original lesson content. Technical behavior checked against Microsoft documentation. Technical review: 2026-10-16. Page updated: 2026-10-19. How SheetSprout develops and checks lessons.