Excel Pivot Table: Grouping, Calcs, Slicer, Sparklines

Yoda Learning Academy | 19 videos | Updated 5 days ago

3:58

1001. Pivot Table - Why should you learn

2:25

1002. Pivot Table - Pre-requisites

2:40

1003. Pivot Table - How to create one

3:21

1004. Pivot Table - Exploring Pivot Table grid (Fields)

5:05

1005. Pivot Table - Value Field Settings - Summarize Values By - Sum, Average, Count, Max etc.

2:22

1006. Pivot Table - Value Field Settings - Show Values As - Percentage (%) of Grand Total

4:49

1007. Pivot Table - Value Field Settings - Show Values As - Percentage (%) of ColumnRow Total

3:38

1008. Pivot Table - Grouping - Numbers

4:08

1009. Pivot Table - Grouping - Dates [Years, Months etc.]

3:36

1010. Pivot Table - Grouping - Text

6:18

1011. Pivot Table - Refresh vs Refresh All, Change Data Source & creating Dynamic Table Data Source

0:41

1012. Pivot Table - Auto Refresh

2:12

1013. Pivot Table - Pivot Chart Shortcut and Sparklines

1:00

1014. Pivot Table - Drill Down option

3:39

1015. Pivot Table - Report Filter - Generating 100s of reports in few seconds

2:33

1016. Pivot Table - Slicer vs. Report Filter

7:58

1017. Pivot Table - Practice - Sales Data Analysis- 1 of 2 (%, Grouping, Chart, Report Filter Pages)

3:09

1018. Pivot Table - Practice - Sales Data Analysis - 2 of 2 (Slicer)

7:00

1019. Pivot Table - Practice - Closing Stock Analysis