Microsoft Excel Advanced

Introduction
This course is essential for the Excel 'Super User' who wants to explore the advanced functions of Excel including PivotTables and advanced templates. Post course support is available for 3 months following the course via Telephone or Email.

Course Content

• Auditing a worksheet
• Advanced database functionality; PivotTables and PivotCharts
• Data validation and conditional formatting
• Custom views, reports and scenarios
• Analysis tools; Goal Seek and Solver
• Creating and modifying toolbars
• Recording and running macros
• Advanced templates
• Using multiple workbooks; creating a workspace file
• Group work; protecting and sharing workbooks, tracking changes

Suitability

Existing Microsoft Excel users who wish to create and maintain more complex spreadsheets.
This course outline can be adapted to meet the needs of an organisation, department or team. Details and prices are available on request.

Assessment

No formal assessment

Duration

1 day (9:30am - 4:30pm)
Course notes and / or manuals are provided

Progression