print
Course Name
Microsoft Office Excel 2003 Level 1

Contact Hours: 24
Course Description
PIN code provided for this course allows unlimited on-line access for 90 days. This course is designed to introduce students to basic spreadsheet features and acquaints students with Excel`s tools by using real-life scenarios and projects. Students will learn to manage workbooks, work with cells and cell data, format and print worksheets, create and revise formulas, and create charts from worksheet data. These Excel skills are taught using concepts, examples, and interactive steps.
Outcome
Upon completion of this course, students will be able to:

  • Open, view, and navigate within workbooks
  • Enter and edit cell content
  • Add and delete rows and columns
  • Move and copy data, including using automatic fills
  • Use cell references and formulas to calculate data
  • Build and insert functions
  • Format cells
  • Work with charts
  • Print 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.
Outline

  1. Understand Microsoft Office Excel 2003
  2. Open Microsoft Office Excel 2003
  3. Examine The Excel Window
  4. Open Workbooks -- View Worksheets
  5. Go To Specific Cells
  6. Save Workbooks In New Folders
  7. Close Workbooks
  8. Use The Task Pane To Create Workbooks
  9. Enter Cell Content
  10. Edit Cell Content
  11. Check Spelling
  12. Insert And Delete Cells
  13. Merge And Split Cells
  14. Insert And Delete Columns And Rows
  15. Modify Column Width And Row Height
  16. Look At The Clipboard Task Pane
  17. Examine Cut, Copy, And Paste
  18. Cut And Paste Data
  19. Copy And Paste Data
  20. Use Paste Special -- Move Cells And Ranges
  21. Understand Fills
  22. Fill A Series
  23. Fill By Example
  24. Understand Formulas
  25. Understand Cell References
  26. Use Cell References In Formulas
  27. Enter A Formula In The Formula Bar
  28. Copy And Edit Formulas
  29. Understand Functions
  30. Build Functions
  31. Look At Function Argument ScreenTips
  32. Use AutoSum And AutoCalculate
  33. Calculate Sums Using The Insert Function
  34. Calculate Averages Using The Insert Function
  35. Create Minimum Functions
  36. Create Maximum Functions
  37. Understand Date And Number Formatting -
  38. Format Numbers -- Change Text Alignment
  39. Wrap Text Within Cells
  40. Modify Text Appearance -
  41. Apply Shading -- Use The Format Painter
  42. Use Border Drawing -- Examine Charts
  43. Use The Chart Wizard -- Change Chart Types
  44. Elevate, Rotate, Resize, And Position Charts
  45. Edit And Resize Chart Titles -- Understand Printing -
  46. Preview Worksheets
  47. Change Page Orientation And Scaling
  48. Set Page Margins And Alignment
  49. Create Headers And Footers
  50. Select Print Options -
  51. Set, Print, And Clear Print Areas
  52.  Print Selections
  53. Print Worksheets And Workbooks
  54. Examine The Help Task Pane -- Ask Help A Question
  55. Look At The Office Assistant