Microsoft Excel 2003 EXPert

Course Objectives:

• To learn Microsoft Office Word 2003 to an Expert level

Course Content:

• Create a template, workspace file, custom formats & conditional formatting

• Printed multiple workbooks, naming ranges, finding trends in data

• Create macros, set security levels for macros, add macros to toolbars

• Apply data validation rules, add input messages & error alerts

• Tracing precedents & dependents, tracing errors, advanced filter

• Summarise data with totals & subtotals DSUM & DAVERAGE

• Create a pivot table

• Use goal seek, and create what-if analysis

• Protect worksheets, apply and remove passwords, track changes

• Insert an embedded and linked objects,

• Save as a web page, mapping data in a workbook, saving as xml documents

Benefits

• A personal workbook to use as a reference guide on completion of the course

• The opportunity to gain the widely recognised Pitman Training Certificate