Getting started

The Excel window, cells and ranges, entering and editing data, and formatting cells and numbers.

About 2 hours of study

Learning objectives

Lessons

  1. 1

    The Excel window, workbooks and navigation

    What a workbook, worksheet, cell and range are, how to read cell addresses, and how to move around a sheet quickly with the mouse, the Name Box and the keyboard.

  2. 2

    Entering and editing data

    How Excel decides whether you typed a number, text, a date or a formula, how to edit cells safely, and how AutoFill and Flash Fill save typing.

  3. 3

    Formatting cells and number formats

    How formatting changes what a cell looks like without changing its value: fonts, borders and alignment, number formats for money, percentages and dates, and custom formats.

Module practice

Module quiz

1. What is the address of the cell in column C, row 12?
2. How are numbers aligned by default?
3. Which shortcut opens Format Cells on Windows?
4. What does Ctrl+Down Arrow do in a column of data?
5. A cell holds 0.125 formatted as a percentage with no decimals. What is used in formulas?
6. Why do Flash Fill results not change when the source column changes?

Formulas and functions ›