Microsoft MOS Excel Certification Training
MOS Excel 2003 Course Overview
 This curriculum will prepare students for both the Microsoft Office Specialist and Microsoft
Office 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 courses: Microsoft Excel 2003 Fundamentals; Microsoft Excel 2003 Proficient User; Microsoft Excel 2003 Expert Part 1; Microsoft Excel 2003 Expert Part 2 Price $200.00
Learning Time Certification Training
12 to 16 Hours
Microsoft MOS Excel Fundamental Level Certification Course
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 MOS Excel Proficient Level Certification Course
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.
Microsoft Excel Expert Level 1 Certification Training Course
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.
Microsoft Excel Expert Level 1 Certification Training Course
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.
|
MOS Access 2003 CBT CD
|
$99.00
|
n75050d
|
|
|
MOS Word 2003- CBT CD
|
$99.00
|
n75022d
|
|
|
MOS Outlook 2003 CBT CD
|
$99.00
|
n75070d
|
|
|
MOS Excel 2003 CBT CD
|
$99.00
|
n75032d
|
|
|
MOS PowerPoint 2003 CBT CD
|
$99.00
|
n75041d
|
|
|
Microsoft FrontPage 2003 CBT CD
|
$99.00
|
n75091D
|
|
|
Complete Microsoft MOS 2003 Curriculum Training CD
Contains all the courses above
|
$299.00
|
n75000D
|
|
|
