Microsoft Excel Training - Excel Tables and Pivot Tables
Harness the power of Pivot Tables and Excel analysis tools for comprehensive data management
Harness the power of Pivot Tables and Excel analysis tools for comprehensive data management
4.75
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.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
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
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
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 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 Parramatta
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 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
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 Parramatta
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
Resit your course for free within 6 Months
Valued by Individuals
