Excel can be convenient for all sorts of things. It is so simple to utilize, when you know the fundamentals.
Making a table or spread sheet to manage your monthly finances.
Excel is mainly used for tables as it already has outlined cells. You can begin the process by opening Excel and this will make a new workbook. To form a table you're going to need to add your content to the workbook. Tables can be employed for many handy things like having a look at the expenses of house hold things.
To record this you will want to outline all the finances at the top row of the page, click on each individual cell to enter a different element.
If your writing doesn't fit in the cell you can expand these by moving your cursor to the letter to change the width, or number to modify the height. When your cursor is there, a cross symbol should appear with arrows on two sides you may then drag this to modify the cell width and height. In this table I might put in the top cells a1, date, b1, lease, c1, electrical, d1, gas, e1, food. These are all my expenses. Under the date title in cell a2 I would write the first time period I'm going to record my expenses for. In this table I might write, January-February, for the other columns I might write the amount it cost between that time period.
Once I have entered all this I now have a table which shows my costs and how much they cost a month, now I will need to total the columns, I should enter another title into f1, total, this will be the total of all the costs over the period, January- February, after time there would be more dates, February-March, then these can all be totalled to find out the cost of expenses for the year.
When printing excel won't show the outline of the cells if you would like your table to be made public you are going to need to create a border. To try this you need to go on to the home tab at the top part of the screen. Under the font section there's a little symbol of a square. Highlight your table then click the drop down menu next to the symbol and select, all borders,
If your version of excel is before 2010 you'll need to add borders another way. You should highlight your table and right click in the highlighted section. Go on to format and select borders in the top tab, you then can select, all borders, from here.
Making a table or spread sheet to manage your monthly finances.
Excel is mainly used for tables as it already has outlined cells. You can begin the process by opening Excel and this will make a new workbook. To form a table you're going to need to add your content to the workbook. Tables can be employed for many handy things like having a look at the expenses of house hold things.
To record this you will want to outline all the finances at the top row of the page, click on each individual cell to enter a different element.
If your writing doesn't fit in the cell you can expand these by moving your cursor to the letter to change the width, or number to modify the height. When your cursor is there, a cross symbol should appear with arrows on two sides you may then drag this to modify the cell width and height. In this table I might put in the top cells a1, date, b1, lease, c1, electrical, d1, gas, e1, food. These are all my expenses. Under the date title in cell a2 I would write the first time period I'm going to record my expenses for. In this table I might write, January-February, for the other columns I might write the amount it cost between that time period.
Once I have entered all this I now have a table which shows my costs and how much they cost a month, now I will need to total the columns, I should enter another title into f1, total, this will be the total of all the costs over the period, January- February, after time there would be more dates, February-March, then these can all be totalled to find out the cost of expenses for the year.
When printing excel won't show the outline of the cells if you would like your table to be made public you are going to need to create a border. To try this you need to go on to the home tab at the top part of the screen. Under the font section there's a little symbol of a square. Highlight your table then click the drop down menu next to the symbol and select, all borders,
If your version of excel is before 2010 you'll need to add borders another way. You should highlight your table and right click in the highlighted section. Go on to format and select borders in the top tab, you then can select, all borders, from here.
About the Author:
Lois Park has recently joined the team at Prosyn and is assisting with internal small business IT Support setups. This Spread sheet set-up was one of her first projects. At Prosyn we concentrate on our internal systems as much as we do when providing Business IT Support to our clients.
No comments:
Post a Comment