Excel Banner.jpg
Excel Superhero.png
Excel 3d Spreadsheet Reversed 1000.png

Master the world's most popular spreadsheet.

ADVANCED

Level 3

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. 

About the Course: Advanced Level

9:30am to 4:30pm

Available dates

►​​  Coming soon!

Dates
  • 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

This course is ideal for
In this 1 day course you'll

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

Info
Excel Logo white.png
comdex training

Fast track to Excel Elite Level

Face to face, instructor led

(illustrative)

Excel Trainer

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.

Course Content
Excel Logo white.png

comdex training

Comdex is a Certified Microsoft Innovative Educator

Credentials EXCEL.png
Excel Trainer

Matt

Excel Trainer

Vanessa

 
excel spreadsheet
Excel In-A-Day: Advanced Course Registration
Excel Logo white.png

  FAST TRACK ONE DAY SHORT COURSE  |  SMALL CLASSES  |  AWESOME TRAINERS  |  SOUTH YARRA COMDEX TRAINING CENTRE  

Teacher Excel

Julie

Other EXCEL 'In-A-Day' Courses

excel logo.png

comdex

Triangle_edited.png
Comdex Logo Small.png

puter

com

dex

terity

ApprehensiveHorribleHorsemouse-size_rest

Back to Top