Microsoft Office Specialist - Microsoft Excel 2003 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 2003.

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

Organizing and Analyzing Data
Use subtotals
Define and apply advanced filters
Group and outline data
Use data validation
Create and modify list ranges
Add, show, close, edit, merge, and summarize scenarios
Perform data analysis using automated tools
Create PivotTable and PivotChart reports
Use Lookup and Reference functions
Use Database functions
Trace formula precedents, dependents, and errors
Locate invalid data and formulas
Watch and evaluate formulas
Define, modify, and use named ranges
Structure workbooks using XML

Formatting Data and Content
Create and modify custom data formats
Use conditional formatting
Format and resize graphics
Format charts and diagrams

Collaborating
Protect cells, worksheets, and workbooks
Apply workbook security settings
Share workbooks
Merge workbooks
Track, accept, and reject changes to workbooks

Managing Data and Workbooks
Import data to Excel
Export data from Excel
Publish and edit Web worksheets and workbooks
Create and edit templates
Consolidate data
Define and modify workbook properties
Customizing Excel
Customize toolbars and menus
Create, edit, and run macros
Modify Excel default settings