Dreevoo.com | Online Learning and Knowledge Sharing
 
Home | Programs | Microsoft Office | Microsoft Excel | Very basic accounting sheet
Guest
Click to view your profile
Topics
Programs
Languages
Recipes
Home
Shortcuts
 
 

Very basic accounting sheet

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

 
  Author: mat | Version: 2010 | 19th October 2011 |  
 
 
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.


 
 
 
   
  Please login to post a comment
   
 
 
online learning made for people
Dreevoo.com | CONTRIBUTE | FORUM | INFO