top of page
Level 3 Excel

EXCEL IN-A-DAY

Excel Logo

ADVANCED

Excel super hero
Excel Skill Level
Skill level needle

Take your Excel skills to the elite level

About the course: Advanced Level
Excel Logo
Info
Infoformation
Course Dates
Training Dates
XLIAD3 Training Manual
Excel Training Manual

Unsure if the 'Advanced' level is suitable for you?
Take our free online Excel quiz.

Awesome Trainer Icon
Training Manual Icon
Guided Training Icon
Accredited Certificate Icon
Free Technical Support Icon

$

Resit Guarantee Icon
Hi-tech Icon
Refreshments Icon

One day's hands-on instructor led training

Printed step-by-step manuals & handouts

Small classes, personal attention

Accredited certificate: printed and electronic

Post course technical support i 

Full refund for cancellations i

Course resit guarantee i

Latest computer workstations (or BYO laptop)

All day refreshments and snacks

Excel Level 3 training dates

​Wednesday 20th March - Sold Out

More dates released soon!

(We're updating our course content to the very latest)

Excel Level 3 training dates

Available Dates 2024:

Excel Training Dates

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, audit and error check workbooks.

Analyse and present data using pivot tables, macros, charting, consolidate multiple workbooks.

New! Learn how to use ChatGPT (AI) to super charge your Excel productivity.

Prerequisites: Solid Excel skills to at least Level 2. 

Location

Location

Comdex Training Centre

157A Commercial Road

South Yarra 3141

Price

335 incl GST

$

Excel Course Duration
Excel Small Class
Excel Venue Transport

Duration

Method

Level

Transport

Car Parking

Excel Background

One Day  9:30am - 5pm (approx.)

Classroom (Maximum 10, Avg 6)

Advanced

Tram, Train, Bus

Secure Commercial Off-street

What's Included
Excel Training Bundle

Other EXCEL 'In-A-Day' Courses

Excel objectives
Excel Course Content

Course Objectives & Content

By the end of this course, users should be comfortable in both online and desktop environments, using automated functions, analysing and presenting data, auditing and checking work, working with multiple workbooks, and accessing and distributing data.

Advance your Excel skills to Elite Level

Excel Skill Meter
Skill meter needle
  • create, use and modify data tables

  • understand and create PivotTables

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

  • create summaries in your spreadsheets using subtotals

  • New!  Powering Excel with ChatGPT

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

  • modify Excel options

  • protect data in worksheets & workbooks

  • create and work with scenarios and the Scenario Manager

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

  • create and edit  PivotCharts

  • build stunning inter-active Dashboards

  • 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 interactive, hands-on sessions.

Excel Trainer
Down Button
Excel Screenshot
Rego-Excel 3

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

Excel Course Registration

Prefer to call? 1300 977 773

We make Excel Super Heroes!

Excel Advanced

Registration
comdex training

Fast track to Excel Elite Level

Face to face, instructor led

(illustrative)

Excel Trainer
Microsoft Innovative Educator

Comdex is a Certified Microsoft Innovative Educator

Exzcel Logo
Comdex Excel Training

Microsoft Excel Advanced : Course Content

Down Button

Excel 365 & Desktop Versions

  Accessing and Using Excel 365, 2021

  • About Excel Online

  • Logging into Microsoft (Office) 365

  • Edit Your File in the Excel Desktop Application

  • Identify Where Your Workbook is Saved

  • Save a Workbook Copy to Your Local Machine

  • Copy a Local Workbook to OneDrive

  Excel 365 / Desktop Differences

  • Features Not Available in Excel Online

  • Differences in Features Available in Both Excel

  • Online and The Excel Desktop Application

Worksheet Automation

  Managing Workbook Properties

  • View Workbook Properties

  • Using the Document Inspector

  Working with Macros

  • What is a Macro?

  • Recording a Macro

  • Saving a Macro

  • Inspecting and Editing Macros

  • Macro Security

  Create and Use a Template

  • Set the Custom Template Directory

  • Save a Workbook as a Template

  • Edit a Template

  • Open a New Workbook Based on a Template

  Use Data Validation in a Workbook

  • The Data Validation Dialog Box

  • Data Validation Settings

  • Input Messages

  • Error Alerts

 

Auditing and Error Checking

  Tracing Cells

  • Show Formulas

  • Trace Precedents and Dependents

  • Tracer Arrows

  Error Checking

  • Invalid Data

  • Formula Errors and Their Types

  • How to Check for Errors​

 

  Evaluating Formulas & Using the Watch Window

  • The Watch Window

  • The Camera Tool

  • The Evaluate Formula Tool

  Data List Outlines

  • Outlines

  • Auto Outline

  • The Subtotal Command

Data Analysis and Presentation

  Quick Analysis Tool

  • Access the Quick Analysis Tool

  • Quick Analysis Options

  Adding Sparklines

  • Sparkline Types

  • Inserting and Editing Sparklines

  • The Sparkline Tab

  What-If Analysis

  • The Scenario Manager

  • Using Goal Seek

  • Using Solver

  The Analysis ToolPak

  • Load the Analysis ToolPak

  • The Data Analysis Dialog Box

Working with Multiple Workbooks

  Arrange Workbooks

  • Arrange Workbooks for Viewing

  • View Workbooks Side by Side

  • Use Synchronous Scrolling

  Linking to Data in Multiple Workbooks

  • External References

  • Editing Links

  • Broken Links

  Consolidating Data

  • Data Consolidation

  • Consolidation Functions

  • Use the Consolidate Dialog Box

Exporting and Sourcing Data

  Exporting Data

  • Export File Format Options

  • Exporting Worksheet Data

  Using Data Sources

  • Data Sources in Excel

  • Importing a Delimited File

  • Using a Web Query

  Use a Microsoft Form for Data Collection

  • Insert a Microsoft Form into a Workbook

  • Add Questions

  • Preview a Form

  • Share a Form

  • Review the Results

Powering Excel with ChatGPT (AI)

  • ChatGPT Explained

  • Setup and Configuration

  • Using Excel with ChatGPT

  • Boosting Your Skills & Productivity

  • Automation & Time Saving Guide

New Ribbon
XLIAD3 Training Manual
Excel Training Manual

Fast Track Your Knowledge with Our Advanced Excel Courses in Melbourne

 

If you're ready to utilise Excel for high-end productivity and critical decision-making, enrol in the Comdex Advanced Excel Course.

 

Our advanced Excel courses are completed in person with accredited trainers in South Yarra. All class sizes are 10 people or less to ensure all participants receive personal, one-on-one attention and are set up for success. Best of all, our fast-track Excel courses can be completed in one day, meaning you will receive an Accredited Certificate of Completion and highly marketable Excel skills in just a few hours.

 

If you need to re-sit the advanced Excel course, a free re-sit option is available for all participants.

 

Register today as an individual or sign up multiple employees from your organisation. To learn more about our advanced Excel courses in Melbourne, explore the complete course content at the bottom of this page or download the brochure. You can also contact the Comdex team at any time.

 

Suddenly need to cancel. No worries! We offer free cancellation, even if it’s at the last minute.

 

Advanced Excel Courses at a Dedicated, High-Tech Computer Training Centre

 

Located in South Yarra, the Comdex Training Centre is fully equipped to help you master Microsoft Excel in just a day. We offer you the latest dual-screen Mac and PC workstations, and if you would prefer to learn on your own laptop, we are happy to accommodate you.

 

Our advanced Excel courses come with a hard copy training manual that’s yours to keep, and post-course support is also available.

 

The Comdex South Yarra location combines the centrality of the CBD with extra car parking and public transport options, making it easier than ever to attend face-to-face advanced Excel Courses in Melbourne. Register now or call us for more information.

 

comdex

puter

com

dex

terity

Comdex Logo
Up arrow

Back to Top

Ensure your success with our top-quality short courses at Comdex

At Comdex Training, we can offer fast-tracked courses to job seekers, students, or those already in the workforce. 
Whether you want to upskill or just enjoy learning something new, our trainers have a range of courses to suit your experience level.

Contact us


Reach out to our friendly team and we can point you in the right direction in terms of course times, and any questions you may have prior to commencement. If you want information about our facilities, trainers, or course materials, we can let you know what to expect.

Take our Skills Test


Taking our skills test is a comprehensive way of understanding your level of knowledge, and experience, and what course will suit you. You may be more suited to a Basic level course instead of the Advanced if you don’t have prior experience. No matter the results, you’re always welcome!

Choose your training plan


Are you on the search for a specific short course? From Excel and Xero to MYOB, Power BI, and Calxa, we provide an extensive selection of courses to boost your technical proficiency – quick smart!


Moreover, we offer individual, one-to-one training solutions for those who prefer  specifically tailored course content. We also provide customised group training sessions, which can be conducted either at your workplace or at our dedicated computer training centre. 

Take the course

Once registered, you’re ready to take the course! Our dedicated computer training centre is located conveniently near train, tram and bus - virtually at our door, and there’s ample commercial undercover car parking available.

Expert trainers


Our certified instructors boast a blend of extensive industry experience and in-depth product understanding, ensuring top-notch technical training at all times. We maintain a direct connection with the industry demands, frequently communicating and working together with software creators to guarantee that our content is always relevant, leading-edge, and of superior quality.

Contact us now at Comdex: Industry leaders in short course training


Step up your game with Comdex Training. Whether you're looking to sharpen your existing skills, aspire to a new job role, or bolster your employability for the future, we've got you covered. For those already active in the workforce, we provide comprehensive workplace training. Call 1300 977 773 to earn a new certification and enhance your professional portfolio.
 

bottom of page