1 / 40

Introduction to Microsoft Excel 2010

Introduction to Microsoft Excel 2010. While Waiting (Do Now) . Launch Microsoft Excel Create a Blank Document Name and Save Document to Desktop. Standard Addressed.

tracy
Download Presentation

Introduction to Microsoft Excel 2010

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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

More Related