Close Window Print Outline Download PDF

Preparing Outline For Print

Raising the Bar | Austrlia's Leading Training Provider

EXCEL ADVANCED 2016

Course Overview

This is a one-day training course tailored to give intermediate Excel users a complete command of Microsoft Excel. Led by dedicated instructors who are fully versed in the Microsoft Office package, you’ll build upon your existing skills and embrace the more complex and technical aspects of Excel. We’ll teach you how to summarise large datasets quickly and confidently using PivotTables, protect data, validate data entry, audit formulas, implement logical functions, nest functions, utilise analytical tools such as Goal Seek and Data tables, create and manage templates as well as automating repetitive tasks using Macros and much more.

Raising the Bar sets a new industry standard for training courses. Our Excel training is delivered face-to-face by industry leading experts who use clear demonstrations and easy to follow instructions to help lead students to success. Our class sizes are small so that all students receive the required attention and achieve the best possible learning outcomes. We also supply all the equipment you need, so you can show up on the day without having to bring a thing. You’ll learn through clear hands-on activities and leave with brand new skills and knowledge of Excel that far exceeds your expectations.

At the end of the Excel Advanced course, you’ll receive a certificate of completion, a detailed course manual to work through at your own pace and the proficiency required to use Excel’s more complex functions.

Who Should Attend

The Excel Advanced Training Course is designed especially for students who already have an intermediate knowledge of Excel and want to expand their skills beyond creating and formatting basic spreadsheets. This course is perfect for users who want to gain confidence and acquire an advanced level knowledge of Excel. It’s also great for companies looking to master spreadsheet creation and streamline services.

Typically, students who attend this course already have a good level of confidence with Excel and know how to create professional and productive spreadsheets. This course is right for you if you’re a relatively experienced Excel user who wants to learn how to report data using PivotTables and learn advanced formula creation, data protection, formula auditing and automation through the use of Macros.

Raising the Bar’s public training courses are available throughout the year in our North Sydney training centre. For students in other cities, training sessions are available by appointment for companies and organisations in Sydney, Melbourne, Adelaide, Canberra, Brisbane and Perth.

Course Prerequisites

Our advanced course is designed for experienced Microsoft Excel users. Students should have completed our Excel Intermediate course or have equivalent skills creating and formatting spreadsheets at an intermediate level. You will also need general computer skills using the Windows operating system.

Raising the Bar
1300 937 782
www.rtb.com.au
Excel Advanced Course 2016

CREATING A PIVOTTABLE

Creating A PivotTable

Updating A PivotTable

PivotTables in Excel

ADVANCED PIVOTTABLE FEATURES

Working With Calculated Fields In A PivotTable

Value Field Calculation Options

Creating A Chart From A PivotTable

DATA VALIDATION AND PROTECTING DATA

Using Data Validation And Tracing Invalid Data

Protecting Worksheet Styles, Contents And Elements

Protecting Workbook Contents

Protecting Your Workbook From Unauthorised Users Access

WORKING WITH TEMPLATES

Creating A New Workbook Based On A Template

FORMULA AUDITING

Auditing Worksheets And Tracing Cell References

USING ADVANCED FUNCTIONS

Using Financial Functions

Editing Nested Functions

Using Logical Functions

ANALYSING DATA

The Goal Seek Tool

Exploring What-If Tables

Using Scenarios

Solver Tool

AUTOMATING ROUTINE TASKS WITH MACROS

Understanding Macros

Types of Macros

Editing A Macro

Using A Relative Reference Macro