Unit 01 Introduction to Spreadsheets Using Microsoft Excel.pptx

Introduction to Spreadsheets Using Microsoft Excel

1. Level II Module 11: GAC011 Computing II: Data Management (Windows 7 and Microsoft Office 2010 1

2. Unit 1: Introduction to Spreadsheets Using Microsoft Excel Part A. Unit Introduction (v9.0 page 1) Learn: Open Microsoft Excel on your computer Create and save spreadsheets Navigate around a spreadsheet Understand the importance of planning and testing worksheet 2 Unit 1: Introduction to Spreadsheets Using Microsoft Excel

3. Unit 1: Introduction to Spreadsheets Using Microsoft Excel Part A. Unit Introduction (v9.0 page 1) Learn: Open Microsoft Excel on your computer Create and save spreadsheets Navigate around a spreadsheet Understand the importance of planning and testing worksheet Assessment Event 2: Project 1 will be distributed at the end of this unit. 3 Unit 1: Introduction to Spreadsheets Using Microsoft Excel

4. Unit 1: Introduction to Spreadsheets Using Microsoft Excel Part A. Unit Introduction (v9.0 page 1) Learn: Open Microsoft Excel on your computer Create and save spreadsheets Navigate around a spreadsheet Understand the importance of planning and testing worksheet Assessment Event 2: Project 1 will be distributed at the end of this unit. 4 Unit 1: Introduction to Spreadsheets Using Microsoft Excel

5. Part B. Understanding Excel What is a spreadsheet? (v9.0 page 2) Unit 1: Introduction to Spreadsheets Using Microsoft Excel 5

6. Part B. Understanding Excel What is a spreadsheet? (v9.0 page 1) Spreadsheet is a computer program (software) that allows us to organize data into rows and columns. Example: MS Excel Unit 1: Introduction to Spreadsheets Using Microsoft Excel 6

7. Part B. Understanding Excel What is a spreadsheet? (v9.0 page 1) Spreadsheet is a computer program (software) that allows us to organize data into rows and columns. Example: MS Excel It can: Do calculations Make decisions Graph data Develop professional looking reports Unit 1: Introduction to Spreadsheets Using Microsoft Excel 7

8. Part B. Understanding Excel What is a spreadsheet? (v9.0 page 1) Spreadsheet is a computer program (software) that allows us to organize data into rows and columns. Example: MS Excel It can: Do calculations Make decisions Graph data Develop professional looking reports Usage: Produce budgets Financial documents Forecasts Inventory/stock control Payrolls, etc Unit 1: Introduction to Spreadsheets Using Microsoft Excel 8

9. Task 1.1 The Use of Spreadsheets Discuss for which purposes Excel can be useful in: Unit 1: Introduction to Spreadsheets Using Microsoft Excel 9 Academic Study Workplace At home

10. Task 1.1 The Use of Spreadsheets Discuss for which purposes Excel can be useful in: Unit 1: Introduction to Spreadsheets Using Microsoft Excel 10 Academic Study Workplace At home Solve mathematical functions

11. Task 1.1 The Use of Spreadsheets Discuss for which purposes Excel can be useful in: Unit 1: Introduction to Spreadsheets Using Microsoft Excel 11 Academic Study Workplace At home Solve mathematical functions Do analysis of data from experiment

12. Task 1.1 The Use of Spreadsheets Discuss for which purposes Excel can be useful in: Unit 1: Introduction to Spreadsheets Using Microsoft Excel 12 Academic Study Workplace At home Solve mathematical functions Do analysis of data from experiment Draw graph of mathematical functions

13. Task 1.1 The Use of Spreadsheets Discuss for which purposes Excel can be useful in: Unit 1: Introduction to Spreadsheets Using Microsoft Excel 13 Academic Study Workplace At home Solve mathematical functions Do analysis of data from experiment Draw graph of mathematical functions Visual representation of data

14. Task 1.1 The Use of Spreadsheets Discuss for which purposes Excel can be useful in: Unit 1: Introduction to Spreadsheets Using Microsoft Excel 14 Academic Study Workplace At home Solve mathematical functions Do analysis of data from experiment Draw graph of mathematical functions Visual representation of data Manage budgets

15. Task 1.1 The Use of Spreadsheets Discuss for which purposes Excel can be useful in: Unit 1: Introduction to Spreadsheets Using Microsoft Excel 15 Academic Study Workplace At home Solve mathematical functions Do analysis of data from experiment Draw graph of mathematical functions Visual representation of data Manage budgets Business planning

16. Task 1.1 The Use of Spreadsheets Discuss for which purposes Excel can be useful in: Unit 1: Introduction to Spreadsheets Using Microsoft Excel 16 Academic Study Workplace At home Solve mathematical functions Do analysis of data from experiment Draw graph of mathematical functions Visual representation of data Manage budgets Business planning Manage inventories

17. Task 1.1 The Use of Spreadsheets Discuss for which purposes Excel can be useful in: Unit 1: Introduction to Spreadsheets Using Microsoft Excel 17 Academic Study Workplace At home Solve mathematical functions Do analysis of data from experiment Draw graph of mathematical functions Visual representation of data Manage budgets Business planning Manage inventories Calculate employee payrolls

18. Task 1.1 The Use of Spreadsheets Discuss for which purposes Excel can be useful in: Unit 1: Introduction to Spreadsheets Using Microsoft Excel 18 Academic Study Workplace At home Solve mathematical functions Do analysis of data from experiment Draw graph of mathematical functions Visual representation of data Manage budgets Business planning Manage inventories Calculate employee payrolls List house items

19. Task 1.1 The Use of Spreadsheets Discuss for which purposes Excel can be useful in: Unit 1: Introduction to Spreadsheets Using Microsoft Excel 19 Academic Study Workplace At home Solve mathematical functions Do analysis of data from experiment Draw graph of mathematical functions Visual representation of data Manage budgets Business planning Manage inventories Calculate employee payrolls List house items Manage budgets

20. Task 1.1 The Use of Spreadsheets Discuss for which purposes Excel can be useful in: Unit 1: Introduction to Spreadsheets Using Microsoft Excel 20 Academic Study Workplace At home Solve mathematical functions Do analysis of data from experiment Draw graph of mathematical functions Visual representation of data Manage budgets Business planning Manage inventories Calculate employee payrolls List house items Manage budgets Track expenses

21. Task 1.1 The Use of Spreadsheets Discuss for which purposes Excel can be useful in: Unit 1: Introduction to Spreadsheets Using Microsoft Excel 21 Academic Study Workplace At home Solve mathematical functions Do analysis of data from experiment Draw graph of mathematical functions Visual representation of data Manage budgets Business planning Manage inventories Calculate employee payrolls List house items Manage budgets Track expenses Keep notes

22. Part B. Understanding Excel Part of Excel Workbooks (v9.0 page 4) When Excel starts, it creates a new empty Workbook called Book 1. There are 3 major parts of Excel workbooks: Unit 1: Introduction to Spreadsheets Using Microsoft Excel 22 1. Worksheets 2. Charts 3. Lists Data = numbers and text

23. Part B. Understanding Excel Part of Excel Workbooks (v9.0 page 4) When Excel starts, it creates a new empty Workbook called Book 1. There are 3 major parts of Excel workbooks: Unit 1: Introduction to Spreadsheets Using Microsoft Excel 23 1. Worksheets 2. Charts 3. Lists Enter data Calculate data Manipulate data Analyze data Data = numbers and text

24. Part B. Understanding Excel Part of Excel Workbooks (v9.0 page 4) When Excel starts, it creates a new empty Workbook called Book 1. There are 3 major parts of Excel workbooks: Unit 1: Introduction to Spreadsheets Using Microsoft Excel 24 1. Worksheets 2. Charts 3. Lists Enter data Calculate data Manipulate data Analyze data Represents data pictorially, such as: Bar charts Pie charts Graphs, etc Data = numbers and text

25. Part B. Understanding Excel Part of Excel Workbooks (v9.0 page 4) When Excel starts, it creates a new empty Workbook called Book 1. There are 3 major parts of Excel workbooks: Unit 1: Introduction to Spreadsheets Using Microsoft Excel 25 1. Worksheets 2. Charts 3. Lists Enter data Calculate data Manipulate data Analyze data Represents data pictorially, such as: Bar charts Pie charts Graphs, etc Lists manage data, such as: Sorting Searching Replacing Data = numbers and text

26. Part C. Starting Excel Opening Excel (v9.0 page 5) Task 1.2 Practicing opening Excel Follow the instructions as mentioned in the student manual Unit 1: Introduction to Spreadsheets Using Microsoft Excel 26

27. Part D. The Excel Screen Features (v9.0 page 6) Unit 1: Introduction to Spreadsheets Using Microsoft Excel 27

28. Part D. The Excel Screen Features (v9.0 page 6) Unit 1: Introduction to Spreadsheets Using Microsoft Excel 28 Quick Access Toolbar

29. Part D. The Excel Screen Features (v9.0 page 6) Unit 1: Introduction to Spreadsheets Using Microsoft Excel 29 Quick Access Toolbar The Ribbon

30. Part D. The Excel Screen Features (v9.0 page 6) Unit 1: Introduction to Spreadsheets Using Microsoft Excel 30 Quick Access Toolbar The Ribbon Groups

31. Part D. The Excel Screen Features (v9.0 page 6) Unit 1: Introduction to Spreadsheets Using Microsoft Excel 31 Quick Access Toolbar The Ribbon Sheet Tabs Groups

32. Part D. The Excel Screen Features (v9.0 page 6) Unit 1: Introduction to Spreadsheets Using Microsoft Excel 32 Quick Access Toolbar The Ribbon Sheet Tabs Groups A workbook consists of one or more worksheets (=sheets)

33. Part D. The Excel Screen Features (v9.0 page 6) Unit 1: Introduction to Spreadsheets Using Microsoft Excel 33 Quick Access Toolbar The Ribbon Cell E3 Sheet Tabs Groups

34. Part D. The Excel Screen Features (v9.0 page 6) Unit 1: Introduction to Spreadsheets Using Microsoft Excel 34 Quick Access Toolbar The Ribbon Cell E3 Cell C12 Sheet Tabs Groups

35. Part D. The Excel Screen Features (v9.0 page 6) Unit 1: Introduction to Spreadsheets Using Microsoft Excel 35 Quick Access Toolbar The Ribbon Cell E3 Cell C12 Sheet Tabs Groups Label Value

36. Part D. The Excel Screen Features (v9.0 page 6) Unit 1: Introduction to Spreadsheets Using Microsoft Excel 36 Quick Access Toolbar The Ribbon Cell E3 Cell C12 Sheet Tabs Groups Label Value Formulas

37. Part D. The Excel Screen Features (v9.0 page 6) Unit 1: Introduction to Spreadsheets Using Microsoft Excel 37 Quick Access Toolbar The Ribbon Cell E3 Cell C12 Sheet Tabs Groups See page 7 for more details

38. Part D. The Excel Screen Customizing the Quick Access Toolbar (v9.0 page 8) Unit 1: Introduction to Spreadsheets Using Microsoft Excel 38 1. Click on the dropdown arrow

39. Part D. The Excel Screen Customizing the Quick Access Toolbar (v9.0 page 8) Unit 1: Introduction to Spreadsheets Using Microsoft Excel 39 1. Click on the dropdown arrow 2. Select “More Commands…”

40. Part D. The Excel Screen Customizing the Quick Access Toolbar (v9.0 page 8) Unit 1: Introduction to Spreadsheets Using Microsoft Excel 40 1. Click on the dropdown arrow 2. Select “More Commands…” Here you can Add or Remove icons Order the icons using the Move Up and Move Down arrows

41. Part E. Navigating in Excel Navigating Methods (v9.0 page 12) The keyboard Arrow Keys move the cursor and one cell at a time: 2. The mouse Use the mouse to select a particular cell Unit 1: Introduction to Spreadsheets Using Microsoft Excel 41

42. Part E. Navigating in Excel Navigating Methods (v9.0 page 12) Unit 1: Introduction to Spreadsheets Using Microsoft Excel 42 This is the active cell It is E5

43. Part E. Navigating in Excel Navigating Methods (v9.0 page 12) Unit 1: Introduction to Spreadsheets Using Microsoft Excel 43 The Name Box The Name Box displays the cell reference of the active cell . In this case: E5 This is the active cell It is E5

44. Part E. Navigating in Excel Navigating Methods (v9.0 page 12) Unit 1: Introduction to Spreadsheets Using Microsoft Excel 44 The Name Box The Name Box displays the cell reference of the active cell . In this case: E5 This is the active cell It is E5 To get to a particular cell quickly, you can type in the cell reference in the Name Box and press Enter. Example: type in E10

45. Part E. Navigating in Excel Task 1.3 Moving Around a Spreadsheet (v9.0 page 15) Follow the instructions as mentioned in the student manual Unit 1: Introduction to Spreadsheets Using Microsoft Excel 45

46. Part F. Selecting Data Selecting a cell, range, row, or column (v9.0 page 16) See teacher’s demo ( demo file: Unit 01 Resources\Part D. The Excel Screen (also for demo). xls Unit 1: Introduction to Spreadsheets Using Microsoft Excel 46

47. Part G. Entering Data Task 1.4 Producing a good worksheet (v9.0 page 17) Unit 1: Introduction to Spreadsheets Using Microsoft Excel 47 Number them to show the order

48. Part G. Entering Data Task 1.5 Entering Headings (v9.0 page 19) Follow the steps as mentioned in the student manual. Task 1.6 Adding Column Headings (v9.0 page 20) Follow the steps as mentioned in the student manual. Task 1.7 Entering Data (v9.0 page 21) Follow the steps as mentioned in the student manual. Unit 1: Introduction to Spreadsheets Using Microsoft Excel 48

49. Part H. Saving, Closing and Opening Spreadsheets Task 1.8 Naming and Saving file (v9.0 page 22 ) Follow the steps as mentioned in the student manual. Task 1.9 Closing a Spreadsheet (v9.0 page 24) Follow the steps as mentioned in the student manual. Task 1.10 Opening an Existing Spreadsheet (v9.0 page 24) Follow the steps as mentioned in the student manual. Unit 1: Introduction to Spreadsheets Using Microsoft Excel 49

50. Part I . Using AutoFill Understanding the AutoFill Feature (v9.0 page 25) See teacher’s demo (demo file: Unit 01 Resources\Part I. Using AutoFill Demo.xls ) Task 1.11 Using AutoFill (v9.0 page 27) Foll ow the steps as mentioned in the student manual Unit 1: Introduction to Spreadsheets Using Microsoft Excel 50

51. Part J. Getting Help Understanding the Help Menu (v9.0 page 28) Unit 1: Introduction to Spreadsheets Using Microsoft Excel 51 Help icon

52. Part J. Getting Help Understanding the Help Menu (v9.0 page 28) Unit 1: Introduction to Spreadsheets Using Microsoft Excel 52 Help icon Zoomed in

53. Part J. Getting Help Understanding the Help Menu (v9.0 page 28) Unit 1: Introduction to Spreadsheets Using Microsoft Excel 53 Help icon 1. Click on the Help icon

54. Part J. Getting Help Understanding the Help Menu (v9.0 page 28) Unit 1: Introduction to Spreadsheets Using Microsoft Excel 54 Help icon 1. Click on the Help icon

55. Part J. Getting Help Understanding the Help Menu (v9.0 page 28) Unit 1: Introduction to Spreadsheets Using Microsoft Excel 55 Help icon 1. Click on the Help icon 2. Type a query in the Search box

56. Part J. Getting Help Task 1.12 (v9.0 page 29) Foll ow the steps as mentioned in the student manual Unit 1: Introduction to Spreadsheets Using Microsoft Excel 56

57. Part J. Getting Help Task 1.12 (v9.0 page 29) Search for topics on formulas: “Operators” Unit 1: Introduction to Spreadsheets Using Microsoft Excel 57 Operators

58. Part J. Getting Help Task 1.12 (v9.0 page 29) Search for topics on formulas: “Operators” Unit 1: Introduction to Spreadsheets Using Microsoft Excel 58 Operators

59. Part J. Getting Help Task 1.12 (v9.0 page 29) Search for topics on formulas: “Operators” 2. Search for topics on: “Saving spreadsheets” Unit 1: Introduction to Spreadsheets Using Microsoft Excel 59 Operators Saving spreadsheets

60. Part J. Getting Help Task 1.12 (v9.0 page 29) Search for topics on formulas: “Operators” 2. Search for topics on: “Saving spreadsheets” Unit 1: Introduction to Spreadsheets Using Microsoft Excel 60 Operators Saving spreadsheets

61. Part K. Unit Review (v9.0 page 30) You have learned in this unit: Understanding Excel The Excel Screen Navigating in Excel Selecting and Entering Data Developing and Testing Spreadsheet Saving, Closing and Opening Spreadsheets Using AutoFill Getting Help Unit 1: Introduction to Spreadsheets Using Microsoft Excel 61

62. Part K. Unit Review (v9.0 page 30) You have learned in this unit: Understanding Excel The Excel Screen Navigating in Excel Selecting and Entering Data Developing and Testing Spreadsheet Saving, Closing and Opening Spreadsheets Using AutoFill Getting Help Unit 1: Introduction to Spreadsheets Using Microsoft Excel 62 Assessment Event 2: Project 1 will be distributed at the end of this unit.