Microsoft® Excel 2003 Fundamentals CBT Training CD

Rating:
Summary: Microsoft® Excel 2003 Fundamentals CBT Training CD
Review: 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.