Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel Pivot Tables for Beginners
Pivot Tables
Welcome to Excel Pivot Tables for Beginners! (1:56)
Before we get started, let's look at the basics (4:49)
Introducing Pivot Tables (5:05)
A quick look around the Pivot Table page (1:30)
Adding data to Pivot Tables (4:59)
Removing and customising report data (2:17)
Formatting Pivot Table information (3:51)
Sorting and filtering data (6:28)
Working with Report Filters (4:08)
Customising the Pivot Table screen layout (4:25)
Basic Pivot Table options (3:45)
Working with Report Filter page options (4:25)
Pivot Table configuration options (11:26)
Drilling down into Pivot Table data (1:32)
Data calculation options (3:32)
Grouping Pivot Table data (5:30)
Grouping options relating to date information (5:15)
Refreshing and modifying source data options (5:07)
How to move a Pivot Table (6:49)
Inserting a Pivot Chart (4:12)
How to create a Calculated Field (4:05)
Introducing the new Slicer Tool (6:05)
Working with Pivot Table styles (2:19)
How to insert a Pivot Chart from the Office Ribbon (6:38)
Customising the Pivot Table screen layout
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock