Excel Lesson 1 Microsoft Excel Basics Microsoft Office
Excel Lesson 1 Microsoft Excel Basics Microsoft Office 2010 Introductory Pasewark & Pasewark
Objectives l Excel Lesson 1 l 2 l l Define the terms spreadsheet and worksheet. Identify the parts of a worksheet. Start Excel, open an existing workbook, and save a workbook. Move the active cell in a worksheet. Pasewark & Pasewark Microsoft Office 2010 Introductory
Objectives (continued) l Excel Lesson 1 l 3 l l Select cells and enter data in a worksheet. Edit and replace data in cells. Zoom, preview, and print a worksheet. Close a workbook and exit Excel. Pasewark & Pasewark Microsoft Office 2010 Introductory
Introduction to Spreadsheets--page EX 4 Excel Lesson 1 l 4 l Microsoft Excel 2010 is the spreadsheet program in Microsoft Office 2010. A spreadsheet is a grid of rows and columns in which you enter text, numbers, and the results of calculations. Pasewark & Pasewark Microsoft Office 2010 Introductory
Introduction to Spreadsheets Excel Lesson 1 l 5 l The primary advantage of computer spreadsheets is their ability to complete complex and repetitious calculations quickly and accurately. In Excel, a computerized spreadsheet is called a worksheet. The file used to store worksheets is called a workbook. Pasewark & Pasewark Microsoft Office 2010 Introductory
Starting Excel Lesson 1 l 6 l You click start, select student’s menu, go to Microsoft Office and then select Excel from the menu. The Excel program window has the same basic parts as all Office programs: the title bar, the Quick Access Toolbar, the Ribbon, Backstage view, and the status bar. Pasewark & Pasewark Microsoft Office 2010 Introductory
Starting Excel (continued) Excel program window Excel Lesson 1 l 7 Pasewark & Pasewark Microsoft Office 2010 Introductory
Exploring the Parts of the Workbook Excel Lesson 1 l 8 l l Each workbook contains three worksheets by default. The name of each worksheet appears in the sheet tab at the bottom of the worksheet window. The worksheet displayed in the work area is the active worksheet. Pasewark & Pasewark Microsoft Office 2010 Introductory
Exploring the Parts of the Workbook l Excel Lesson 1 l 9 l l Columns appear vertically and are identified by letters. Rows appear horizontally and are identified by numbers. A cell is the intersection of a row and a column. Each cell is identified by a unique cell reference. It combines the cell’s column letter and row number. Example: C 11 Pasewark & Pasewark Microsoft Office 2010 Introductory
Exploring the Parts of the Workbook (continued) l Excel Lesson 1 l 10 The pointer in a worksheet changes to a thick white plus sign when it is in the worksheet. When the pointer is moved to a button on the Ribbon, the pointer changes to a white arrow. Pasewark & Pasewark Microsoft Office 2010 Introductory
Exploring the Parts of the Workbook (continued) l Excel Lesson 1 l 11 l The cell in the worksheet in which you can type data is called the active cell. The Name Box, or cell reference area, displays the cell reference of the active cell. The Formula Bar displays a formula when a worksheet cell contains a calculated value. Pasewark & Pasewark Microsoft Office 2010 Introductory
l The contents of the active cell always appear in the Formula Bar. Excel Lesson 1 – 12 It appears to the right of the Name Box and displays a formula when the cell of a worksheet contains a calculated value. Pasewark & Pasewark Microsoft Office 2010 Introductory
Exploring the Parts of the Workbook (continued) l Excel Lesson 1 l 13 A formula is an equation that calculates a new value from values currently in a worksheet. If a cell is not wide enough to display all the cell’s contents, extra text extends into the next cells if there is room. Pasewark & Pasewark Microsoft Office 2010 Introductory
Opening an Existing Workbook Excel Lesson 1 l 14 l Opening a workbook means loading an existing workbook file from a drive into the program window. To open an existing workbook, you click the File tab on the Ribbon to display Backstage view, and then click Open in the navigation bar. The Open dialog box appears. Pasewark & Pasewark Microsoft Office 2010 Introductory
Opening an Existing Workbook (continued) Frogs workbook open in Excel Lesson 1 l 15 Pasewark & Pasewark Microsoft Office 2010 Introductory
Excel Lesson 1 Saving a Workbook Two ways to save: l The Save command saves an existing workbook, using its current name and save location. l The Save As command lets you save a workbook with a new name or to a new location. 16 Pasewark & Pasewark Microsoft Office 2010 Introductory
Excel Lesson 1 l 17 You can create a new folder in which to save a file by clicking the New folder button in the Save As dialog box. Type a name for the new folder, and then press the Enter key. Pasewark & Pasewark Microsoft Office 2010 Introductory
Excel Lesson 1 l 18 As you have saved the workbook, you can use the save command in the backstage view or the Save button on the Quick Access toolbar to periodically save the latest version of the workbook with the same name in the same location. Pasewark & Pasewark Microsoft Office 2010 Introductory
Excel Lesson 1 l 19 Save frequently (at least every 10 minutes) to ensure that you always have a current version of the file available in case of an unexpected power outage or computer shutdown. You can press the Ctrl+S to quickly save your workbook. Pasewark & Pasewark Microsoft Office 2010 Introductory
l Excel Lesson 1 l 20 l Step-by-Step 1. 1 page EX 5 Step-by-Step 1. 2 page EX 6 -7 Step-by-Step 1. 3 page EX 8 -9 Pasewark & Pasewark Microsoft Office 2010 Introductory
Moving the Active Cell in a Worksheet--page EX 9 Excel Lesson 1 l 21 l The easiest way to change the active cell in a worksheet is to move the pointer to the cell you want to make active and click. The column letter and row number of the active cell are shaded in orange for easy identification. Pasewark & Pasewark Microsoft Office 2010 Introductory
Moving the Active Cell in a Worksheet Excel Lesson 1 l 22 l You can display different parts of the worksheet by using the mouse to drag the scroll box in the scroll bar to another position. When you press and hold down an arrow key, the active cell shifts in that direction repeatedly and quickly. Pasewark & Pasewark Microsoft Office 2010 Introductory
Moving the Active Cell in a Worksheet Excel Lesson 1 l 23 l You can also move the active cell to different parts of the worksheet using the keyboard or the Go To command. You can also change the active worksheet to the next worksheet by pressing the Ctrl+Page down Key. Pasewark & Pasewark Microsoft Office 2010 Introductory
Moving the Active Cell in a Worksheet (continued) Keys for moving the active cell in a worksheet Excel Lesson 1 l 24 Pasewark & Pasewark Microsoft Office 2010 Introductory
Selecting a Group of Cells l Excel Lesson 1 l 25 A group of selected cells is called a range. In an adjacent range, all cells touch each other and form a rectangle. – To select an adjacent range, click the cell in a corner of the range, drag the pointer to the cell in the opposite corner of the range, and release the mouse button. Pasewark & Pasewark Microsoft Office 2010 Introductory
Selecting a Group of Cells Excel Lesson 1 l 26 l The range is identified by its range reference, which lists both the cell in its upper-left corner and the cell in its lower right corner, separated by a colon. example, A 3: C 5. Pasewark & Pasewark Microsoft Office 2010 Introductory
Selecting a Group of Cells (continued) l A nonadjacent range includes two or more adjacent ranges and selected cells. Excel Lesson 1 – 27 To select a nonadjacent range, select the first adjacent range or cell, press the Ctrl key as you select the other cells or ranges you want to include, and then release the Ctrl key and the mouse button. Pasewark & Pasewark Microsoft Office 2010 Introductory
l Excel Lesson 1 l Step-By-Step 4 page EX 10; Step-by-Step 5 page Ex 11 28 Pasewark & Pasewark Microsoft Office 2010 Introductory
Entering Data in a Cell l Worksheet cells can contain text, numbers, or formulas. Excel Lesson 1 – – 29 Text is any combination of letters and numbers and symbols, such as headings, labels, or explanatory. Numbers are values, dates, or times. Numbers that extend beyond a cell’s width appears as ##### in the cell. Formulas are equations that calculate a value. Pasewark & Pasewark Microsoft Office 2010 Introductory
Entering Data in a Cell You enter data in the active cell. Excel Lesson 1 l 30 Pasewark & Pasewark Microsoft Office 2010 Introductory
Step-by-Step 1. 6 page EX 12 -13 Excel Lesson 1 l 31 Pasewark & Pasewark Microsoft Office 2010 Introductory
Changing Data in a Cell l Excel Lesson 1 l You can edit, replace, or clear data. You can edit cell data in the Formula Bar or in the cell. The contents of the active cell always appear in the Formula Bar. To edit the data directly in a cell, make the cell active and then press the F 2 key or double-click the cell. l 32 Pasewark & Pasewark Microsoft Office 2010 Introductory
Changing Data in a Cell Excel Lesson 1 l 33 l To replace cell data, select the cell, type new data, and press the Enter button on the Formula Bar or the Enter key or the Tab key. To clear the active cell, you can use the Ribbon, the keyboard, or the mouse. Pasewark & Pasewark Microsoft Office 2010 Introductory
Step-by-Step 1. 7 page EX 14 -15 Excel Lesson 1 l 34 Pasewark & Pasewark Microsoft Office 2010 Introductory
Searching for Data Excel Lesson 1 l 35 The Find command locates data in a worksheet, which is particularly helpful when a worksheet contains a large amount of data. You can use the Find command to locate words or parts of words. Pasewark & Pasewark Microsoft Office 2010 Introductory
Excel Lesson 1 l 36 If you enter an incorrect value in one of the cells and want to find it, you would choose “cell contents” as your place to search in the within option box. Pasewark & Pasewark Microsoft Office 2010 Introductory
Searching for Data Excel Lesson 1 l 37 You can use wildcard characters in the Find What box to search for data that matches a particular pattern. Use an asterisk for two or more characters. Pasewark & Pasewark Microsoft Office 2010 Introductory
Searching for Data Excel Lesson 1 l 38 l l The Replace command is an extension of the Find command. Replacing data substitutes new data for the data that the Find command locates. To use the Replace command, in the Editing group o the Home tab of the Ribbon, click the Find and Select button and then click Replace. Pasewark & Pasewark Microsoft Office 2010 Introductory
Searching for Data (continued) Find and Replace options Excel Lesson 1 l 39 Pasewark & Pasewark Microsoft Office 2010 Introductory
Step-by-Step 1. 8 page EX 16 -17 Excel Lesson 1 l 40 Pasewark & Pasewark Microsoft Office 2010 Introductory
Zooming a Worksheet Excel Lesson 1 l 41 l l You can change the magnification of a worksheet using the Zoom controls on the status bar. The default magnification for a workbook is 100%. For a closer view of a worksheet, click the Zoom In button or drag the Zoom slider to the right to increase the zoom percentage. Pasewark & Pasewark Microsoft Office 2010 Introductory
Excel Lesson 1 l 42 l If you want to see more cells in the work area, click the Zoom button or drag the zoom slider to the left to decrease the zoom percentage. In the Zoom dialog box, click the Fit selection option button to zoom the worksheet so the selected range fills the worksheet window. Pasewark & Pasewark Microsoft Office 2010 Introductory
Zooming a Worksheet (continued) Zoom dialog box and controls Excel Lesson 1 l 43 Pasewark & Pasewark Microsoft Office 2010 Introductory
Previewing and Printing a Worksheet Excel Lesson 1 l 44 l You can print a worksheet by clicking the File tab on the Ribbon, and then clicking Print in the navigation bar to display the Print tab. The Print tab enables you to choose print settings such as selecting the number of copies you want to print, the printer, the parts of the worksheet to print, and the way the printed worksheet will look. Pasewark & Pasewark Microsoft Office 2010 Introductory
Previewing and Printing a Worksheet The Print tab also allows you to preview your pages before printing. Excel Lesson 1 l 45 Pasewark & Pasewark Microsoft Office 2010 Introductory
Closing a Workbook and Exiting Excel Lesson 1 l 46 l You can close a workbook by clicking the File tab on the Ribbon, and then clicking Close in the navigation bar. Excel remains open. You can also close the workbook and leave Excel open by clicking the Close Window button located below the sizing buttons in the title bar. Pasewark & Pasewark Microsoft Office 2010 Introductory
Closing a Workbook and Exiting Excel Lesson 1 l 47 l If you try to close a workbook that contains changes you haven’t saved, a dialog box asks you whether or not you want to save the file. To exit the workbook, click the Exit command in the navigation bar. Pasewark & Pasewark Microsoft Office 2010 Introductory
l Excel Lesson 1 l 48 l Step-by-Step 1. 9 page EX 18 Step-by-Step 1. 10 page EX 20 Step-by-Step 1. 11 page EX 20 Pasewark & Pasewark Microsoft Office 2010 Introductory
- Slides: 48