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
  Click to open user profile  
mark_anderson, 12th Jun 2022, 12:55 PM
Thanks for writing the Nice and Informative post for us. This really contains a lot of useful and related information about This Topic.
 
 
  Click to open user profile  
mark_anderson, 12th Jun 2022, 12:55 PM
You show an impressive grasp of this subject! Such a nice Post Keep up the Good Work
 
 
  Click to open user profile  
ajdajddlek123, 12th Jul 2023, 8:05 AM
I was recommended this blog through a friend from school. No one understood my problem, but I looked at your blog and solved the problem. I will share information about to my friends. I like your blog very much. good luck. https://meoktwi.com
 
 
  Click to open user profile  
meeloun, 7th Feb 2024, 4:48 AM
每一家英文论文代写 http://www.hotessay.net/our-services.php 机构都是会有不一样的管理制度,这也是为了更好地维护好顾客和店家的双向利益。因此大家不必觉得只告之另一方相对的创作内容就可以,一定要确立另一方是不是能够为大家提供修改润色服务项目。
 
 
  Click to open user profile  
colleenshirle, 9th Dec 2024, 6:31 PM
Wow, this is such a handy accounting sheet for getting the basics right! It’s perfect for keeping things simple and organized. If you ever need something more advanced or professional help, Accounting Firms in UAE offer tailored solutions to fit any business need. Great start, though—keep it up! Check Out This: https://www.simplysolved.ae/outsource-ac....
 
   
 
 
online learning made for people
Dreevoo.com | CONTRIBUTE | FORUM | INFO