Introduction to Microsoft Excel 2010

1. Introduction to Microsoft Excel 2010 SPS Technology Department

2. While Waiting (Do Now) • Launch Microsoft Excel • Create a Blank Document • Name and Save Document to Desktop SPS Technology Department

3. Standard Addressed Standard 1: Demonstrate proficiency in the use of computers and applications as well as an understanding of concepts underlying hardware, software, and connectivity. SPS Technology Department

4. Introduction To MS Excel By the end of this session you will know and be able to: • Describe structure and function of a spreadsheet (i.e., cell, column, row, values, labels, chart, graph). • Create an original spreadsheet, entering simple formulas. • Use advanced formatting features of a spreadsheet application (e.g., reposition columns and rows, add and name worksheets, alignment of data). • Define and use functions of a spreadsheet application (e.g., sort, filter, find) • Identify, discuss, and explore how spreadsheets are used to calculate and graph in a variety of settings (e.g., schools, government, business, industry, scientific research labs). SPS Technology Department

5. You Will Demonstrate This By • Creating a worksheet for • Book Inventory or • Equipment Inventory or • Class List or • Attendance Sheets SPS Technology Department

6. What is Excel?Why do I want to know how to use it? • Excel is a spreadsheet program that allows large amounts of data to be stored, calculated, sorted, and accessed quickly. • Some uses: • Store Information • Maintain Budgets • Inventories • Attendance • Grade book SPS Technology Department

7. Launching Excel In order to use a program, you must start—or launch—it first. 1. Click the Start button. The Start menu appears. 2. Click All Programs. The left pane of the Start menu displays the programs and menus installed on your computer. 3. Click Microsoft Office. 4. Select Microsoft Office Excel 2010. The Excel 2010 program screen appears. SPS Technology Department

8. WorkBook -vs.- Worksheets • A Microsoft Excel workbook is a file that contains one or moreworksheets. • A worksheet is the primary document that allows you to store and work with data. It is sometimes referred to as a spreadsheet. A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook. SPS Technology Department

9. Workbook -vs.- Worksheet • A Workbook by default has 3 worksheets • To create an additional Worksheet within a Workbook • Menu Bar>Insert>Worksheet • A Worksheet always insert to the left. SPS Technology Department

10. Naming a Worksheet Put cursor over Sheet Tab Right Click and pick Rename from Pop-up Menu Type in an Worksheet name SPS Technology Department

11. Columns, Rows, Cells • Columns labeled A, B, C . . . • Rows labeled 1, 2, 3 . . . • Cell - where Columns and Rows Intersected A1, C25, D32 . . . . SPS Technology Department

12. Resizing Columns and Rows • Resize a row - by dragging the line below the label of the row you would like to resize. • Resize a column - by dragging the line to the right of the label corresponding to the column you want to resize. SPS Technology Department

13. You Only Need To Resize Columns To Resolve This Problem SPS Technology Department

14. Alignment Of Data Within Cells • Numbers by default - right aligned • Labels/Words by default - left aligned • Data can be centered aligned – highlight data, select center alignment button on Formatting Toolbar. 7782 PD Center Student Name SPS Technology Department

15. Alignment Of Data Using Toolbar Icons Alignment Icons Highlight Cells You Wish To Format SPS Technology Department

16. 1. Select the cell(s) you want to align. 2. Click the Home tab on the Ribbon and click an alignment button in the Alignment group. SPS Technology Department

17. Centering Column Headings Highlight Column Headings and Select Center Icon on Formatting Toolbar SPS Technology Department

18. Merge Columns and Center Headings Merge and Center Headings over multiple Columns • Type Data in First Column of data • Highlight all Columns you wish to center over • Click on Icon in Formatting Toolbar SPS Technology Department

19. Formatting Options Using Menu Bar • Highlight Cells You Wish To Format • On the Home Tab Click Format • Selecting Format Cells will bring to the next screen SPS Technology Department

20. Select Data Category SPS Technology Department

21. SPS Technology Department

22. SPS Technology Department

23. Sort Data in a Column • Highlight Entire Column Or Row You Wish To Sort Sort Ascending Sort Descending SPS Technology Department

24. Sorting all Data in Worksheet • Highlight entire worksheet by selecting the blank area above the row 1 • Click the Home or Data tab • Click sort- Custom sort • Sort by-click add level • Then by Secondary Sort SPS Technology Department

25. Performing Basic Calculations Using Formulas SPS Technology Department

26. Summing Cells and Ranges SPS Technology Department

27. Formula Bar • Click to place the cursor into the Formula Bar so that you can perform or edit an equation. =A2+A3 Will total up values in cells =A2+A3 SPS Technology Department

28. Using Auto Sum Feature Excel allows you to quickly find the total of a column or row of Numbers using the Auto Sum Feature Highlight the Column or Row and then click on Auto Sum SPS Technology Department

29. You can access other formula functions in the AUTO SUM Feature SPS Technology Department

30. Deleting and Inserting Columns and Rows SPS Technology Department 1. Select the row or column heading(s) you want to delete. 2. Click the Home tab on the Ribbon and click the Delete button in the Cells group. The rows or columns are deleted. Remaining rows are shifted up, while remaining columns are shifted to the left. .

31. Inserting or Deleting a Column Highlight row or column Insert Delete SPS Technology Department

32. Page Setup SPS Technology Department

33. The Print settings and Print Preview as shown in Backstage view. Use the print settings in the left column to control how the document is printed. Use the print preview area in the right column to preview how the document will look when printed. SPS Technology Department

34. Save a new workbook 1. Click the Save button on the Quick Access Toolbar. The Save As dialog box appears. Other Ways to Save: Press <Ctrl> + <S>. Or, click the File tab and select Save. 2. Specify the drive and/or folder where you want to save your workbook. 3. Enter the file name in the File name text box. 4. Click Save. SPS Technology Department

35. SPS Technology Department

36. Name of Printer SPS Technology Department

37. Your Turn • Create a worksheet for • Book Inventory • Equipment Inventory • Class List • Attendance Sheets SPS Technology Department

38. Links for Learning Online Microsoft Excel Resources • Florida Gulf Coast University • http://www.fgcu.edu/support/office2007/Excel/index.asp • Get to Know Excel • http://office.microsoft.com/en-us/excel-help/ SPS Technology Department

39. References • Caughlin, J. (2002). Excel Workshop for Teachers. Watertown, MA: Tom Snyder Productions. SPS Technology Department

40. Rubric Excel I Teacher Name: _____________________________________ Student Name:     ________________________________________ SPS Technology Department