Select your country to view prices and course dates.
Microsoft Excel Training - Intermediate
Take your Excel skills to the next level.
Take your Excel skills to the next level.
4.74
All courses available in-class or remotely.
To attend remotely, select "Remote Online" as your location on book now.
Gain valuable skills in Excel that will enable you to work more efficiently, effectively, and impressively with your data. Our Excel Intermediate course will teach you how to expertly organize, analyze and present data through the use of complex formulas, functions, dynamic charts, and reports. You'll also be introduced to advanced features such as pivot tables, conditional formatting, defined names, and data validation. These key concepts are highly relevant for the workplace and will help you stand out from the competition. As the leading provider of intermediate Excel courses, Nexacu offers a comprehensive course outline designed to elevate your skills to the next level. View the full Excel Intermediate course outline below.
By the end of this course, participants will be able to:
You should be familiar with basic Excel skills such as formulas, formatting, and spreadsheet navigation, or have completed the Excel Beginner course.
Select your country to view prices, and course dates.
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 AdvancedMaster advanced Excel tools including dynamic arrays, named ranges, structured references and high-level data analysis techniques.
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.
A$1,430
inc GST
Setting Excel Options
Understanding Excel Options
Personalising Excel
Setting the Default Font
Setting Formula Options
Understanding Save Options
Setting Save Options
Setting the Default File Location
Setting Advanced Options
Formula Referencing
Absolute Versus Relative
Referencing Relative Formulas
Problems With Relative Formulas
Creating Absolute References
Creating Mixed References
Filling Data
Understanding Filling
Extracting With Flash Fill
More Complex Flash Fill Extractions
Extracting Dates and Numbers
Defined Names
Understanding Defined Names
Defining Names From Worksheet Labels
Using Names in Typed Formulas
Applying Names to Existing Formulas
Creating Names Using the Name Box
Using Names to Select Ranges
Pasting Defined Names Into Formulas
Defining Names for Constant Values
Creating Names From a Selection
Scoping Names to a Worksheet
Using the Name Manager
Documenting Defined Names
Essential Functions
Worksheet Functions
Using IF With Text
Using IF With Numbers
Nesting IF Functions
The VLOOKUP Function
Using Counting Functions
The ROUND Function
Rounding Up and Rounding Down
Manipulative Functions
The MOD Function
The TODAY Function
The NOW Function
The DATE Function
The PMT Function
Complex Formulas
Scoping a Formula
Long-Hand Formulas
Preparing for Complex Formulas
Creating the Base Formula
Adding More Operations
Editing a Complex Formula
Adding More Complexity
Copying Nested Functions
Switching to Manual Recalculation
Pasting Values From Formulas
Documenting Formulas
Number Formatting Techniques
Applying Alternate Currencies
Applying Alternate Date Formats
Formatting Clock Time
Formatting Calculated Time
Understanding Number Formatting
Understanding Format Codes
Creating Descriptive Custom Formats
Custom Formatting Large Numbers
Custom Formatting for Fractions
Padding Numbers Using Custom Formatting
Aligning Numbers Using Custom Formats
Customising the Display of Negative Values
Conditional Formatting
Understanding Conditional Formatting
Formatting Cells Containing Values
Clearing Conditional Formatting
More Cell Formatting Options
Top Ten Items
More Top and Bottom Formatting Options
Working With Data Bars
Working With Colour Scales
Conditional Formatting (cont.)
Working With Icon Sets
Understanding Sparklines
Creating Sparklines
Editing Sparklines
Creating Custom Rules
The Conditional Formatting Rules Manager
Managing Rules
Clearing Rules
Validating Data
Understanding Data Validation
Creating a Number Range Validation
Testing a Validation
Creating an Input Message
Creating an Error Message
Creating a Drop Down List
Using Formulas as Validation Criteria
Circling Invalid Data
Removing Invalid Circles
Copying Validation Settings
Data Linking
Understanding Data Linking
Linking Between Worksheets
Linking Between Workbooks
Updating Links Between Workbooks
Using Names to Link Between Workbooks
Goal Seeking
Understanding Goal Seeking
Using Goal Seek
Worksheet Tables
Understanding Tables
Creating a Table From Scratch
Working With Table Styles
Inserting Table Columns
Removing Table Columns
Converting a Table to a Range
Creating a Table From Data
Inserting or Deleting Table Records
Removing Duplicates
Sorting Tables
Filtering Tables
Renaming a Table
Splitting a Table
Deleting a Table
PivotTables
Understanding Pivot Tables
Recommended Pivot Tables
Creating Your Own PivotTable
Defining the PivotTable
Structure
Filtering a PivotTable
Clearing a Report Filter
Switching PivotTable Fields
Formatting a PivotTable
Understanding Slicers
Creating Slicers
Inserting a Timeline Filter
Chart Elements
Understanding Chart Elements
Adding a Chart Title
Adding Axes Titles
Repositioning the Legend
Showing Data Labels
Showing Gridlines
Formatting the Chart Area
Adding a Trendline
Adding Error Bars
Adding a Data Table
GoTo Special
Finding Constants
Finding Formulas
Finding Blanks
Supplementary Content
SUMIF Functions
Special Pasting
Finding and Replacing
Text Functions
Financial Functions
Grouping and Outlining
Summarising and Subtotalling
Chart Object Formatting
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 AdvancedMaster advanced Excel tools including dynamic arrays, named ranges, structured references and high-level data analysis techniques.
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.
A$1,430
inc GST
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
Valued by Individuals
Australia
New Zealand
Singapore
Hong Kong
Malaysia
Philippines
Thailand
Indonesia