Microsoft Excel is a Spreadsheet program. A Spreadsheet is a collection of rows and columns designed on a grid that can be easily created and edited with this program. Formulas can be added into cells to perform Addition, Subtraction, Multiplication, and Division.
Here is an example of a formula added into the table below.
The columns are A, B C & D.
The rows are 1-7.
The formula written in column D to find the Difference of columns B & C is:
=C2-B2
This formula written in column D takes the amount of the 4th quarter in column C, and subtracts the amount of the 3rd quarter in column B, and leaves the difference of the two located in column D. Once the formula is written in a cell, it is then "filled down" or "filled right" so it only has to be written once. The "fill down or right" feature allows you to find information quickly and easily, without having to re-type formulas.
Below is an example of a small Spreadsheet showing a Report for 3rd & 4th Quarter Expenses:
Spreadsheet - Expense Report
| EXPENSES | 3RD QTR | 4TH QTR | DIFFERENCE |
| Auto | $ 11,876.90 | $ 25,000.00 | $ 13,123.10 |
| Supplies | $ 8,864.00 | $ 4,876.00 | $ (3,988.00) |
| Payroll | $ 36,987.43 | $ 21,987.00 | $ (15,000.43) |
| Phone | $ 12,873.25 | $ 10,500.00 | $ (2,373.25) |
| Rent | $ 15,654.00 | $ 15,654.00 | - |
| Taxes | $ 6,560.00 | $ 7,120.00 | $ 560.00 |
A Chart can easily be created from a Spreadsheet once it has been completed. Any information that you like can be displayed in chart form, and there are many different styles of charts available.
Below is an example of a Pie Chart created from the information contained in the Spreadsheet above, showing the 3rd Quarter Expenses.
