Microsoft Excel 2003: Advanced (2 day)

Course Overview

This course will cover all of the listed examination topics for the MOS: Expert Level for Excel 2003.

Some Microsoft courses can also be delivered in-house or at a venue of your choice, please click here to send an enquiry and find out more

Related Courses

• Microsoft Excel 2003: Visual Basic for Applications (VBA)
• Microsoft Excel 2003: Intermediate (1 day)
• Microsoft Excel 2003: Introduction for Beginners (1 day)
• Microsoft Excel 2003: Introduction for Beginners (2 day)
• Microsoft Excel 2003: Advanced (1 day)
• Microsoft Excel 2003: Intermediate (2 day)
• Microsoft Excel 2003: VB & Macros
• Microsoft Excel 2000 XP 2003: Advanced - Formulae and Functions
• Microsoft Excel 2003: Programming with VBA
• Microsoft Excel 2003: Existing User

Audience

Any PC user who wishes to attain MOS certification.

Prerequisites

Delegates must have previously attended the MOS Excel 2003 Core Level course of be familiar with all of the elements of the Core course objectives.

Course Outline

Organising and Analysing 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 summarise 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

Customising Excel

• Customise toolbars and menus
• Create, edit, and run macros
• Modify Excel default settings