VR SCHOOL
ONLINE
Nexus Home
Course Catalog
Meta-Campus
Status
Enter The Nexus
Home
Courses
Part 2: Analyzing Data Using PivotTables and PivotCharts
Curriculum
3 Sections
19 Lessons
10 Weeks
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