Send the link below via email or IMCopy
Present to your audienceStart remote presentation
- 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
- A maximum of 30 users can follow your presentation
- Learn more about this feature in our knowledge base article
Do you really want to delete this prezi?
Neither you, nor the coeditors you shared it with will be able to recover it again.
Make your likes visible on Facebook?
Connect your Facebook account to Prezi and let your likes appear on your timeline.
You can change this under Settings & Account at any time.
Copy of Basic Excel 2007 Tutorial
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
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"
Step 3: Press Enter Step 4: Return to cell A2
Step 5: Choose the Home Tab
Step 6: Click the Wrap Text Button Deleting a Cell Entry: Step 1: Select cells A1 to A2
Step 2: Press the Delete Key To delete an entry in a cell or a group of cells, you place the cursor in the cell or select the group of cells and press Delete. Save a file: It is important to always save your file whenever you are finish. Click the Office button. A menu appears.
Click Save. The Save As dialog box appears.
Go to the directory in which you want to save your file.
Type Lesson1 in the File Name field.
Click Save. Excel saves your file. Lastly! Closing Excel Step 1: Click the Office Button.
Step 2: Then click Close. THANK YOU FOR LISTENING!