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
- 3059 reads

Recent comments
1 hour 40 min ago
1 day 5 hours ago
1 day 22 hours ago
2 days 20 hours ago
2 days 20 hours ago
2 days 22 hours ago
3 days 5 hours ago
3 days 14 hours ago
3 days 15 hours ago
3 days 20 hours ago