Take your Excel skills to the elite level.

​

Building on your solid excel experience, our Advanced Excel course will elevate your skill set to rarefied heights. Learn how to use Excel's high end productivity and critical decision tools. Create advanced formulas, import and export data. Create and use look-ups and queries, pivot tables, macros, charting, consolidations.

​

Prerequisites: Solid Excel skills to at least Level 2. 

9:30am to 4:30pm

Available dates

​

►​​  Coming soon!

• experienced Excel users who want to advance their skills to elite level

• potential Power BI users who want a firm grounding in Excel's data mining and reporting features.

​​

​

​

​

• learn about Excel's powerful data aggregation, management and reporting tools

• see how macros can automate tasks from mundane to complex

• advance your financial modelling skills to elite level

• start building powerful and interactive dashboards

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 Advanced

Instructor led, face to face

Skills equivalent to Level 2

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

Advance your Excel skills to elite level

• modify Excel options

• protect data in worksheets and workbooks

• import data into Excel and export data from Excel

• use data linking to create more efficient workbooks

• group cells and use outlines to manipulate the worksheet

• create summaries in your spreadsheets using subtotals

• use the Data Consolidation feature to combine data from several workbooks into one

• create, use and modify data tables

• create and work with scenarios and the Scenario Manager

• understand and create simple PivotTables

• construct and operate PivotTables using some of the more advanced techniques

• create and edit  PivotCharts

• use advanced filters to analyse data in a list

• use a variety of data validation techniques

• create and use a range of controls in a worksheet

• share workbooks with other users

• create recorded macros in Excel

• Tips & Techniques

• Help & Support Resources

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

REGISTER HERE

Excel Basic

Excel Intermediate