Advanced Excel Course

Instructor-Led Advanced Excel Courses

Learn new advanced Excel skills with our one-day course.

Using Excel for awhile and want to expand your knowledge? Explore new advanced features of Excel to improve your data analysis skills with our one-day advanced Excel course.

This course is available in-person or online.

Explore advanced data analysis tools.

Learn to use the full range of features available in Excel including data protection, data linking, tables, scenario manager, Pivot tabes, advanced filters, data validation and more.

What is a Pivot Table in Excel

Advanced Excel Course

Who is this course for?

This course is aimed at those who are experienced Excel users and wish to expand their skills to utilise some of the advanced features of Excel.

Learning Outcomes

At the completion of Microsoft Excel Advanced you should be able to:

Prerequisites

Our advanced Excel course assumes reasonable knowledge of the software as well as a general understanding of personal computers and the Windows operating system environment.

Course Duration

Our advanced Excel course is run over one-day but can be customised to suit your needs.

Course Overview

Protecting Data

Importing and Exporting

Data Linking

Group and Outline

Summarising and Subtotaling

Data Consolidation

Data Tables

Scenarios

PivotCharts

PivotTable Features

Advanced Filters

Validating Data

Controls

Sharing Workbooks

Macros

Course Inclusions

Skills Analysis

Take advantage of our free online skills analysis prior to your training to ensure have are undertaking the correct course.

Certificate

After completing the course you’ll receive a certificate to show off your new-found knowledge and skills.

We come to you

To save your business time, money and unnecessary travel, we come to you, delivering our training at your premises.

Hands-on training

We’re big believers in hands-on learning so you’ll be on a computer and building your skills in real-time.

Email Support

Access unlimited support following your training course to build on your learning and ask any burning questions.

Real-world examples

You'll work through real-world examples to reinforce learning and increase your confidence.

Customer Testimonials

Related Courses

Not quite ready to undertake an advanced Excel course? Check out our other Excel course options.

Microsoft Excel Courses

Excel Introduction

- 1 day course duration

Microsoft Excel Courses

Excel Intermediate

- 1 day course duration

Scroll to Top
Call Now Button