



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.









