Spreadsheets | Application software
Overview | Accounting | Statistical | Planning & modelling
Spreadsheets | Application software
The uses spreadsheets are being applied to are many and varied.
We will divide the uses into three categories;
Accounting
Where money is handled
Statistical and quantitative analysis
Where the spreadsheet is used to gather data and provide an analysis or summary, and
Planning and Financial modelling
Where the spreadsheet is used as an Executive Support System, to aid in project planning.
For example;
Maintaining a simple Payroll or Debtors (accounts Receivable) system.
(Uses limited database facilities)
Advantages
Such as statement of income and expenses, where totals and subtotals may be quickly determined.
Advantages
Statistical and quantitative data include:
For example
Advantages
For example
Advantages
This is commonly known as "What if" analysis.
The process of testing different assumptions.
Matching fixed costs + Variable costs against the sales price of goods, to see how many need to be manufactured to make a profit.
Advantages
For Example;
Advantages
[25/11/97] © 1997 V/2-Com (Verhaart), P O Box 8415, Havelock North, New Zealand.
