Latest posts by techwriter (see all)
- English Grammar – How to Use LIE and LAY Correctly - October 26, 2016
- How to Count the Number of Days with an Incident and Chart with Running Averages in MS Excel - October 19, 2016
- FREE Online Video Course – MS Word Power Shortcuts - October 14, 2016
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.