0.5 - day course
Print this page
Course Code: S130en
Who should attend?
This course is intended for participants who wish to upgrade their skills to Excel 2003.
Prerequisites
Spreadsheet concepts and tasks to an intermediate level
Course Objectives
Upon completion of the course, participants will be able to accomplish the following:
  • Recognize new interface features of the Excel 2003 environment and know their purpose
  • Use the new editing features in Excel 2003, including the Office Clipboard and Smart Tags
  • Use formula features in Excel 2003, including viewing ScreenTips for function arguments, use the expanded AutoSum feature, use function reference examples, use the enhanced edit links dialog box, plus use the Watch Window
  • Use formatting features in Microsoft Excel 2003, including using the vertical alignment buttons, unmerge cells, use the drawing borders features, plus create an organizational chart
  • Use the various tools in Excel 2003, including importing Web pages, use the Text to Speech feature, and use Help to learn about new features
  • New Interface Features
Course Content  
    New Editing Features
    Office Clipboard ; Comparing Workbooks Side-by-Side ; Context-Sensitive Smart Tags ; AutoCorrect Options Smart Tag ; Paste Options Smart Tag ; Auto Fill Options Smart Tag ; Trace Error Options Smart Tag ; Insert Options Smart Tag ;
    New Formula Features
    ScreenTips for Function Arguments ; Expanded AutoSum ; Recommended Functions in the Function Wizard ; Enhanced Edit Links ; The Watch Window ;
    New Formatting Features
    Vertical Alignment ; Unmerging Cells ; Drawing Borders ; Diagrams ;
    New Import, Speech, and Tools Features
    Import Query Data from Web Pages ; Text To Speech Feature ; Where to Learn About New Features ;