Part time MOS - Excel Expert

MOS Excel Expert 2003
MICROSOFT OFFICE SPECIALIST 2003

Type of learning:
Instructor lead at DBIC

Duration:
2 day intensive

Times/dates:

Cost:

Target Audience
This course is aimed at employees whose responsibilities include the use of Microsoft Excel to create, modify, share, and revise workbooks using templates, automated procedures, and the Web, and retrieve, analyse, and summarise data in organisations of every size.

Benefits to the Employer
Certification in the most commonly used desktop applications increases employee productivity, decreases the time needed to complete tasks and can also decrease demand on valuable IT support resources. Staff will respond to your commitment to their career development and are likely to become more motivated to perform well and be dedicated to the business.

Pre-Course Requirements
Delegates should already possess excellent IT skills and have very good knowledge of Excel 2003.

Course Aims
The course provides delegates with the necessary skills to successfully achieve accredited certification in Excel Expert 2003.

Course Outline
Academy instructors have undertaken the MOS programme, have several years teaching experience and have achieved MOS Master Instructor Certification.

To become a Microsoft Office Specialist (MOS) in Microsoft Excel Expert 2003 an individual has to demonstrate proficient use of the application during a performance-based on-line exam.

The topics covered are as follows:

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 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

· Customise toolbars and menus

· Create, edit, and run macros

· Modify Excel default settings

For further information please contact:

Doncaster College ICTAcademy

Doncaster Business Innovation Centre

Ten Pound Walk

Doncaster

DN4 5HX