Topic for today IT class is Microsoft Excel. Microsoft Excel is so useful in doing an account. So, today we are going to learn how to create a simple account for our expenses for one year by using Microsoft Excel.
First of all, open the Microsoft excel in your computer. there are many small box in the page and the small is called cell. Each cell has it own name such as B1, G6, C7 and so on. Then, when you click on one cell, there is a bold box around the cell. If you want to continue numbering from the first cell until the 20th cell, for example, you just need to key in for 1 and 2 in the first and second cell then highlight the whole column by dragging your mouse at the corner of the cell to the last cell which you wish to numbering. Then the highlight cell will numbering automatically without typing it manually.
By open one Microsoft excel, you can create few sheet of paper. You can also name the each sheet of the file by right click on the word "sheet" below and click on rename. After you key in all the data for your account about your daily expenses, you can use the function of autosum by clicking on the cell which you wish to put the sum and click the icon of autosum and then highlight the cells that contain the data that you wish to sum up and click enter. Besides sum up each row, you can also sum up all by dragging your mouse to all column.
Besides, you can also insert comment to each cell by right-clicking the cell and click on insert comment then just type in your comment. Then, you can also insert formula to calculate the balance or total of your data that you want. By using the formula, you can do several type of calculation by creating your own formula.
To make your account more clear and easy to interpret, you can add in border to your account by clicking the icon 'border" on the top of the page. Then, to make your account more interesting, you can add in color to your account.
You can also insert graph in your account to see the trend of your expenses. First you highlight the subject that you wish to show in your graph then click on 'ctrl' panel on the keyboard and at the same time highlight the data of each subject. Then, click on the icon 'chart wizard'. Choose your preferred chart and click 'next'. It will show your chart and your click 'next' once again. You can key in your chart title, title for y-axis and x-axis then click 'next' again. Lastly, if you want your chart in the same sheet, just choose on the setting and click 'finish' to complete your chart. It will appear on your page of your account.
After your finish one month account and want to continue the next month you can create in the new sheet. If your don't want to recreate all the things, you can right click on the 'sheet 1' below left page and click on 'move or copy' then decide which sheet you want to move then tick on the box of 'create a copy' then click 'ok'. All the things will appear on the new sheet. You can change the date and all the data. If you want to move your balance from the previous month to the present month, you can click on the cell that you wish to key in and set in a new formula. For the formula, key in = , then click the previous month sheet, then click on the balance and click enter. Then, the balance will move from previous to present month.
Tuesday, April 7, 2009
Microsoft Excel......
Posted by Lee Fang Jo at 5:34 PM
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment