top of page

Microsoft Excel Advance

Course Overview
FREE Course Guide Download
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

bottom of page