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 ;
|
|
|
|
|