Advanced Excel Course
Instructor-Led Advanced Excel Training Course
Learn new advanced Excel skills with our one-day course.
Using Excel for awhile and want to expand your knowledge? Explore new advanced features of Excel to improve your data analysis skills with our one-day advanced Excel course.
This course is available in-person or online.
Explore advanced data analysis tools.
Learn to use the full range of features available in Excel including data protection, data linking, tables, scenario manager, Pivot tabes, advanced filters, data validation and more.
Let us teach you some advanced excel skills.
Advanced Excel Course
Who is this course for?
This course is aimed at those who are experienced Excel users and wish to expand their skills to utilise some of the advanced features of Excel.
Learning Outcomes
At the completion of Microsoft Excel Advanced you should be able to:
- create a custom tab on the Ribbon
- protect data in worksheets and workbooks
- use data import and export functions
- use data linking to create more efficient workbooks
- use the data consolidation feature to combine data from several workbooks into one
- use group and outline options to collapse and expand data easily
- automatically add subtotals to a worksheet
- create and work with scenarios and the Scenario Manager
- use advanced filters to analyse data in a list
- construct and use PivotTables using some of the more advanced techniques
- create and edit a PivotChart
- insert and use text-based functions
- use a variety of data validation techniques
- create and record a macro in Excel
- create and use a range of controls in a worksheet
Prerequisites
Our advanced Excel course assumes reasonable knowledge of the software as well as a general understanding of personal computers and the Windows operating system environment.
Course Duration
Our advanced Excel course is run over one-day but can be customised to suit your needs.
Course Overview
Customise Excel
- Create a custom tab on the Ribbon
- Customise the Status Bar
Protecting Data
- Protect a worksheet
- Unprotect a worksheet
- Grant access to specific cells only
- Protect a Workbook
- Limit access to view a workbook
Import and Export
- View Data in a Delimited File
- Import Data using Power Query
- Access the Power Query Editor
- Insert a Web Query
- Embed Excel in a Word Document
- View Data Connections
Data Linking
- Link data between worksheets
- Link data between workbooks
- Update links between workbooks
Data Consolidation
- Consolidate Data with identical layouts
- Create a linked consolidation
- Consolidating data using the SUM function
Group and Outline
- Create an automatic outline
- Working with an outline
- Creating a manual group
- Grouping by columns
Subtotals
- Insert a Subtotals
- Remove a Subtotal
- Create a Nested Subtotal
- Copy Subtotal Data
Scenarios
- Create a Scenario
- Display each Scenario when needed
- Use Named Ranges in Scenarios
- Create a Scenario Summary Report
Advanced Filters
- Use an Advanced Filter
- Extracting data with advanced filters
- Use Formulas in criteria
- Use Wildcards in criteria
- Clear an Advanced Filter
PivotTable Features
- Insert a PivotTable
- Add Fields to a PivotTable
- Use SUM and COUNT in a PivotTable
- Format PivotTable Values
- Display the percentage of total
- Sort in a PivotTable
- Drill-down Data in a PivotTable
- Create Custom Field Names
- Customise Subtotals and Grand Totals
- Group Data in a PivotTable
- Create a Calculated Field
- Insert a PivotTable Slicer
- Refresh a PivotTable
PivotCharts
- Insert a PivotChart
- Define the PivotChart structure
- Change the PivotChart type
- Move a PivotChart
Data Validation
- Apply Data Validation to Text/Numbers
- Create a drop-down list
- Customise the Input message
- Customise the Error message
- Circling invalid data
Macros
- Set Macro Security
- Record a simple Macro
- Run a Macro
- Edit or Delete a Macro
Controls
- Insert a Combo Box Control
- Insert a Spin Button Control
- Insert a Group Box Control
- Protect a Worksheet with Controls
Course Pricing
Our bespoke training courses allow you to pick and choose the content for your session. We provide a cost-effective way of training small teams or larger groups.
Pricing as of 1st April 2024. All prices are including GST.
| Number of participants |
In-Person* Cost per day |
Online Cost per day |
|---|---|---|
| 1 participant | $660.00 inc GST | $605.00 inc GST |
| 2 participants | $836.00 inc GST | $781.00 inc GST |
| 3 participants | $1,012.00 inc GST | $957.00 inc GST |
| 4 participants | $1,188.00 inc GST | $1,133.00 inc GST |
| 5 participants | $1,364.00 inc GST | $1,309.00 inc GST |
| 6 participants | $1,540.00 inc GST | $1,485.00 inc GST |
Contact us for pricing with 6+ participants.
* Within 50km driving distance from NSW 2567. Additional travel costs may apply outside this distance.
Course Inclusions
Skills Analysis
Take advantage of our free online skills analysis prior to your training to ensure have are undertaking the correct course.
Certificate
After completing the course you’ll receive a certificate to show off your new-found knowledge and skills.
We come to you
To save your business time, money and unnecessary travel, we come to you, delivering our training at your premises.
Hands-on training
We’re big believers in hands-on learning so you’ll be on a computer and building your skills in real-time.
Email Support
Access unlimited support following your training course to build on your learning and ask any burning questions.
Real-world examples
You'll work through real-world examples to reinforce learning and increase your confidence.
Related Courses
Not quite ready to undertake an advanced Excel course? Check out our other Excel course options.
Excel Introduction
- 1 day course duration
Excel Intermediate
- 1 day course duration