Latest posts by techwriter (see all)
- 101 Tips and Tutorials to Write Like a Pro - August 17, 2017
- How to Find a Technical Writing Job – Some Ideas and Resources - August 9, 2017
- BOOK REVIEW: “Design for How People Learn” by Julie Dirksen - July 10, 2017
By Luis T.
In using Microsoft Excel 2007, you will usually start create a worksheet right from the scratch, this is one of the most fundamental capability in using Microsoft Excel.
By now, you know that every time when you open Microsoft Excel, you will be given a blank workbook with 3 blank worksheet within, this is the platform for you to start using Microsoft Excel.
The fundamental function of a worksheet is to add data, you could enter number, text or formula into the cell to form the content. In this session, you are required to enter the daily expenses of an individual, which categorized into Date, Food, Transportation, Rental and Entertainment.
On Cell A1, key in text “Date” and press Enter, now you have the first information in the worksheet. On Cell B1, key in text “Food” and press Enter. Repeat the same process for Transportation, Rental and Entertainment.
Now, you have all the required information or topic on the table, next is to input the data/content into the table. Under cell A2, input text “1 Jan” to indicate the first of January of the year. Then on the cell A2, input 2 to indicate 2 dollars spent on Food. Below Transportation, input 5 to indicate $5, repeat the same process to Rental (10) and Entertainment (20).
Now you have the first basic data on the table, unknowingly you are actually forming the daily expense report, and the data will grow bigger by days.
This is the most basic functions of the Microsoft Excel, in fact, the function of recording data comes before the Formula and Analysis functions.
Apply the same method across other table, there is no right or wrong to this. You may make your table horizontally, but it is always advisable you input your data vertically.
Luis T is the owner of http://www.excelexpertuser.com. Find out more on how you could be a master of Microsoft Excel on the website.