Learning Microsoft Excel in comfort

WELCOME TO EXCEL

This handout provides step by step, easy to follow instructions on how to use Excel 2010 or Excel 2007. It doesn't matter if you are new to Excel and want to start from scratch or just want to use this Excel tutorial as a reference. It is kept simple!

To open the Excel work book

ü  Go to the start button, click and select Ms Excel the work book will be displayed.

To save in MS Excel

ü  Go to the office button at the top left of you page, click on save as a dialogue box will be displayed

ü  Type in the desired file name and click on the save button your file will be saved.

Parts of the Excel 2010 Screen

Active Cell

The active cell is recognized by its black outline. Data is always entered into the active cell. Different cells can be made active by clicking on them with the mouse or by using the arrow keys on the keyboard.

File Tab

The File tab is new to Excel 2010 - Sort of. It is a replacement for the Office Button in Excel 2007 which was a replacement for the file menu in earlier versions of Excel.

Like the old file menu, the File tab options are mostly related to file management such as opening new or existing worksheet files, saving, printing, and a new feature - saving and sending Excel files in PDF format.

Formula Bar

Located above the worksheet, this area displays the contents of the active cell. It can also be used for entering or editing data and formulas.

Name Box

Located next to the formula bar, the Name Box displays the cell reference or the name of the active cell.

Column Letters

Columns run vertically on a worksheet and each one is identified by a letter in the column header.

Row Numbers

Rows run horizontally in a worksheet and are identified by a number in the row header.

Together a column letter and a row number create a cell reference. Each cell in the worksheet can be identified by this combination of letters and numbers such as A1, F456, or AA34.

Sheet Tabs

By default there are three worksheets in an Excel file.

The tab at the bottom of a worksheet tells you the name of the worksheet - such as Sheet1, Sheet2 etc.

Switching between worksheets can be done by clicking on the tab of the sheet you wish to access.

Renaming a worksheet or changing the tab color can make it easier to keep track of data in large spreadsheet files.

Quick Access Toolbar

This customizable toolbar allows you to add frequently used commands. Click on the down arrow at the end of the toolbar to display the toolbar's options.

Ribbon

The Ribbon is the strip of buttons and icons located above the work area. The Ribbon is organized into a series of tabs - such as File, Home, and Formulas. Each tab contains a number of related features and options. First introduced in Excel 2007, the Ribbon replaced the menus and toolbars found in Excel 2003 and earlier versions.

 

Worksheets

A worksheet is a collection of cells where you keep and manipulate the data. By default, each Excel workbook contains three worksheets.

Select a Worksheet

When you open Excel, Excel automatically selects Sheet1 for you. The name of the worksheet appears on its sheet tab at the bottom of the document window.

To select one of the other two worksheets, simply click on the sheet tab of Sheet2 or Sheet3.

Rename a Worksheet

By default, the worksheets are named Sheet1, Sheet2 and Sheet3. To give a worksheet a more specific name, execute the following steps.

1.   Right click on the sheet tab of Sheet1.

2.   Choose Rename.

3. For example, type Sales 2010.

Insert a Worksheet

You can insert as many worksheets as you want. To quickly insert a new worksheet, click the Insert Worksheet tab at the bottom of the document window.

Move a Worksheet

To move a worksheet, click on the sheet tab of the worksheet you want to move and drag it into the new position.

1. For example, click on the sheet tab of Sheet4 and drag it before Sheet2.

Delete a Worksheet

To delete a worksheet, right click on a sheet tab and choose Delete.

1. For example, delete Sheet4, Sheet2 and Sheet3.www.google.com

Copy a Worksheet

Imagine, you have got the sales for 2010 ready and want to create the exact same sheet for 2011, but with different data. You can recreate the worksheet, but this is time-consuming. It's a lot easier to copy the entire worksheet and only change the numbers.

1. Right click on the sheet tab of Sales 2010.

2. Choose Move or Copy...

The 'Move or Copy' dialog box appears.

3. Select (move to end) and check Create a copy.

4. Click OK.

Note: you can even copy a worksheet to another Excel workbook by selecting the specific workbook from the drop-down list (see the dialog box shown earlier).

Zoom

 In most cases, you can use the minus and plus symbols in the status bar to quickly zoom the document. Use the buttons on the View tab to zoom to a specific percentage and to zoom to a selection.

1. To quickly zoom the document, use the minus and plus symbols in the status bar

To zoom to a specific percentage, execute the following steps.

2. On the View tab, click Zoom.

3. Enter a number (between 10 and 400) and click OK.

To zoom to a selection, execute the following steps.

4. First, select a range of cells.

5. On the view tab, click Zoom to Selection.

Split

Split your worksheet to view multiple distant parts of your worksheet at once. To split your worksheet (window) into a upper and lower part (pane), execute the following steps.

1. Click the split box above the vertical scroll bar.

2. Drag it down to split your window.

3. Notice the two vertical scroll bars. For example, use the lower vertical scroll bar to move to row 49. As you can see, the first 6 rows remain visible.

  

4. To remove the split, double click the horizontal split bar that divides the panes (or drag it up).

Note: in a similar way, you can use the split box to the right of the horizontal scroll bar to split your window into a left and right pane. You can even split your window into four panes. Any changes you make to one pane are immediately reflected in the other ones.

can you give this link a click

<A HREF="http://www.tripleclicks.com/13815002">
<IMG SRC="http://www.sfimg.com/SFIBanners/banner448.gif" border="0"/ ></A>