Microsoft Office Specialist - Microsoft Excel XP Expert

Who Should Attend: This course is designed for people wishing to formalise their knowledge with a recognised qualification. This is the expert level exam for Microsoft Excel XP.

Pre-Requisits: That delegates have successfully completed and passed the MOUS MS Excel XP Core User qualification or have attend a MS Excel XP Advanced course with MCW and have used Excel for a minimum of 6 months.

Importing and Exporting Data
Import data from text files
Import from other applications
Import a table from a HTML file

Using Templates
Apply, edit and create templates

Using Multiple Workbooks
Using a workspace
Link workbooks

Formatting Numbers
Apply number formats
Create custom number formats
Use conditional formatting

Printing workbooks
Print and preview multiple worksheets
Use the report manager

Working with Named Ranges
Add and delete a named range
Use a named range in a formula
Use lookup functions (Hlookup or Vlookup)

Working with Toolbars
Hide and display toolbars
Customize a toolbar
Assign a macro to a command button

Auditing a Worksheet
Work with the Auditing Toolbar
Trace errors
Trace precedents and trace dependants

Displaying and Formatting Data
Apply conditional formats
Perform single and multi-level sorts
Use grouping and outlines
Use data forms
Use subtotalling
Apply data filters
Extract data
Query databases
Use data validation

Using Analysis Tools
Use PivotTable autoformat
Use Goal Seek
Create pivot chart reports
Work with scenarios
Use solver
Use data analysis and PivotTables
Create interactive PivotTables for the web
Add fields to a PivotTable using the web browser