Affirm Consulting Courses

Microsoft Excel - Level Two 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 increase your productivity by increasing your skills and knowledge using Microsoft Excel.

Learning Outcomes - on completion participants will be able to:

• Select cells within a workbook
• Use the fill method to copy data and formulas in a worksheet
• Use statistical functions
• Use financial functions
• Use lookup functions
• Nest functions to solve complex problems
• Work with workspaces
• Rearrange data order
• Use data list features
• Modify charts

Target Audience: This course is designed for participants who can create basic workbooks in Excel and who need to explore key concepts including lists and functions on a deeper level.

Prerequisites: Participants should have basic knowledge of creating workbooks, formulas funcitons and charts in Microsoft 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.