LESSON 01 / 06
Excel confidence
Identify workbooks, worksheets, rows, columns, cells and ranges. Then enter clean data confidently.
Workbook
The complete Excel file, which can contain several worksheets.
Worksheet
One tab inside the workbook.
Cell
The box where a row and column meet, such as B4.
Range
A group of cells, such as A2:D12.
- Open a blank workbook and rename Sheet1 to Transactions.
- In row 1, enter Date, Reference, Description, Debit and Credit.
- Enter one transaction per row. Do not put two values in one cell.
- Keep one consistent date format and one type of information per column.
SHORTCUT
Press Tab to move right and Enter to move down.
Practice task
Build a Transactions table with five columns and capture five sample transactions.