### Present Remotely

Send the link below via email or IM

• Invited audience members will follow you as you navigate and present
• People invited to a presentation do not need a Prezi account
• This link expires 10 minutes after you close the presentation

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.

# Copy of Basic Excel 2007 Tutorial

For the students of Wyeth, Inc.
by

## glecy jaen

on 3 February 2013

Report abuse

#### Transcript of Copy of Basic Excel 2007 Tutorial

The combination of a column coordinate and a row coordinate make up a cell address. For example, the cell located in the upper-left corner of the worksheet is cell A1, meaning column A, row 1. Cell E10 is located under column E on row 10. You enter your data into the cells on the worksheet. The cell address of the cell you are in displays in the Name box which is located on the left side of the Formula bar. Status bar The Status bar appears at the very bottom of the Excel window and provides such information as the sum, average, minimum, and maximum value of selected numbers. You can change what displays on the Status bar by right-clicking on the Status bar and selecting the options you want from the Customize Status Bar menu. You click a menu item to select it. You click it again to deselect it. A check mark next to an item means the item is selected. Down arrow key
Up arrow key
Tab key
Shift + Tab key
Right and left arrow keys
Page up and Page down
Ctrl + Home key F5 function is the Go to key.
Ctrl+ G You can select multiple cells by:
Pressing F8 (Note that "Extend Selection" appears in the Status bar.
Ctrl + pressing left mouse key + move mouse. Entering Data Step 1: Type "John Jordan" on the cell A1
Step 2: Do not press ENTER yet.
Step 3: Click the BACKSPACE button until "Jordan" is erased.
Step 4: Press ENTER and the name "John" appears on the cell A1. Edit Cell Step 1: Move to cell A1 using the arrow keys.
Step 2 : Press f2
Step 3: Using the BACKSPACE button, delete "n" and "h".
Step 4: Type "nes"
Step 5: Press ENTER Changing John to Jones Alternate Method Editing cell using the Formula Bar Changing Jones to Joker Move again to cell A1
Click in the formula area of the Formula bar.
Erase "nes" then type "ker"
Press Enter Alternate Method: Edit a Cell by Double-Clicking in the Cell Move to cell A1
Double-click in cell A1
Press the END key to put your cursor at the end of the text.
Use the BACKSPACE to delete "ker" in Joker.
Then type "hnson".
Press ENTER. Changing a Cell Entry Changing Johnson to Cathy Typing in a cell replaces the old cell entry with the new information you type. Wrap Text When you type text that is too long to fit in the cell, the text overlaps the next cell. If you do not want it to overlap the next cell, you can wrap the text. Step 1: Move to cell A2
Step 2: Type "Text is too long"