Excel 2007 Level 1


Full Description
Excel 2007 Level 1


This course introduces students to Microsoft Office Excel 2007. It covers basic spreadsheet features and acquaints students with Excel's tools. Students will learn to manage workbooks, work with cells and cell data, format and print worksheets, create and revise formulas, work with basic functions, use fills to save data entry time, and create and modify charts from worksheet data. They will also be introduced to the main interface changes of Microsoft Office 2007, such as the Ribbon, Quick Access toolbar, and the Mini toolbar. Finally, students will also learn how to access and use the Excel Help feature.


Outcomes:


This course will teach students how to:
  1. use basic spreadsheet features and acquaints students with Excel's tools
  2. learn to manage workbooks
  3. format and print worksheets
  4. work with cells and cell data
  5. create and revise formulas
  6. work with basic functions
  7. use fills to save data entry time
  8. create and modify charts from worksheet data


Assessment:


Student performance is assessed by cumulative training time, number of lessons completed and, where tests are available, the percent correct. Many courses also have a pre- and post-test where the pre-test will automatically assign only the lessons needed to achieve course mastery.


Course Information (see above or below lessons, outlines, activities, etc.)
Program Outline

This course contains 63 lessons
  1. Look At Microsoft Office Excel 2007
  2. Open Microsoft Office Excel
  3. Examine The Excel Window
  4. Understand The Quick Access Toolbar
  5. Open Workbooks
  6. View Worksheets
  7. Go To Specific Cells
  8. Examine Saving Options
  9. Close Workbooks
  10. Create New Workbooks
  11. Enter Cell Content
  12. Edit Cell Content
  13. Check Spelling
  14. Insert And Delete Cells
  15. Merge And Split Cells
  16. Insert And Delete Columns And Rows
  17. Modify Column Width And Row Height
  18. Look At The Office Clipboard Task Pane
  19. Examine Cut, Copy, And Paste
  20. Cut And Paste Data
  21. Copy And Paste Data
  22. Use Paste Special
  23. Move Cells And Ranges
  24. Understand Fills
  25. Fill A Series
  26. Fill By Example
  27. Understand Formulas
  28. Understand Cell References
  29. Use Cell References In Formulas
  30. Enter A Formula In The Formula Bar
  31. Copy And Edit Formulas
  32. Understand Functions
  33. Build Functions
  34. Use A Button To Find Sums And Averages
  35. Calculate Sums Using The Insert Function Dialog Box
  36. Calculate Averages Using Functions
  37. Create Minimum Functions
  38. Create Maximum Functions
  39. Understand The Mini Toolbar
  40. Understand Date And Number Formatting
  41. Format Numbers
  42. Change Text Alignment
  43. Wrap Text Within Cells
  44. Modify Text Appearance
  45. Apply Fill Colors To Cells
  46. Use The Format Painter
  47. Add Borders
  48. Examine Charts
  49. Create Charts
  50. Change Chart Types
  51. Apply Different Chart Styles
  52. Resize and Move Charts
  53. Modify Chart Titles, Legends, And Data Labels
  54. Understand Printing
  55. Preview Worksheets
  56. Change Page Orientation And Scaling
  57. Set Page Margins And Alignment
  58. Create Headers And Footers
  59. Select Print Options
  60. Set, Print, And Clear Print Areas
  61. Print Selections
  62. Print Worksheets And Workbooks
  63. Getting Help In Microsoft Office Excel

Contact Hours: 7