|
|
|
|
|
Very basic accounting sheet
Point of this lesson is to show you a couple of very basic functions in Microsoft Office Excel.
|
|
 |
|
|
|
|
|
|
|
|
|
|
 |
1.
|
|
|
Let's say we're selling pound wise of coffee and want to calculate the profit including all the expanses we have.
Open a new Microsoft Office Excel document - click File, New and choose Blank Workbook.
Enter the same text in same cells as I did.
|
|
| |
2.
|
|
|
Now enter the same amount in the same cells as I did.
|
|
| |
3.
|
|
|
Right click the C3 cell (cost per lb value) and choose Format Cells...
|
|
| |
4.
|
|
|
Select Accounting and choose the same settings as I did.
Click OK.
|
|
| |
5.
|
|
|
The cost per lb value is now displayed in dollars ($).
Now click the C4 cell and enter = sign (see picture)...
|
|
| |
6.
|
|
|
...click the C2 cell and enter * sign ....
|
|
| |
7.
|
|
|
...click C3 and press Enter.
|
|
| |
8.
|
|
|
The whole cost is now calculated ($ 2,000.00).
Click the C8 cell (next to profit) enter = sign and click the C4 cell and enter - sign (see picture)...
|
|
| |
9.
|
|
|
...click C6 cell and press Enter.
|
|
| |
10.
|
|
|
Your profit is now calculated ($ 1,700.00).
|
|
| |
11.
|
|
|
Now try changing the cost per lb value from 2 to 3 and observe the profit.
|
|
|
 |
|
 |
|
 |
|
|
