Microsoft® Excel 2003 Proficient User CBT Training CD

Rating:
Summary: Microsoft® Excel 2003 Proficient User CBT Training CD
Review: Course Overview
This course, along with course 75032, maps to the Microsoft Office Specialist 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 cut, copy, and paste cell contents.
To identify options in the Paste Special dialog box.
To insert and delete cells.
To match steps in the Chart Wizard with their descriptions.
To identify options in the Format Chart Area dialog box.
To identify options in the Diagram Gallery dialog box.

Audience
The target audience will range from new users to power users, although you can expect that the vast majority 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
Dutch, Spanish, German, French, US English

Total Learning Time
3 to 4 hours

Objectives
Unit 1: Manipulating Workbook Elements 1.5 - 2 hours
Cut, copy, and paste cell contents.
Identify options in the Paste Special dialog box.
Insert and delete cells.
Identify Fill Handle commands.
Identify options for working with comments in cells.
Hide a row and a column..
Identify methods for sizing a row and a column.
Freeze a row and a column.
Insert a worksheet.
Identify formatting options on the Sheet menu.
Move a worksheet within a workbook by using the Edit menu.
Identify methods to split a worksheet.
Hide a workbook.
Identify options in the Arrange Windows dialog box.

Unit 2: Charts, Diagrams, and Drawing Objects 1.5 - 2 hours
Match steps in the Chart Wizard with their descriptions.
Identify options in the Format Chart Area dialog box.
Identify options in the Diagram Gallery dialog box.
Identify options on the Diagram toolbar.
Identify types of AutoShapes.
Identify methods for manipulating AutoShapes.
Identify options in the Insert Hyperlink dialog box.
Preview a workbook as a Web page.
Identify options in the Publish Web Page dialog box.