Microsoft® Excel 2003 Expert Part 1 CBT Training CD

Rating:
Summary: Microsoft® Excel 2003 Expert Part 1 CBT Training CD
Review: Course Overview
This course, along with course 75035, 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 format a worksheet.
To manipulate a graphic.
To manage Excel templates.
To secure a workbook.
To share a workbook.
To import data to Excel.
To export data from Excel.
To group, outline, and consolidate data from two or more worksheets in Excel.

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
French, Spanish, Dutch, German, US English

Total Learning Time
3 to 4 hours

Objectives
Unit 1: Formatting Worksheets and Graphics 0.5 - 1 hour
Format a worksheet.
Manipulate a graphic.

Unit 2: Using Templates and Securing Workbooks 0.5 - 1 hour
Manage Excel templates.
Secure a workbook.

Unit 3: Working with Shared Workbooks 1 hour
Share a workbook.

Unit 4: Transferring and Managing Data 1 hour
Export data from Excel.
Group, outline, and consolidate data from two or more worksheets in Excel.
Create a PivotTable and a PivotChart report.
Import data to Excel.
Use a list range and an advanced filter.