Understanding Microsoft Excel

1. Understanding Microsoft Excel Lesson 1 – Microsoft Excel 2010

2. The goal of this lesson is for students to successfully explore and describe the Excel window and to create a new worksheet. The student will learn to edit a worksheet, save the workbook and properly exit the program. Learning Goals

3. On completion of this lesson, students will be able to do the following: • Create a workbook • Understand Microsoft Excel window elements • Select cells • Enter text, numbers, and dates in a worksheet • Enter a range of data • Edit cell contents • Adjust the size of rows and columns • Align cell contents • Find and replace cell contents • Insert and delete cells, rows, and columns • Cut, copy, paste, and clear cells • Use additional paste techniques • Move between worksheets • Name and save a workbook • Open a workbook • Rename a worksheet • Preview and print a worksheet • Close a workbook and exit Excel Learning Objectives

4. Lets you put numbers into a spreadsheet so that you can do things such as calculations, graphs, and statistical analysis quickly. • Uses: • Logging my daily workouts • Creating a household budget • Calculating grades What is Excel?

5. Clicking on an Icon on the Desktop Starting Excel What else??? Using the Start Menu

6. Spreadsheet – The type of program that is used to perform calculations. • Worksheet – A blank page in a spreadsheet file. • Workbook – A collection of worksheets. Spreadsheet Terms

7. Name Box Title Bar Active Cell More Spreadsheet Terms Formula Bar Column Headers Row Headers

8. When you first open Excel, you see one blank worksheet. • The visible worksheet is actually part of a workbook that contains three sheets. (Sheet1, Sheet2, Sheet3). Opening and Closing Worksheets Close a worksheet Open a blank worksheet

9. A filename and location should be assigned the first time a workbook is saved. Save often!!! • The file name can be up to 255 characters in length. • The / \ < > * ? " | : ; characters may not be used when naming a workbook. • Save a workbook for the first time using either the Save option in Backstage view or by clicking the Save icon on the Quick Access Toolbar. • Save it with a new name or new file type by clicking “Save As” in the Backstage view. Naming and Saving a Workbook

10. For spreadsheets that have already been set up for specific purposes, use a template • You can save spreadsheets that you create to use as templates later. What would be the benefit of using a template? Templates

11. Cell ranges are identified by the first cell address and the last cell address, separated by a colon. You can select 1 cell or a group of cells (a range). Use the “select all” button to select all cells. Selecting Cells How would you identify the cell range shown?

12. Select non-adjacent cells by holding down CTRL. The “Name Box” shows the address of the active cell. Click the row or column header to select an entire row or column. Cell Selection, continued.

13. Formula- a mathematical equation used to calculate a value. Text (sometimes called labels) – words or numbers that won’t be used in math Entering Data into a Worksheet Notice that anything typed in the active cell appears in the formula bar. Numbers – Values that will be used in math

14. By default, text is left aligned and values are right aligned. • You can also adjust vertical alignment. Cell Alignment

15. Row height is measured in points. • A point is a unit of measurement that determines the height of a character. • A point is approximately 1/72 of an inch • How tall is 72 point font? • Excel’s default column width is 8.43 characters wide • A cell can contain up to 32,000 characters. Row and Column Size

16. Non-formatted values (numbers) are shown in scientific notation. Formatted numbers are replaced by ####. What if it Doesn’t Fit? Text spills over if there is room, cuts off if there isn’t.

17. Mouse over the border between rows or columns until the cursor changes as shown. • To resize- • Hold down the left mouse button and drag to the desired size. • Double click to autofit the size to the cell’s contents. • Which do you prefer? Adjusting Row and Column Size You can resize several rows or columns at once by selecting them all and the resizing using the same methods.

18. To enter data in a range more easily select the range and start typing. • Press “Enter” or “Tab” to move to the next cell in the range. What is a range??? Entering a Range of Data

19. Consists of – Currency (money!) Percentages Decimals Fractions Exponents Numeric Data in a Spreadsheet Which are negative???

20. Dates can be entered using a combination of text and numbers, or just numbers. • Change the format on the Home tab in the Number group. • Regardless, dates are serial numbers and can added, subtracted, and used in other calculations. Entering Dates in a Worksheet When might you use dates in a calculation?

21. Double click on a cell or click in a cell and then in the formula bar to edit its contents. Use the “cancel” or the ESC key to cancel an entry before it is actually entered in the worksheet, restore the cell’s contents, and exit Edit mode. Editing Data in a Cell You can click the Enterbutton or the Enter key to complete an entry.

22. A worksheet contains more than 65,000 rows and 256 columns. • The Find and Replace option can quickly search a large worksheet and replace erroneous data with correct data. • A formula can be typed into a search string by choosing formulas in the Look In drop down option. • Data can be searched for by using a search string as well as matching the case of the data or matching the entire contents of the cell. Finding and Replacing Cell Contents

23. Insert or delete rows or columns by • Right clicking on the heading and choosing your option. • Using the Cell group on the Home tab. • New rows are inserted about the selected row, new columns to the left. Inserting and Deleting Cells, Rows, and Columns

24. Cutting data from a cell and pasting it to a new cell is actually moving the data. • Copying data from a cell and pasting into another location actually makes a duplicate of the data without affecting the original cell. • Contents can be removed from a cell without removing the cell formats. Cutting, Copying, Pasting, and Clearing Cells

25. Remember that each workbook is made up of three worksheets by default. • Click the Sheet Tabs at the bottom of the page to change the active worksheet. • You can move data between worksheets. Moving to a New Worksheet

26. Worksheets are named Sheet1, Sheet2, etc. by default, according to their location in the workbook. • Workbooks should be named appropriately based upon their contents. • Double-click the sheet tab and enter the new sheet tab name to rename the sheet. • You can change the tab color by right clicking on the tab. Renaming a Worksheet

27. Viewing a spreadsheet prior to printing it is important to pinpoint errors in a worksheet. • Clicking anywhere on the preview will toggle the zoom. • An entire worksheet, a selected range in a worksheet, or an entireworkbook can be printed. Previewing and Printing a Worksheet

28. Closing the file and quitting Excel will keep the task bar uncluttered. • Closing a workbook window will not close the Excel window. • Close a workbook window by choosing Close found under the File Tab. • Close Excel by choosing Exit from the File Tab menu list. Closing a Workbook and Quitting Excel