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
   
 
 
online learning made for people
Dreevoo.com | CONTRIBUTE | FORUM | INFO