Dreevoo.com | Online Learning and Knowledge Sharing
 
Home | Programs | Microsoft Office | Microsoft Excel | My first Excel document
Guest
Click to view your profile
Topics
Programs
Languages
Recipes
Home
Shortcuts
 
 

My first Excel document

Introduction to Microsoft Excel 2010, let's make a simple accounting sheet.

 
  Author: mat | Version: | 12th September 2011 |  
 
 
1.
 

Open Microsoft Excel 2010 by clicking Start, All Programs, Microsoft Excel and Microsoft Excel 2010.

 
 
2.
 

You can now see the empty Excel sheet. The sheet is made of Columns (A, B, C, ..) and Rows (1, 2, 3, ...). And the little squares are called Cells. In this cells we enter the data. Let's get started.

Click the cell A1 and type Number into it. (see picture)

 
 
3.
 

Now click cell B1 and type Name in it, in the cell C1 enter Cost.

 
 
4.
 

Now in Cells A2 and A3 enter number 1 and 2.

 
 
5.
 

Now select both cells (A2, A3)...

 
 
6.
 

Click the bottom right corner of the selection and drag it to the row 10.

 
 
7.
 

You should now have the numbers from 1 to 9 in the Column A, starting at the row 2 and ending at the row 10.

 
 
8.
 

In the column B, under the Name, enter some random names.

In the column C, under the Cost, enter some random numbers.

 
 
9.
 

Now select the numbers under the Cost as you see in the picture.

 
 
10.
 

Right click the selection and then click Format Cells.

 
 
11.
 

Under the Number tab choose Currency, as Symbol choose $ (or any other currency symbol) and click OK.

 
 
12.
 

You numbers are now shown in the currency format.

Now click B12 cell and enter Total:

 
 
13.
 

Click the C12 cell (next to Total:) ...

 
 
14.
 

... in the menu click Formulas ...

 
 
15.
 

...click Auto Sum and press Enter.

 
 
16.
 

All your costs are now added up in one cell.

 
 
17.
 

Your first Excel sheet is now finished. All you need to do now is to save it.

Click File and Save.

 
 
18.
 

Enter the name of your document and click Save.

If you have any question regarding the lesson just click the Discuss the topic in forum link and ask away.

 
 
 
   
  Please login to post a comment
  Click to open user profile  
repsegatra, 13th Jan 2023, 6:23 PM
inspiring insights you are sharing. I love the way you are sharing it. Is there any way I could get updated for more?
온라인바카라
 
 
  Click to open user profile  
propharmacysh, 29th Jan 2023, 7:34 PM
Buy Apcalis Jelly Online Visit our website at: https://propharmacyshop.com/product/buy-....

 
 
  Click to open user profile  
repsegatra, 11th Feb 2023, 6:19 PM
Nice post. I discover some thing more challenging on different blogs everyday. Most commonly it is stimulating to study content off their writers and use a specific thing there. I’d want to apply certain while using the content on my weblog whether or not you don’t mind. Natually I’ll supply you with a link on your web blog. Thanks for sharing.
여우알바
 
 
  Click to open user profile  
repsegatra, 11th Feb 2023, 6:19 PM
Wonderful line up. We will be linking to this wonderful article on our website. Maintain up the very good writing.
Apple翻新
 
 
  Click to open user profile  
propharmacysh, 17th Feb 2023, 2:43 PM
Buy Cialis Jelly Online Visit our website at: https://propharmacyshop.com/product/buy-....

 
 
  Click to open user profile  
repsegatra, 19th Feb 2023, 1:56 PM
dancing is my passion and and i enjoy being enrolled in a dance class to improve my skills**
슈어맨
 
 
  Click to open user profile  
repsegatra, 22nd Feb 2023, 10:04 AM
Hi” best wishes to you and your very nice blog”
여우알바
 
 
  Click to open user profile  
repsegatra, 22nd Aug 2023, 4:32 PM
Well done! I thank you your input to this matter. It has been useful. my blog: how to make a girl like you
插花班
 
 
  Click to open user profile  
sympathizetra, 25th Apr 2024, 10:02 AM
There are dangers here, so be careful. Look at how beautiful these places are. Moving a geometric icon through a series of hurdles is what you have to do to finish each stage in Geometry Dash Lite. https://geometry-lite.io
 
 
  Click to open user profile  
harryjhon, 29th Apr 2024, 7:15 AM
I just like the helpful info you provide for your articles. I will bookmark your blog and check again here frequently. I¡¯m somewhat sure I¡¯ll learn lots of new stuff right right here! Good luck for the following! instagram
 
   
 
 
online learning made for people
Dreevoo.com | CONTRIBUTE | FORUM | INFO