Microsoft Excel 2003 Curriculum CBT Training CDs

Rating:
Summary: Microsoft Excel 2003 Curriculum CBT Training CDs
Review: Course Overview
This curriculum will prepare students for both the Microsoft Office Specialist and Microsoft Office Expert exams. Courses 75032 and 75033 map 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. Courses 75034 and 75035 map 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.


This curriculum consists of four Skill Builder courses:
75032 Microsoft Excel 2003 Fundamentals
75033 Microsoft Excel 2003 Proficient User
75034 Microsoft Excel 2003 Expert Part 1
75035 Microsoft Excel 2003 Expert Part 2

Learn To
See individual course descriptions for specific course objectives and scope.

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 Per Course
CEU credits: 0.70 CEUs

Language Options
American English, French, German

Total Learning Time
12 to 16 hours




Microsoft Excel 2003 Fundamentals
Course Overview
This course, along with course 75033, 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 open a template-based workbook.
To identify options for managing folders in the Save As dialog box.
To identify options for saving a workbook in another file format.
To identify options in the Format Cells dialog box.
To apply a style to a range of cells.
To identify options in the AutoFormat 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
German, Spanish, Dutch, French, US English

Total Learning Time
3 to 4 hours

Objectives
Unit 1: Basics of Excel 2003 1.5 - 2 hours
Open a template-based workbook.
Identify options for managing folders in the Save As dialog box.
Identify options for saving a workbook in another file format.
Identify Excel 2003 task panes.
Identify data types.
Identify options for clearing data.
Identify options in the Find and Replace dialog box.
Identify options in the Go To Special dialog box.
Sort data in ascending and descending order.
Identify options for filtering data using AutoFilter.
Enter a basic formula.
Identify methods for revising formulas.
Identify types of cell referencing in formulas.
Match AutoSum menu commands with their descriptions.
Identify categories in the Insert Function dialog box.

Unit 2: Formatting and Printing 1.5 - 2 hours
Identify options in the Format Cells dialog box.
Apply a style to a range of cells.
Identify options in the AutoFormat dialog box.
Identify options in Print Preview.
Set page breaks in a worksheet.
Identify options on the Page tab of the Page Setup dialog box.
Identify options on the Margins tab of the Page Setup dialog box.
Identify options on the Header/Footer tab of the Page Setup dialog box.
Identify options on the Sheet tab of the Page Setup dialog box.
Identify options in the Print dialog box.
Set a print area.




Microsoft Excel 2003 Proficient User
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.