Very basic accounting sheet

Point of this lesson is to show you a couple of very basic functions in Microsoft Office Excel.

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.

Now enter the same amount in the same cells as I did.

Right click the C3 cell (cost per lb value) and choose Format Cells...

Select Accounting and choose the same settings as I did.

Click OK.

The cost per lb value is now displayed in dollars ($).

Now click the C4 cell and enter = sign (see picture)...

...click the C2 cell and enter * sign ....

...click C3 and press Enter.

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)...

...click C6 cell and press Enter.

Your profit is now calculated ($ 1,700.00).

Now try changing the cost per lb value from 2 to 3 and observe the profit.