Teach Yourself Excel Lesson 6 - Enter Data

Enter Data
From now on, we will build up a blank workbook step by step in order to make the finished Expense Tracker. Each lesson will follow-on from the previous one, and at each stage, you will be able to download the correct files at the beginning and the end.
So, Open Excel as per Teach Yourself Excel Lesson 3 - How To Open Excel and we can proceed.
You have a blank worksheet in front of you, and the first thing we need to do is to enter some data.
To enter data, simply select the cell to enter it into, and type the data.
When you have finished entering data into a particular cell, press the RIGHT ARROW on your keyboard.
Starting from cell A1 (the top left cell), and moving right, enter the following data:
| Date | Expense type | Necessary ? | Description | Amount | Year | Month |
These are the headings we will need in order to complete our Expense Tracker.
Your sheet should now look like this
Next Lesson: Teach Yourself Excel Lesson 7 - Change Column Width
Training Video on how to Enter Data in Excel:
| Attachment | Size |
|---|---|
| enter-data.xls | 17 KB |
- Nick's blog
- Add new comment
- 670 reads

Recent comments
1 day 1 hour ago
1 day 7 hours ago
1 day 12 hours ago
1 day 20 hours ago
1 day 20 hours ago
1 day 21 hours ago
1 day 21 hours ago
1 day 22 hours ago
4 days 6 hours ago
5 days 19 hours ago