Skip to content
info@sejal-learn.com
Instagram
X-twitter
Youtube
Linkedin
Facebook
Login
Sign Up
info@sejal-learn.com
Instagram
X-twitter
Youtube
Linkedin
Facebook
Login
Sign Up
Course Catalog
About
Contact Us
Home
All Programs
Computers
Data Science
Data Analytics
Analyzing Data Using PivotTables and PivotCharts
Curriculum
3 Sections
19 Lessons
10 Weeks
Expand all sections
Collapse all sections
Creating and Using PivotTables
18
1.1
Understanding PivotTables
1.2
Quiz for Understanding PivotTables
6 Questions
1.3
Exploring PivotTable Features
1.4
Quiz for Exploring PivotTable Features
5 Questions
1.5
Building a PivotTable from an Excel Range or Table
1.6
Quiz for Building a PivotTable from an Excel Range or Table
7 Questions
1.7
Creating a PivotTable from External Data
1.8
Quiz for Creating a PivotTable from External Data
5 Questions
1.9
Refreshing PivotTable Data
1.10
Quiz for Refreshing PivotTable Data
6 Questions
1.11
Adding Multiple Fields to a PivotTable Area
1.12
Quiz for Adding Multiple Fields to a PivotTable Area
5 Questions
1.13
Pivoting a Field to a Different Area
1.14
Quiz for Pivoting a Field to a Different Area
5 Questions
1.15
Grouping PivotTable Values
1.16
Quiz for Grouping PivotTable Values
6 Questions
1.17
Filtering PivotTable Values
1.18
Quiz for Filtering PivotTable Values
6 Questions
Performing PivotTable Calculations
14
2.1
Messing around with PivotTable Summary Calculations
2.2
Quiz for Messing around with PivotTable Summary Calculations
8 Questions
2.3
Working with PivotTable Subtotals
2.4
Quiz for Working with PivotTable Subtotals
5 Questions
2.5
Introducing Custom Calculations
2.6
Quiz for Introducing Custom Calculations
6 Questions
2.7
Inserting a Custom Calculated Field
2.8
Quiz for Inserting a Custom Calculated Field
5 Questions
2.9
Inserting a Custom Calculated Item
2.10
Quiz for Inserting a Custom Calculated Item
5 Questions
2.11
Editing a Custom Calculation
2.12
Quiz for Editing a Custom Calculation
5 Questions
2.13
Deleting a Custom Calculation
2.14
Quiz for Deleting a Custom Calculation
5 Questions
Building PivotCharts
6
3.1
Introducing the PivotChart
3.2
Quiz for Introducing the PivotChart
6 Questions
3.3
Creating a PivotChart
3.4
Quiz for Creating a PivotChart
5 Questions
3.5
Working with PivotCharts
3.6
Quiz for Working with PivotCharts
7 Questions
This content is protected, please
login
and
enroll
in the course to view this content!
Your Journey Starts Here
Course Catalog
About
Contact Us
Login/Sign Up
Modal title
Main Content
