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
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>
