Advanced Excel Courses
Reach new heights with Excel Advanced Training
Reach new heights with Excel Advanced Training
5.00
All courses are available in-class or remotely.
To attend remotely, select "Remote Online" as your location on book now.
In this Excel training, participants will explore advanced data management and analysis techniques. The course covers structured references, focusing on cell-based versus table-based references and table elements. Attendees will learn to create and manage named ranges for more dynamic spreadsheets. The session also includes dynamic array functions like UNIQUE, SORT, and XLOOKUP. PivotTables will be emphasized, with guidance on creating, customizing, and extracting insights from data sets. Finally, the training introduces advanced functions, including Date, Information, Math, Statistical, and Text functions, to handle various data analysis tasks proficiently.
This course introduces functions that require an Microsoft Office 365 version of excel. These tools have no equivalent in prior Excel Versions.
By the end of this course, participants will be able to:
You should be confident with Excel basics and have completed the Beginner and Intermediate courses or have similar experience.
Excel BeginnerLearn how to manage, analyse and share everyday data using Excel spreadsheets. Perfect for new users or those looking to build a solid foundation.
Excel IntermediateTake your Excel skills to the next level with complex formulas, conditional formatting, PivotTables, data validation and more.
Excel ExpertBecome a power user with advanced data wrangling, automation and integration using Excel and the Power Platform.
Excel Tables and Pivot TablesLearn to build powerful reports with PivotTables, data consolidation and visualisation techniques in just one day.
Excel Macro MasteryAutomate your workflow with Excel macros. Learn to record, edit and run simple macros to boost efficiency and save time.
MO-201 Excel Certification
Become a Microsoft Excel certified. Attend our Nexacu Excel courses remotely, choose to sit the Excel Specialist or Excel Expert exam and get Microsoft Certified.
RP 15.500K
Structured References
Cell-based vs table-based references
Table elements
Structured reference for a row
Structured reference for a Range
Structured reference for Table Totals
Union operator (,)
Named Ranges
Creating Named ranges
Creating Named ranges using the Name Box
Creating Named ranges using the Create from Selection
Applying names to Tables
Creating Ranges for Data Validation
Editing named ranges – Single Cell
Editing named ranges - Range
Finding where named ranges are used
Deleting named ranges
Using names in a formula
Display a list of range names
Dynamic Array Functions
Function Arguments Dialogue Box
UNIQUE Function
SORT
FILTER Function
CHOOSECOLS
LOOKUP: INDEX MATCH
INDEX Function
Using XMATCH
SEARCH Mode
MATCH Function [LEGACY FUNCTION]
Using MATCH and INDEX together [LEGACY FUNCTION]
Nesting the MATCH and INDEX Functions
LOOKUP: CHOOSE SWITCH XLOOKUP
CHOOSE vs SWITCH
XLOOKUP
PivotTables
Creating Pivot Tables
Extracting data from the PivotTable
Filtering the PivotTable
Changing the calculation in the PivotTable
Creating PivotCharts
Adding Slicers
The Timeline Filter
Show Values As
Grouping Data
Report Layout in Pivot Tables
Totals in a Pivot Table
Calculations in a PivotTable
Report Filter Pages
Refresh the PivotTable
Advanced Functions
Date Functions
Information Functions
Maths and Statistical Functions
TEXT Functions (OPTIONAL)
Summary & Integration
Applying lookup functions in real-world scenarios
Combining array formulas with named ranges
Integrating PivotTables with structured data
Best practices for advanced Excel use
Will the content in these Excel courses be relevant for the workplace?
Absolutely! Our expertise lies in delivering hands-on training exercises that are applicable to all kinds of workplaces. We cover essential elements such as formula introduction, pivot tables, charting, and more. Moreover, we are happy to discuss and incorporate specific examples tailored to your workplace tasks, ensuring that you receive relevant and practical training. Reach out to us to learn more about our training programs.
How many students are typically in an Excel training course?
While this varies from session to session, we typically have 5-8 students in an Excel class. We cap our classes at 10 students to ensure the quality of training remains of the highest standard, and so all students can ask questions and engage in discussion.
What should I do to prepare for my online course?
You'll need to install the latest version of Excel and ensure you have the appropriate license to use it.
Our Excel Advanced course requires Excel 2016 or later. Windows standalone versions of Microsoft 365 subscription plans are also required.
Microsoft 365 subscription plans are required for the Excel Expert course. You will also need to download and install Power Automate Desktop.
The browser you use is very important. It is recommended you use Chrome, Edge, or Firefox. The latest version must also be installed. Note that Internet Explorer is not compatible with our delivery technologies.
Windows 10 is highly recommended as the operating system you use. If you are using an apple device, use Safari or a similar modern browser if you cannot use any of the browsers recommended above. Your training experience may diminish due to different features and appearances. Nexacu's trainers are unable to provide detailed guidance for macOS.
To download and unzip files, log in to your student portal. Click on the "Materials" tab and download your exercise files.
Extract your Exercise Files to the specified folder below:
To save files to the folder specified above create a folder called Exercise_Files_All_Courses on your computer (in This PC). Create another folder under this called Excel Exercise Files. All files should be unzipped or copied to this folder.
Excel BeginnerLearn how to manage, analyse and share everyday data using Excel spreadsheets. Perfect for new users or those looking to build a solid foundation.
Excel IntermediateTake your Excel skills to the next level with complex formulas, conditional formatting, PivotTables, data validation and more.
Excel ExpertBecome a power user with advanced data wrangling, automation and integration using Excel and the Power Platform.
Excel Tables and Pivot TablesLearn to build powerful reports with PivotTables, data consolidation and visualisation techniques in just one day.
Excel Macro MasteryAutomate your workflow with Excel macros. Learn to record, edit and run simple macros to boost efficiency and save time.
MO-201 Excel Certification
Become a Microsoft Excel certified. Attend our Nexacu Excel courses remotely, choose to sit the Excel Specialist or Excel Expert exam and get Microsoft Certified.
RP 15.500K
At Nexacu, we are proud to be the trusted training partner for hundreds of leading organisations across Australia, New Zealand, and around the world. From government agencies to multinational corporations, we help teams build practical skills and achieve real outcomes through expert-led training.
Students
4 & 5 Star Reviews
Google Reviews
Businesses Trust Nexacu
Custom workbook included with a step by step exercises
Learn with expert instructors, wherever you are
Australia
New Zealand
Singapore
Hong Kong
Malaysia
Philippines
Thailand