Microsoft Excel Advance

Overview

On completion of this course, attendees will be able to create a variety of functions, present their data using PivotTables, analyse workbooks and data and record macros.

Target Student

This short course is designed for those who wish to understand how to analyse and present their data more efficiently as well as automate common tasks.
 

Prerequisites

​

Attendees should have attended our Excel Intermediate course or have equivalent knowledge.

Duration

​

1 day

​

​

Course Outline​

​

1. Working With Multiple Worksheets and Workbooks

• Topic A: Use Links and External References

• Topic B: Use 3-D References

• Topic C: Consolidate Data

​

2. Using Lookup Formulas and Formula Auditing

• Topic A: Use Lookup Functions

• Topic B: Trace Cells

• Topic C: Watch and Evaluate Formulas

​

3. Sharing and Protecting Workbooks

• Topic A: Collaborate on a Workbook

• Topic B: Protect Worksheets and Workbooks

​

4. Automating Workbook Functionality

• Topic A: Apply Data Validation

• Topic B: Search for Invalid Data and Formulas with Errors

​

5. Creating Sparklines

• Topic A: Create Sparklines