Affirm Consulting Courses

Microsoft Excel - Level Three Outline

General Course Information: As courses can be customised to suit, condsider this as a general guide. Face-to-face courses are offered, but not restricted to, the Sydney metropolitan area. Other requirements will be considered on request.

Description: This course aims to further increase productivity by developing skills and knowledge using Microsoft Excel.

Learning Outcomes - on completion participants will be able to:

• Solve complex problems by nesting functions
• Run advanced filters on worksheet data
• Use goal seek
• Create and work with data tables
• Use scenarios
• Create and use PivotTables and PivotCharts
• Consolidate different data sources
• Link data between worksheets and workbooks
• Publish Excel data to Web pages
• Create and edit macros

Target Audience: This course is designed for participants with a good working knowledge of Microsoft Excel who wish to extend their understanding of the automated and time saving features.

Prerequisites: It is assumed in this course that participants have a good working knowledge of workbooks, lists, formulas and functions in Excel

Methodology: A hands-on approach is taken during this course. The exercises are designed to impart relevant skills and knowledge by having participants work through real-life examples and scenarios.