Getting started
The Excel window, cells and ranges, entering and editing data, and formatting cells and numbers.
About 2 hours of study
Learning objectives
- Navigate workbooks with the keyboard
- Enter data and fill series
- Format cells and numbers
Lessons
- 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
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
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.