Expand on your Excel knowledge and learn how to create more productive workbooks with more complex formulas and functions.

​

Learn how to apply a range of number formatting and conditional formatting techniques, advanced formatting, charting and data interrogation and reporting.

9:30am to 4:30pm

Available dates

​

►​​  Monday 15 November 2021

►​​  Monday 22 November 2021

►​​  Monday 29 November 2021

Users who wish to extend their knowledge and skills beyond building simple workbooks, and learn how to create more productive workbooks.

​

It covers formulas and function techniques, advanced formatting and charting features and data manipulation tools like goal seeking​

​

​

​

• use a range powerful worksheet techniques 

• use the fill operations available to fill a data series

• apply a variety of page setup techniques

• apply advanced formatting techniques

• be introduced to building basic macros

• create more complex formulas and functions

• create and use defined names in a workbook

• apply conditional formatting to ranges in a worksheet

• use goal seeking to determine the values required to reach a desired result

• learn data validation applications

• create and work with tables and charts

Comdex Training Centre

157A Commercial Road

South Yarra 3141

Tram, Train, Bus

Commercial Offstreet

One Day - 9:30am to 4:30pm

$375 (concession available)

9 months

30 days

Nil

Yes, please call (2 or more persons)

​

Excel In-A-Day Intermediate

Instructor led, face to face

Equivalent of our Level 1 course

10 students (average 6)

PC & Mac Dual Screen

Yes, accredited

Bound, hardcopy - yours to keep

Available on all workstations

​

Online or telephone 1300 977 773

Venue

Location

​

Public Transport

Car Parking

Duration

​

Cost

Resit Guarantee

Email Support

Cancellation Fee

Group Discount

​

Coarse Name

Delivery Mode

Pre-requisites

Maximum No.

Computers

Certificate

Training Manual

Internet

All the key components to advance your Excel skills and productivity

• Worksheet Techniques

• Data Table Applications

• Page Setup Best Practice

• Formatting Designs

• Essential Query Functions

• Complex Formulas

• Defining & Using Range Names

• Advanced Formatting inc. Conditional

• Chart Elements

• Chart Object Formatting

• Pivot Tables

• Introduction to Macros

• Realtime linking data eg. share prices

• Audit Your Worksheet

• Tracing using Precedents/Dependents

• Fast Help Resources

• Handling Mass Data

• Tips and Tricks

Our skilled and experienced trainers will guide you through an interactive, hands-on session.

REGISTER HERE

Excel Basic

Excel Advanced