Microsoft Excel - Tables and Pivot Tables [NXC]

Course subjects

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