Programs
Tracks
Memberships
How it works
Log in
Start free
Programs
Tracks
Memberships
How it works
Log in
Start free
VR SCHOOL
ONLINE
Home
Courses
Analyzing Data Using PivotTables and PivotCharts
Curriculum
3 Sections
19 Lessons
Lifetime
Expand all sections
Collapse all sections
Chapter 6: Creating and Using PivotTables
9
1.1
Understanding PivotTables
10 mins
1.2
Exploring PivotTable Features
10 mins
1.3
Building a PivotTable from an Excel Range or Table
10 mins
1.4
Creating a PivotTable from External Data
10 mins
1.5
Refreshing PivotTable Data
10 mins
1.6
Adding Multiple Fields to a PivotTable Area
10 mins
1.7
Pivoting a Field to a Different Area
10 mins
1.8
Grouping PivotTable Values
10 mins
1.9
Filtering PivotTable Values
10 mins
Chapter 7: Performing PivotTable Calculations
7
2.1
Messing around with PivotTable Summary Calculations
10 mins
2.2
Working with PivotTable Subtotals
10 mins
2.3
Introducing Custom Calculations
10 mins
2.4
Inserting a Custom Calculated Field
10 mins
2.5
Inserting a Custom Calculated Item
10 mins
2.6
Editing a Custom Calculation
10 mins
2.7
Deleting a Custom Calculation
10 mins
Chapter 8: Building PivotCharts
3
3.1
Introducing the PivotChart
10 mins
3.2
Creating a PivotChart
10 mins
3.3
Working with PivotCharts
10 mins
This content is protected, please
login
and
enroll
in the course to view this content!
Modal title
Main Content