Mick Stafford taught us a lot about Excel formulas and worksheets. Attached is information on Working With Basic Functions and Creating Complex Formulas. Class members worked on a sample worksheet for Yearly Expenses. We learned about date functions, currency functions, and formulas for totaling columns and rows. Then came the lesson on how to link one worksheet to another worksheet so that your totals roll forward....in this worksheet we have January, February and March. Proper formulas will allow Year-to-Date totals for January to roll forward to the February worksheet and those new totals to again roll forward to the March worksheet. Look at the attached Yearly Expense Worksheet and play with the numbers....you must have the Excel program on you computer to pull up the worksheet and work on it.Excel Info Sheet - Click Here
Yearly Expenses Worksheet - Click Here
