The Microsoft Office Specialist Expert Certification Preparation course will cover the following topics in Word 2003 and Excel 2003:

Word 2003:

Formatting Content -

• Creating character and paragraph styles,
• Creating table and list styles,
• Controlling Orphans and widows,
• Keeping paragraphs together,
• Sizing, scaling, cropping, and rotating a graphic,
• Controlling contrast and brightness,
• Positioning a graphic in relation to the surrounding text,
• Inserting and modifying a new object,
• Inserting and modifying an object from a file,
• Importing data to create a chart,
• Linking a chart to data from another source.

Organizing Content -

• Sorting the items in a list,
• Sorting the data in a table,
• Using a formula in a table,
• Merging and splitting table cells,
• Changing the position and direction of cell contents,
• Modifying table properties,
• Inserting and modifying fields,
• Summarizing a document,
• Analyzing content readability,
• Inserting a bookmark,
• Using the document map and thumbnails,
• Specifying the data source,
• Preparing the form letter,
• Merging the data with the form letter,
• Creating and printing mailing labels,
• Creating an XML document based on a schema.

Formatting Documents -

• Setting up and modifying a form,
• Changing the background color and fill effect,
• Creating a watermark,
• Applying a document theme,
• Creating an index,
• Creating a table of contents, a table of figured, or a table of authorities,
• Inserting and formatting footnotes and endnotes,
• Inserting and formatting captions,
• Inserting cross references,
• Working with a master document and subdocuments.

Collaborating -

• Setting reviewer options,
• Setting balloon options,
• Opening and editing a web page,
• Creating a frames page,
• Creating and managing document versions,
• Protecting a form,
• Setting a password,
• Restricting editing and formatting,
• Authenticating a document with a digital signature,
• Inserting and editing advanced summary information,
• Inserting and editing custom information.

Customizing Word -

• Creating, running, and deleting a macro,
• Editing a macro,
• Creating a custom menu,
• Customizing a tool bar,
• Changing default file locations,
• Changing the custom dictionary,
• Modifying default font settings.

Back to the top.

Excel 2003:

Organizing and Analyzing Data -

• Calculating subtotals,
• Creating a criteria range for advanced filtering,
• Outlining a worksheet,
• Avoiding input errors,
• Creating and modifying a list,
• Creating and showing scenarios,
• Merging scenarios,
• Creating a scenario report,
• Using the Analysis ToolPak,
• Using the Goal Seek,
• Using a Data Table,
• Using Solver,
• Creating a PivotTable report,
• Plotting a PivotTable as a PivotChart,
• Looking up information,
• Creating formulas that use database functions,
• Fixing errors,
• Auditing a worksheet,
• Using error checking,
• Circling invalid data,
• Watching a cell,
• Evaluating a formula,
• Naming a cell or range,
• Using a name in a formula,
• Adding and deleting a data map,
• Setting up an XML worksheet and entering data.

Formatting Data and Content -

• Creating a custom number format,
• Monitoring a worksheet with conditional formatting,
• Controlling the contrast and brightness of a graphic,
• Sizing, scaling, cropping, and rotating a graphic,
• Formatting a chart,
• Formatting an organization chart.

Collaborating -

• Preventing changes to cell, worksheets and workbooks,
• Authenticating a workbook with a digital structure,
• Setting a password,
• Adjusting macro settings,
• Creating a shared workbook,
• Using a shared workbook,
• Comparing and merging workbooks,
• Tracking changes to a workbook,
• Accepting and rejecting changes.

Managing Data and Workbooks -

• Importing data from an external data source,
• Importing data from a web page,
• Exporting an XML data file,
• Publishing a worksheet as a web page,
• Saving and using a custom workbook template,
• Editing a workbook template,
• Consolidating data from two or more worksheets,
• Viewing and changing workbook properties.

Customizing Excel -

• Customizing a toolbar,
• Creating a custom menu,
• Creating, Running, and deleting a macro,
• Editing a macro,
• Changing the default number of worksheets, font settings, and file locations.

Back to the top.