Microsoft® Excel 2003 Expert Part 2 CBT Training CD

Rating:
Summary: Microsoft® Excel 2003 Expert Part 2 CBT Training CD
Review: Course Overview
This course, along with course 75034, maps to the Microsoft Office Expert certification objectives for the Excel 2003 Expert exams. Learners completing these courses should be well prepared for the certification exams, and have a solid foundation in basic Excel skills.

Learn To
To manage a named range.
To manage a function in Excel.
To check data in Excel.
To use Evaluate Formula, cell Watch, and Data Validation.
To analyze and project data in Excel.
To modify default Excel settings.
To modify toolbars, menus, and workbook properties.
To create, edit, and run a macro.

Audience
The target audience will range from new users to power users. It is expected that the vast majority of learners will have at least had some exposure to previous versions of Excel. Fundamental PC and Windows skills are assumed.

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits
CEU credits: 0.70 CEUs

Language Options
German, Spanish, Dutch, French, US English

Total Learning Time
3 to 4 hours

Objectives
Unit 1: Managing Named Ranges and Functions 1 hour
Manage a named range.
Manage a function in Excel.

Unit 2: Auditing, Analyzing and Structuring Data 1 - 2 hours
Check data in Excel.
Use Evaluate Formula, cell Watch, and Data Validation.
Structure data using XML.
Analyze and project data in Excel.

Unit 3: Modifying Excel and Working with Macros 1 hour
Modify default Excel settings.
Modify toolbars, menus, and workbook properties.
Create, edit, and run a macro.