Australia
New Zealand
Singapore
Malaysia
Philippines
Thailand
Indonesia
Microsoft Excel Training - Excel Tables and Pivot Tables - Expert
Harness the power of Pivot Tables and Excel analysis tools for comprehensive data management
Courses are delivered remotely by our experienced Microsoft Certified Trainers.
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.
Microsoft Excel Training - Excel Tables and Pivot Tables - Expert
Become an Excel Data Wizard in just one day. Learn Pivot Table analysis, data consolidation, and visualisation techniques to master data reporting.
We currently have no public courses scheduled. Please contact us to register your interest.
Excel Excel Tables and Pivot Tables Expert Course Details
Excel Course Outlines
-
-
-
-
-
-
-
MO-201 Excel Certification
Skills Test
Contact Us
What do I need to know to attend?
To get the most out of this course, you should have successfully completed the Excel Essentials course and/or the Excel Intermediate course, or have equivalent skills and knowledge. Understanding Named Ranges would be advantageous.
Excel Excel Tables and Pivot Tables Expert Learning Outcomes
You will learn how to:
- Create and filter PivotTable reports to analyse data
- Create and manipulate PivotTable charts for graphical data representation
- Use sort and filter features to efficiently analyse large data sets
- Work with Excel tables to summarise and manage data
- Consolidate data into comprehensive reports using Data Consolidation
- Use Data Validation to control and ensure accurate data inpu
Excel Excel Tables and Pivot Tables Expert Course Content
- 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
- 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
- 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
- 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
phone
email
enquiry
