Hi People
Following on from the basic Mileage spreadsheet, and with no suggestions as yet as to what you would like to see as a spreadsheet project, I felt a Personal Accounts spreadsheet, might be of use.
I would however, ask you to look over ALL the first tutorial as I will be making some assumptions on what you know, based on information from the earlier tutorial. So please review the last tutorial fully, before getting into this one.
OK that being said (also I would like to add, that I cannot ANY responsibility for your use, misuse or abuse of this information or any errors which may creep in), let's get going.
Open OpenOffice Calc and setup the following in row 5 (these are the headings)
Date (B5) means put the title 'Date' in cell B5
So
Date (B5), Transaction (C5), Type (D5), Amount (E5), Balance(F5)
These will do for now we may add more columns later.
If you remember how to set Formats for the individual columns (check back to the last tutorial for more information), set the column B as a Date format, set columns E and F as currency
For now that's it
See you next time
Prometheus1618
We now have a FREE SPYWARE REPORT available, yours to keep and share if you wish. Fill in your details below and get yours now
No comments:
Post a Comment