Excel - Level 3 (Advanced Data Analysis with Microsoft Excel)

Course Description

This course aims to increase your productivity by providing the skills and knowledge to use Microsoft Excel 2003 effectively.

Pre-Requisites

This course is designed for current Microsoft Excel users who can build basic workbooks. It is assumed that the user will know how to create and save a workbook, create formulas and use functions.

Outcomes

At the completion of this course, participants will be able to:

• protect data
• use Lookup functions
• nest functions to create complex formulas
• use advanced filters
• use data validation techniques
• use goal seeking
• create, use and modify data tables
• use the Scenario Manager
• create, modify and work with PivotTables
• group cells and use outlines
• use linking
• share workbooks with other users
• combine data using consolidation
• publish workbooks for the web
• create macros

On-Site Training

If you need training for three or more people, ask us about training at your site. You can enjoy the convenience of reduced travel cost and time, as well as a familiar environment for your staff. Additionally, we can customise the course for your business needs.

---

User Reviews

Click here to Read Reviews