www.RKvarsity.
com
Data Analytics with Excel PivotTable
Introduction to PivotTable
Introduction to Data Analytics using PivotTable course https://youtu.be/NlmVk950mq0
Benefits of PivotTable https://youtu.be/UtpFM5toIYY
Standard Rules to Organize Source Data for PivotTable https://youtu.be/_Txj5B7rJcM
Creating PivotTable Report
How to Create PivotTable in Excel https://youtu.be/sbCGbdf7eDE
Activating Classic PivotTable Layout https://youtu.be/zr53z4LuJZY
Introduction to PivotTable Report https://youtu.be/D_u6reSXe6g
Multiple ways to Create PivotTable https://youtu.be/etWaCmBq0ZU
Multidimensional PivotTable
One Dimensional PivotTable https://youtu.be/rTqRPeaTNfI
Two Dimensional PivotTable https://youtu.be/Nb7oP7SfXg8
Three Dimensional PivotTable https://youtu.be/YMXD1R22fNI
Format Values in PivotTable Report https://youtu.be/kXvXcrhadGs
PivotTable Page Fields Option in PivotTable https://youtu.be/V2GdMqCrH-o
Updating PivotTable
Displaying Pages on Separate Worksheets in PivotTable https://youtu.be/yBT1SXJuBAA
Updating PivotTable using Refresh Option in PivotTable https://youtu.be/zIyHp_Qt2PY
Updating PivotTable to Include new rows https://youtu.be/_Su0TcueO8s
Hiding and Showing Summary Values in PivotTable https://youtu.be/RRmRKsu2atE
Changing Summary Statistics in PivotTable https://youtu.be/YKAn41q1zhU
Changing the Relationship of Summarized Data in PivotTable https://youtu.be/LbyI1yRK3r8
Show Values As options
Options Available in Show Values As in PivotTable https://youtu.be/vZIZYIDbYks
Page 1
More Options in Show Values As in PivotTable https://youtu.be/o45kRmV-nBo
www.youtube.com/rkvarsity
www.RKvarsity.com
Sorting Data in PivotTable https://youtu.be/2rb3ScvWk-8
Grouping Data in PivotTable https://youtu.be/9HTkCv9PDLo
How to Create Calculated Field in PivotTable https://youtu.be/4wRxjef_r08
Data Filters in PivotTable
How to Filter PivotTable Data Manually https://youtu.be/tH_E_TfxB48
Creating PivotTable Label Filters https://youtu.be/WaDpEs6RrCE
How to Create PivotTable Value Filters https://youtu.be/q78tR-7j7kU
How to Create PivotTable Date Filters https://youtu.be/gq1Mx5BLFvA
How to Create Multiple Filters in PivotTable Report https://youtu.be/p-k3gVOZe54
Editing and Formatting PivotTable
What next after Creating PivotTable https://youtu.be/2MR4pjaIzzU
Turnoff GETPIVOTDATA to activate PivotTable Cell Reference https://youtu.be/EZXW5Bf-slo
How to Copy and Paste PivotTable as editable data table https://youtu.be/ZUCnJfFTjzA
PivotTable Design https://youtu.be/Wf4ZbkxxTj4
PivotTable Design Layout https://youtu.be/64m6jQWuJwQ
PivotChart
Creating PivotChart on PivotTable Report https://youtu.be/zYVj56lVaC8
Creating PivotTable and PivotChart together https://youtu.be/09aBiEVoReo
Advanced PivotTable Report
Calculate Multiple Descriptive in PivotTable Report https://youtu.be/e_FDSnHSSl8
Calculate Multiple Descriptive Statistics with PivotTable https://youtu.be/63RhmMrW8Xw
* Visit www.rkvaristy.com to download Datasets used in this course and text description of the video lectures.
All the best.
Regards, - Dr. Rama Krishna Yelamanchili
Page 2
www.youtube.com/rkvarsity
