Microsoft Excel Training - Intermediate
Take your Excel skills to the next level.
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.
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
Prepare for the MO-201 Microsoft Excel Certification. Showcase your skills, gain confidence and boost your career with globally recognised credentials.
$1,430
inc GST
Cell Referencing & Names
Understanding Relative References
Understanding Absolute References
Creating Mixed References
Applying References in Formulas
Understanding Named Ranges
Creating and Managing Named Ranges
Using Named Ranges for Clarity and Efficiency
Referencing Data Across Worksheets and Workbooks
Logical Formulas
Using IF for Conditional Logic
Combining Conditions with AND and OR
Reversing Logic with NOT
Working with XOR Logic
Building Decision-Based Formulas
Automating Responses Based on Criteria
VLookup
Understanding Lookup Concepts
Setting Up a VLOOKUP Formula
Exact Match vs Approximate Match
Troubleshooting Common VLOOKUP Errors
Improving Reliability with Absolute References
Data Validation
Understanding Data Validation
Restricting Data Entry by Type
Creating Drop Down Lists
Building Custom Validation Rules
Creating Input Messages and Error Alerts
Maintaining Data Integrity
Protecting Workbooks and Sheets
Understanding Workbook and Sheet Protection
Locking and Unlocking Cells
Protecting a Worksheet
Protecting a Workbook Structure
Applying Password Protection
Managing Permissions and Preventing Unauthorized Changes
Date and Time Functions
Working with Dates and Times in Excel
Converting Between Date and Time Formats
Calculating Durations
Using TODAY and NOW
Creating and Using Timestamps
Automating Time-Based Analysis
Nesting Functions
Understanding Nested Formulas
Planning a Nested Function
Nesting IF Statements
Combining Logical and Lookup Functions
Building Complex Formulas Step by Step
Testing and Troubleshooting Nested Functions
Conditional and Number Formatting
Understanding Conditional Formatting
Highlighting Values Using Rules
Visualising Trends with Data Bars and Colour Scales
Using Icon Sets for Quick Interpretation
Applying Number Formats for Readability
Formatting for Dates, Currency, Percentages, and Decimals
Creating Charts
Selecting the Right Chart Type
Creating Charts from Data
Customising Chart Elements
Adding Titles, Labels, and Legends
Formatting Axes and Series
Creating Professional-Quality Visuals
Creating Tables
Understanding Excel Tables
Creating a Table from Data
Applying Table Styles
Sorting and Filtering Table Data
Using Table Features for Analysis
Working with Table Formulas and Structured References
Creating Pivot Tables
Understanding PivotTables
Creating a PivotTable from Source Data
Arranging Fields (Rows, Columns, Values, Filters)
Filtering and Sorting PivotTable Results
Formatting PivotTables for Clarity
Refreshing and Updating PivotTables
Using PivotTables to Identify Trends and Insights
Custom Number Formatting
Understanding Custom Number Formats
Creating Custom Formats for Numbers
Formatting Currency, Percentages, and Large Values
Custom Date and Time Formats
Displaying Text with Numbers
Improving Clarity in Financial and Operational Reporting
Will the Excel course content 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 in our basic Excel course online such as formula introduction, pivot tables, charting, and more. Moreover, we are happy to discuss advanced online Excel courses and incorporate specific examples tailored to your workplace tasks, ensuring that you receive relevant and practical training. Everyone excels with the right skillset brought to the workplace. Reach out to us to learn more about our training programs.
Which courses are available if I am working from home?
Currently, all of our Public Courses are available to be delivered remotely. Book any course as normal and you will receive login details and instructions the evening before your course. Our Microsoft Excel courses are taught in such a way that attending remotely or in person will leave you with the skills and knowledge to drive efficiency gains.
What is remote Training?
Remote training at Nexacu means our team of experienced trainers will deliver your training virtually. Students can access our usual classroom training courses via video conferencing, ask questions, participate in discussions, and share their screen with the trainer if they need help at any point in the course. Students have the same level of participation and access to the trainer as they would in classroom training sessions. Our Excel courses are all offered remotely.
How many students are typically in a Nexacu Excel Training Course?
While this varies from session to session, we typically have 5-8 students in an Excel course. We cap our classes at 10 students. This is to ensure the quality of training remains high and that all students can ask questions and engage in discussion.
I previously attended a course with Excel Consulting, will the training be similar?
Yes, we rebranded from Excel Consulting in October 2019. The business quickly outgrew its original name. Our new brand Nexacu better reflects our direction, continued innovation, and commitment to delivering next-level learning. We have always refined and continue to update our courses but retain our excellent trainers and deliver the same high-quality content. Nexacu is the leading Australian provider in training excel.
Where is the training held?
We are a national training company with offices in 7 cities around Australia; Melbourne, Sydney, Brisbane, Perth, Adelaide, Parramatta, and Canberra. You can also find us by typing this in your search bar: 'excel training course near me.' We also deliver Excel skills training in the workplace nationwide as well as offering remote training.
Excel Training in Brisbane
View Dates
Excel Training in Melbourne
View Dates
Excel Training in Sydney
View Dates
Excel Training in Adelaide
View Dates
Excel Training in Perth
View Dates
Excel Training in Canberra
View Dates
Excel Training in Remote Online
View 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
Prepare for the MO-201 Microsoft Excel Certification. Showcase your skills, gain confidence and boost your career with globally recognised credentials.
$1,430
inc GST
Excel Training in Brisbane
View Dates
Excel Training in Melbourne
View Dates
Excel Training in Sydney
View Dates
Excel Training in Adelaide
View Dates
Excel Training in Perth
View Dates
Excel Training in Canberra
View Dates
Excel Training in Remote Online
View Datesat Nexacu, we're proud to be the trusted training partner for hundreds of leading organisations accross Australia and New Zealand. From government departments to top corporates, we help teams upskill and succeed everyday
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
