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
- Login or register to post comments
- 16772 reads
Entering data
Lesson 6 - Enter Data. How do you get the words like "Expense type" and "Necessary ?" under one another in the same cell?
15. Excel Tips - Wrap Text
15. Excel Tips - Wrap Text for headings