Microsoft Excel - Advanced

The Microsoft Excel Advanced Course is aimed at users who wish to gain a comprehensive, in-depth knowledge of this application.

Microsoft Excel Pre-requisites

Delegates must have attended an Excel Intro/Inter course, or have an equivalent working knowledge of Excel.

Equipment Requirements

Learners should have a working version of Microsoft Excel installed on their device. While most participants use Office 365, the course content is applicable to other versions, though some features may vary.

Before attending, please ensure Excel is installed and ready to use.

Objectives

On successful completion of the course, delegates will be able to create and apply names ranges, understand Lookups, solve problems by using Goal Seek, working more efficiently with Pivot Tables, record macros and assign to buttons and link objects between different applications.

Course Content

• Short overview of intermediate topics
• Named Ranges
• Lookup Functions – VLOOKUP, MATCH, INDEX, INDIRECT
• Advanced Functions – OFFSET
• Date and Text
• Data Validation
• File Linking
• Protection
• Consolidation
• Macros
• Goal Seek, Using Solver and Goal See