# Microsoft Excel Quick Tips

Document Sample

```					                            Microsoft Excel Quick Tips
Created by
Rebecca Lamury, Louisiana Region III
TLTC

The Toolbars:

The first thing you need to do for this tutorial is make sure you have the
appropriate toolbars on the screen. To do this click View then Toolbars. Make
sure Standard and Formatting are checked.
This is what the toolbars should look like:

The Worksheet:
An Excel worksheet is made up of cells set up into rows and
columns. Each cell is specifically identified by its column and
row. Here is an example of how the cells are named.

The Formula Bar:
The Formula Bar is located at the top of the screen under your
toolbars. It will display the formula that is being applied to that
cell. If no formula is applied, it will simply show what is typed in
that cell. In this example, cell C1 is selected. The formula
applied to cell C1 is the SUM of A1 through B1. Notice that in
cell C1 the number 9 appears, which is the sum of 3 and 6.

Basic Excel 1
*If you do not see the Formula Bar, click View and make sure
Formula Bar is checked.
Entering Data:
Data can be entered into Excel by simply clicking on the cell
you’d like to enter data into and typing the data.
You can move to the next column by pressing Tab or to the
next row by pressing Enter.
You can also Copy data from another location and Paste it into
Excel.

Resizing/Merging Cells:
You can resize your cells if you need more room.
 To make the cell WIDER, move your mouse cursor to the
top of the worksheet where you see the A, B, C, etc.
Position your mouse to the right edge of the cell letter
you’d like to resize.

You will notice that your cursor will change shape and
look like this:    .
Click and Hold your left mouse button and Drag your
mouse to the right. When you are satisfied with the new
size, release the mouse button.

 To make the cell TALLER, move your mouse cursor to the
left side of the worksheet where you see the 1, 2, 3, etc.
Position your mouse under the cell number you’d like to
resize.

Basic Excel 2
Click, Hold, and Drag down
to resize. When you are
satisfied with the new size,
release the mouse button.
 To Merge cells, select the cells you’d like to merge
together by Clicking the middle of the cell in which you’d
like to start, Holding, and Dragging until you’ve selected
all the cells you’d like to merge. Then click the Merge and
Center button on the toolbar.

The cells you selected will now become one cell.

Creating Graphs:
 Enter your data into Excel.
 Highlight the data you’d like to graph. (To highlight: Place
your mouse on the top left cell of the section of data you
want to graph. Then Click, Hold, and Drag your mouse
down and right until you have all of your data selected.)
 Your data should look like this:

Basic Excel 3
 Once your data is highlighted, click the chart wizard
button on the toolbar.

 You will then see the chart wizard box pop up.
 Choose your chart type from the left menu and the sub-
type from the right menu. (At this point, you can click Finish,
and your graph will be made. If you’d like more options, however,
follow the remaining 4 steps in this section.)
   Click Next to see how your chart will look.
   Choose to view in Rows or Columns.
   Click Next. Enter in a Chart Title.
   Click Finish.

Basic Formulas:
Formulas can be entered into cells using the Formula Bar.
You can enter in formulas manually or use formulas provided by
the Excel program.
Entering formulas manually:
 Click in the cell where you’d like to apply the formula.
 Now click the = on the Formula Bar.

Basic Excel 4
 Use the following to indicate the type of formula you’d
like to apply:                      Notice how you must use the
names of the cells when you
either type the cell name in by
- Subtraction (Example: A1-B1)         hand, or you can simply click
on the cell, and its name will
* Multiplication (Example: A1*B1)      automatically appear in the
formula bar. Then type in the
appropriate mathematical
/ Division (Example: A1/B1)
sign and click the next cell
you’d like to include.
^ Exponential (Example: A1^2)

 Type in your formula into the Formula Bar.
o Use the following diagrams for help.

Basic Excel 5
Formatting Data Style (\$,%):
 Choose the cell(s) that you’d like to format by
highlighting.
 Look for these symbols on the toolbar:

 These buttons will change your results to:

Currency Form

Percent Form

Comma/Decimal Form

Increase/Decrease Decimal

Excel Built-In Formulas:
Excel has many built in formulas for use in your worksheet. We
will only cover AutoSum and Average.

AutoSum:
Excel can quickly add all of the numbers in a given
row/column.
 Select the Cell below your list of numbers (*If you’re
adding a row, you’d click the cell to the right of your numbers.)

 Then click the AutoSum button on the toolbar.

 A dotted line will
appear around

 Click Enter.

Result will appear here.                                     Basic Excel 6
Average:
Excel can quickly calculate the average of a set of
numbers.
 Click the Paste Function button.

 Choose Statistical,
then Average.

 Click OK.

 A new box will appear.

 Select the cells you’d
like to average by
highlighting them with
the mouse.

 Click Enter twice.

Basic Excel 7
Applying the Same Formula/Data to Many Cells:
Excel makes it easy to repeat the same formula/data to many
cells.
 Click on the cell you’d like to copy.
 Move your mouse to the black dot on lower right corner
of that cell.

 Notice your cursor will change to a black plus sign.

 Click, Hold and Drag your mouse
until you’ve selected all of the cells
that you’d like to contain the same
formula/data.

 Release the mouse button.
been repeated through your
entire selection.

Basic Excel 8
Basic Excel 9

```
DOCUMENT INFO
Shared By:
Categories:
Stats:
 views: 39 posted: 1/18/2009 language: English pages: 9
The Slasher