Skip to content
Home
Programs
Close Programs
Open Programs
Cybersecurity
Courses
Community
News
Knowledgebase
GIS
Courses
Community
News
Knowledgebase
Agile Methodologies
Courses
Community
News
Knowledgebase
Catalog
About
News
Contact Us
Login
Sign Up
Login
Sign Up
Login
Sign Up
Home
All Programs
Computers
Data Science
Data Analytics
Analyzing Data Using PivotTables and PivotCharts
Analyzing Data Using PivotTables and PivotCharts
Curriculum
3 Sections
19 Lessons
Lifetime
Expand all sections
Collapse all sections
Chapter 6: Creating and Using PivotTables
18
1.1
Understanding PivotTables
1.1
Quiz for Understanding PivotTables
6 Questions
1.2
Exploring PivotTable Features
1.2
Quiz for Exploring PivotTable Features
5 Questions
1.3
Building a PivotTable from an Excel Range or Table
1.3
Quiz for Building a PivotTable from an Excel Range or Table
7 Questions
1.4
Creating a PivotTable from External Data
1.4
Quiz for Creating a PivotTable from External Data
5 Questions
1.5
Refreshing PivotTable Data
1.5
Quiz for Refreshing PivotTable Data
6 Questions
1.6
Adding Multiple Fields to a PivotTable Area
1.6
Quiz for Adding Multiple Fields to a PivotTable Area
5 Questions
1.7
Pivoting a Field to a Different Area
1.7
Quiz for Pivoting a Field to a Different Area
5 Questions
1.8
Grouping PivotTable Values
1.8
Quiz for Grouping PivotTable Values
6 Questions
1.9
Filtering PivotTable Values
1.9
Quiz for Filtering PivotTable Values
6 Questions
Chapter 7: Performing PivotTable Calculations
14
2.1
Messing around with PivotTable Summary Calculations
2.1
Quiz for Messing around with PivotTable Summary Calculations
8 Questions
2.2
Working with PivotTable Subtotals
2.2
Quiz for Working with PivotTable Subtotals
5 Questions
2.3
Introducing Custom Calculations
2.3
Quiz for Introducing Custom Calculations
6 Questions
2.4
Inserting a Custom Calculated Field
2.4
Quiz for Inserting a Custom Calculated Field
5 Questions
2.5
Inserting a Custom Calculated Item
2.5
Quiz for Inserting a Custom Calculated Item
5 Questions
2.6
Editing a Custom Calculation
2.6
Quiz for Editing a Custom Calculation
5 Questions
2.7
Deleting a Custom Calculation
2.7
Quiz for Deleting a Custom Calculation
5 Questions
Chapter 8: Building PivotCharts
6
3.1
Introducing the PivotChart
3.1
Quiz for Introducing the PivotChart
6 Questions
3.2
Creating a PivotChart
3.2
Quiz for Creating a PivotChart
5 Questions
3.3
Working with PivotCharts
3.3
Quiz for Working with PivotCharts
7 Questions
This content is protected, please
login
and
enroll
in the course to view this content!
Login
or
Sign Up
Home
Programs
Close Programs
Open Programs
Cybersecurity
Courses
Community
News
Knowledgebase
GIS
Courses
Community
News
Knowledgebase
Agile Methodologies
Courses
Community
News
Knowledgebase
Cybersecurity
Courses
Community
News
Knowledgebase
Catalog
About
News
Contact Us
Linkedin
Instagram
Modal title
Main Content
