This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Data Analytics using Excel Pivot Table
First Section
Vidoe 1: Introduction to Data Analytics using PivotTable (1:29)
Introduction to PivotTable
Benefits of PivotTable (1:00)
Standard Rules for Organizing Source Data (1:10)
Creating PivotTable (2:11)
Activating Classic PivotTable Layout (1:44)
Introduction to PivotTable Report (2:43)
Multiple ways to create PivotTable (1:50)
Types of PivotTables
One Dimensional PivotTable (1:14)
Two Dimensional PivotTable (1:51)
Three Dimensional PivotTable (1:38)
Formatting PivotTable
Format Values in PivotTable Report (1:44)
Sorting Data in PivotTable (1:43)
Updating PivotTable using Refresh Option (1:50)
Updating PivotTable to include New Rows (1:56)
How to Copy PivotTable (1:51)
Report Filters / Page Fields
Page Fields Option (1:27)
Displaying Pages on Separate Worksheets (2:28)
Hiding and Showing Summary Values (1:58)
Summary Statistics & Relationship of Summarized Data
Changing Summary Statistics (1:50)
Changing the Relationship of Summarized Data (3:04)
Options Available in Show Values As (2:16)
More Options in Show Values As (2:05)
Grouping Data and Calculated Field
Grouping Data in PivotTable (1:53)
How to Create Calculated Field in PivotTable (3:54)
Filtering Date in PivotTable
How to Filter PivotTable Data Manually (3:50)
Creating PivotTable Label Filters (3:00)
How to Create PivotTable Value Filters (2:27)
How to create PivotTable Date Filters (3:00)
How to Create Multiple Filters (3:42)
What Next after PivotTable
What next after Creating a PivotTable (3:01)
Turnoff GETPIVOTDATA to activate PivotTable Cell Reference (4:36)
Making your PivotTable Vibrant
PivotTable Design (2:08)
PivotTable Design Layout (3:57)
Visalize PivotTable Report
Creating PivotChart on PivotTable Report (3:09)
Create PivotTable and PivotChart together (3:01)
Advanced Topics - Power of Field Settings
Calculate Multiple Descriptives, and Printing report in Separate Pages (3:14)
Calculate Multiple Descriptives, Layout Design, and Print report in Separate Pages in one go (3:28)
Case Studies with Solution
Case Study 1 Elections Data - Q1 Solution (3:51)
Case Study 1 Elections Data - Q2 Solution (2:53)
Case Study 2 36 Years Gold Prices - Q1 Solution (3:03)
Case Study 2 36 Years Gold Prices - Q2 Solution (2:46)
Hiding and Showing Summary Values
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock