Microsoft Excel. Unlock insights and tell the story in your data.

This short course focuses on more advanced features beyond the Microsoft Excel Course: Level 2. Advanced analysis tools including data linking, data consolidation and outlining and summarising are covered, as are PivotTables, Lookup Functions and some key automation features such as macros. Learn how to import data, create Data Tables and Scenarios for What If analysis, techniques to validate data, and create form controls such as List and Combo Boxes to make data entry easier.

We encourage you to use the CCE Excel level self-assessment tool if you are unsure which course level to enrol in.

Aims

This course aims to provide experienced Excel users with proficient skills in developing more complex formulas, list analysis using a variety of tools and creating simple macros as well as features and tips to assist efficiency.

Outcomes

By the end of this course, you should be able to:

• modify Excel options
• import data into Excel and export data from Excel
• use data linking to create more efficient workbooks
• group cells and use outlines to manipulate the worksheet
• create summaries in your spreadsheets using subtotals
• use a range of lookup and reference functions
• use the Data Consolidation feature to combine data from several workbooks into one
• create, use and