Loading presentation...

Present Remotely

Send the link below via email or IM


Present to your audience

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


Copy of Basic Excel 2007 Tutorial

For the students of Wyeth, Inc.

glecy jaen

on 3 February 2013

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of Copy of Basic Excel 2007 Tutorial

Basic Excel 2007 Tutorial Entering Texts and Numbers Microsoft Excel Window The Ribbon Formula Bar Exercise 2: Go to Cells Quickly Exercise 1:Moving Around the Worksheet The Name Box Select Cells You use commands to tell Microsoft Excel what to do. In Microsoft Excel 2007, you use the Ribbon to issue commands. The Ribbon is located near the top of the Excel window, below the Quick Access toolbar. At the top of the Ribbon are several tabs; clicking a tab displays several related command groups. Within each group are related command buttons. You click buttons to issue commands or to access menus and dialog boxes. You may also find a dialog box launcher in the bottom-right corner of a group. When you click the dialog box launcher, a dialog box makes additional commands available. You can also use the Name box to go to a specific cell. Just type the cell you want to go to in the Name box and then press Enter. If you wish to perform a function on a group of cells, you must first select those cells by highlighting them. Microsoft Excel is an electronic spreadsheet. You can use it to organize your data into rows and columns. You can also use it to perform mathematical calculations quickly. This tutorial teaches Microsoft Excel basics. The Microsoft Office Button In the upper-left corner of the Excel 2007 window is the Microsoft Office button. When you click the button, a menu appears. You can use the menu to create a new file, open an existing file, save a file, and perform many other tasks. The Quick Access Toolbar The Quick Access toolbar gives you with access to commands you frequently use. By default, Save, Undo, and Redo appear on the Quick Access toolbar. You can use Save to save your file, Undo to roll back an action you have taken, and Redo to reapply an action you have rolled back. The Title Bar On the Title bar, Microsoft Excel displays the name of the workbook you are currently using. At the top of the Excel window, you should see "Microsoft Excel - Book1" or a similar name. Worksheets Each worksheet contains columns and rows. The columns are lettered A to Z and then continuing with AA, AB, AC and so on; the rows are numbered 1 to 1,048,576. The number of columns and rows you can have in a worksheet is limited by your computer memory and your system resources.
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"
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!
Full transcript