fbpx

Microsoft Excel Advanced

Course Description

Microsoft Excel Advanced is part of a 3-level study program. This course aims to extend participant’s skills and knowledge to protect worksheet data, perform advanced data operations using summarizing, data consolidation, filters and advanced PivotTable techniques, macros and much more.

Learning Outcomes

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

Prerequisites

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

Course Duration

The Microsoft Excel Advanced 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 you’re enrolled in the right course.

Certificate

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

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

There’s nothing better than working through real-world examples to reinforce learning and increase your confidence.

Course Pricing

Pricing as of 1st July 2019. All prices are exempt of GST. All prices are PER SESSION, not per person.

Number of participants Investment (per day)
1-on-1 Training $500.00
2-3 participants $650.00
4-6 participants $800.00
7-8 participants $950.00
9-10 participants $1,200.00

Above costs are for training conducted within the Sydney region and is subject to travel fees dependent on location. Pricing provides a guide only and will be confirmed at time of booking enquiry.

View other course outlines

Microsoft Excel Courses

Excel Introduction

- 1 day course duration

Microsoft Excel Courses

Excel Intermediate

- 1 day course duration

Call Now Button Scroll to Top