9am to 9pm 7 days
COMDEX TRAINING CENTRE
EXCEL IN-A-DAY
ADVANCED
Take your Excel skills to the elite level
Unsure if the 'Advanced' level is suitable for you?
Take our free online Excel quiz.
$
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
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
Comdex Training Centre
157A Commercial Road
South Yarra 3141
Price
335 incl GST
$
Duration
Method
Level
Transport
Car Parking
One Day 9:30am - 5pm (approx.)
Classroom (Maximum 10, Avg 6)
Advanced
Tram, Train, Bus
Secure Commercial Off-street
Other EXCEL 'In-A-Day' Courses
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
-
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
-
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.
FAST TRACK ONE DAY SHORT COURSE | SMALL CLASSES | AWESOME TRAINERS | SOUTH YARRA COMDEX TRAINING CENTRE
Prefer to call? 1300 977 773
We make Excel Super Heroes!
Excel Advanced
Fast track to Excel Elite Level
Face to face, instructor led
(illustrative)
Comdex is a Certified Microsoft Innovative Educator
Microsoft Excel Advanced : Course Content
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
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
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.