Select your country to view prices and course dates.
Enhance your Excel proficiency with our Excel Tables and Pivot Tables course. This one-day workshop is meticulously designed for corporate professionals aiming to harness the full potential of Excel’s Pivot Tables and key analysis tools for data modelling and manipulation. Learn to create and filter PivotTable reports and charts, handle large data sets efficiently, summarise complex data, and ensure data accuracy through validation. This course equips you with the critical skills needed to excel in today's data-driven corporate environment.
Courses available in-class or remotely. To attend remotely, select "Remote Online" as your location when booking.
You will learn how to:
You should have completed the Excel Essentials or Intermediate course, or have equivalent experience. Familiarity with Named Ranges is an advantage.
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 IntermediateTake your Excel skills to the next level with complex formulas, conditional formatting, PivotTables, data validation and more.
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 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
Introduction to PivotTables
Creating and modifying PivotTable reports
Analysing data using PivotTables
Grouping field items for better data organisation
Building a PivotTable based on an Excel Table
Displaying and understanding source data in PivotTables
Filtering and sorting labels and data
Using Slicers and Timelines for advanced filtering
Sort and Filter Table Data
Sorting data using AutoFilter buttons or the Sort dialog box
Creating and applying Custom filters for specific data views
Subtotalling filtered lists for better data understanding
Working with Excel Tables
Understanding formatting and management with Excel Tables
Filtering data with Slicers for quick insights
Deleting duplicates using Conditional Formatting for data accuracy
Smart Charting Techniques
Creating and modifying PivotCharts for data visualisation
Adding a secondary axis and trendlines for enhanced analysis
Outlining Data
Using the Outline feature to summarise large worksheets
Displaying only the necessary totals for clear data presentation
Data Validation
Controlling data entry using Data Validation rules
Setting up various data validation settings for consistent data entry
Creating input and error messages to guide users
Circling and clearing invalid data entries in Excel
Locking cells with data validation to protect data integrity
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 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 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
