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
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
