| Excel users can utilize texts, formulas, and double | | | | also another area where Excel will automatically |
| click adjustments to create a template worksheet | | | | adjust formulas for you. If you insert rows |
| for any home, business, or church. We will outline | | | | anywhere between your formulas range (H2 |
| here how to set up a worksheet template in | | | | through H10 for example) then your formula in |
| Microsoft Excel. This basic template can then be | | | | the last cell will automatically change to include all |
| used for basic record keeping or modified for | | | | rows using the appropriate cell location. Also, it is |
| many other uses. | | | | important to note that when entering an expense |
| For this article we will use four words to manage | | | | to be sure to include the negative sign so it is |
| our spreadsheet: Description, Expense, Deposit, | | | | subtracted from the total rather than added. |
| and Balance. Enter the word ‘Description' at | | | | The next step is to create a formula to calculate |
| A1, ‘Expense' at F1, ‘Deposit' at H1, and | | | | your total balance of all columns. In the H13 |
| ‘Balance' at J1. Continue by entering formulas | | | | textbox enter the formula =sum(f11:h11), what |
| into the text boxes starting with ‘Expense' in | | | | this will do is total the negative expenses and the |
| F 11, and ‘Deposit' in H 11. For F 11 enter in | | | | positive deposits, creating a grand total amount. |
| the formula, =sum(f2:f10) and for H11 enter | | | | You will also want to create a beginning balance |
| =sum(h2:h10). Be sure to include the entire | | | | (start of the month balance) at J2. If you are |
| formula which starts with the equals sign ‘=' | | | | using this template for a new project, then your |
| and ends with the last parenthesis ‘)'. A nice | | | | beginning balance will be zero. |
| feature of Excel is its ability to adjust formulas | | | | A few last helpful ideas: |
| when copied and pasted into another cell. In other | | | | In order to date your expenses and deposits |
| words, if you were to enter the first formula | | | | simply add a column entitled ‘Date' and enter |
| above then copy that cell and paste it into H11, | | | | the dates as you enter transactions. You may |
| then Excel will automatically adjust the formula | | | | also get words in your description moving past |
| from F's to H's. What these formulas will do is | | | | the edge of the description text box. This is |
| take the numbers you will enter and automatically | | | | simply cured by double clicking on the line (in |
| add the value in all cells between H2 and H10 and | | | | between the letters) of the obstructing word. This |
| display the total in H11 as well as the same in the | | | | will automatically adjust the table to fit the text. |
| F column. If you need more space you can | | | | You should now have a fairly simple worksheet |
| substitute H11 for any number of slots. For | | | | template that is easy to manage and that is easily |
| instance H2:H100 will add up from H2-H100. This is | | | | modified for various record keeping needs. |