|
|
1. Intro - Calculated Fields.mp4
|
MP4
|
16.9 MB
|
|
|
1. Intro - Calculated Fields.srt
|
SRT
|
1.1 KB
|
|
|
1. Intro - Formatting PivotTables.mp4
|
MP4
|
7.8 MB
|
|
|
1. Intro - Formatting PivotTables.srt
|
SRT
|
614.4 B
|
|
|
1. Intro - PivotCharts and Dashboards.mp4
|
MP4
|
14.2 MB
|
|
|
1. Intro - PivotCharts and Dashboards.srt
|
SRT
|
1.1 KB
|
|
|
1. Intro - Sorting, Filtering and Grouping.mp4
|
MP4
|
12.7 MB
|
|
|
1. Intro - Sorting, Filtering and Grouping.srt
|
SRT
|
1.4 KB
|
|
|
1. Intro - Working with values.mp4
|
MP4
|
11.1 MB
|
|
|
1. Intro - Working with values.srt
|
SRT
|
819.2 B
|
|
|
1. Overview and download of the example data file.mp4
|
MP4
|
43.2 MB
|
|
|
1. Overview and download of the example data file.srt
|
SRT
|
4.3 KB
|
|
|
1. Welcome to the course!.mp4
|
MP4
|
20.6 MB
|
|
|
1. Welcome to the course!.srt
|
SRT
|
1.5 KB
|
|
|
1.1 Pivot_Example_Data_101.xlsx
|
XLSX
|
362.7 KB
|
|
|
10. Automatic date grouping and options.mp4
|
MP4
|
65.1 MB
|
|
|
10. Automatic date grouping and options.srt
|
SRT
|
11 KB
|
|
|
10. Pro tip for generating filtered subsets of data.mp4
|
MP4
|
32.1 MB
|
|
|
10. Pro tip for generating filtered subsets of data.srt
|
SRT
|
5.5 KB
|
|
|
10. Visualization with icon sets and color scales.mp4
|
MP4
|
46.7 MB
|
|
|
10. Visualization with icon sets and color scales.srt
|
SRT
|
7.6 KB
|
|
|
10.1 Pivot_Example_Data_110.xlsx
|
XLSX
|
503 KB
|
|
|
10.1 Pivot_Example_Data_209.xlsx
|
XLSX
|
504.6 KB
|
|
|
10.1 Pivot_Example_Data_308.xlsx
|
XLSX
|
722.4 KB
|
|
|
11. Conditional formatting specifically for PivotTables.mp4
|
MP4
|
48.1 MB
|
|
|
11. Conditional formatting specifically for PivotTables.srt
|
SRT
|
7.9 KB
|
|
|
11. Visual filtering using slicers.mp4
|
MP4
|
73 MB
|
|
|
11. Visual filtering using slicers.srt
|
SRT
|
9.9 KB
|
|
|
11.1 Pivot_Example_Data_210.xlsx
|
XLSX
|
504.8 KB
|
|
|
11.1 Pivot_Example_Data_309.xlsx
|
XLSX
|
658.3 KB
|
|
|
12. Preventing PivotTables from resizing on update.mp4
|
MP4
|
34.5 MB
|
|
|
12. Preventing PivotTables from resizing on update.srt
|
SRT
|
5.7 KB
|
|
|
12. Visual date filtering using timelines.mp4
|
MP4
|
58.1 MB
|
|
|
12. Visual date filtering using timelines.srt
|
SRT
|
7.7 KB
|
|
|
12.1 Pivot_Example_Data_211.xlsx
|
XLSX
|
504.9 KB
|
|
|
12.1 Pivot_Example_Data_310.xlsx
|
XLSX
|
660 KB
|
|
|
13. Creating and showing report filter pages.mp4
|
MP4
|
50.9 MB
|
|
|
13. Creating and showing report filter pages.srt
|
SRT
|
7.5 KB
|
|
|
13.1 Pivot_Example_Data_311.xlsx
|
XLSX
|
655.9 KB
|
|
|
2. Creating PivotCharts.mp4
|
MP4
|
42.7 MB
|
|
|
2. Creating PivotCharts.srt
|
SRT
|
7.6 KB
|
|
|
2. Number formatting with PivotTables.mp4
|
MP4
|
37.8 MB
|
|
|
2. Number formatting with PivotTables.srt
|
SRT
|
5.6 KB
|
|
|
2. Overview of the different sorting options.mp4
|
MP4
|
59.5 MB
|
|
|
2. Overview of the different sorting options.srt
|
SRT
|
9 KB
|
|
|
2. Structuring the source data.mp4
|
MP4
|
123.2 MB
|
|
|
2. Structuring the source data.srt
|
SRT
|
11.3 KB
|
|
|
2. Summarizing values by different methods.mp4
|
MP4
|
52 MB
|
|
|
2. Summarizing values by different methods.srt
|
SRT
|
7.4 KB
|
|
|
2. Using calculated fields in PivotTables.mp4
|
MP4
|
76 MB
|
|
|
2. Using calculated fields in PivotTables.srt
|
SRT
|
11.3 KB
|
|
|
2. Why PivotTables What are they good for.mp4
|
MP4
|
58.2 MB
|
|
|
2. Why PivotTables What are they good for.srt
|
SRT
|
4 KB
|
|
|
2.1 Pivot_Example_Data_102.xlsx
|
XLSX
|
361.9 KB
|
|
|
2.1 Pivot_Example_Data_201.xlsx
|
XLSX
|
503.3 KB
|
|
|
2.1 Pivot_Example_Data_301.xlsx
|
XLSX
|
517 KB
|
|
|
2.1 Pivot_Example_Data_401.xlsx
|
XLSX
|
655.7 KB
|
|
|
2.1 Pivot_Example_Data_501.xlsx
|
XLSX
|
656.9 KB
|
|
|
2.1 Pivot_Example_Data_601.xlsx
|
XLSX
|
675 KB
|
|
|
3. Creating and inserting PivotTables in Microsoft Excel.mp4
|
MP4
|
50.3 MB
|
|
|
3. Creating and inserting PivotTables in Microsoft Excel.srt
|
SRT
|
5.1 KB
|
|
|
3. Pie Charts and using multiple PivotCharts.mp4
|
MP4
|
75.4 MB
|
|
|
3. Pie Charts and using multiple PivotCharts.srt
|
SRT
|
13.1 KB
|
|
|
3. Show values as... options.mp4
|
MP4
|
92.9 MB
|
|
|
3. Show values as... options.srt
|
SRT
|
13.1 KB
|
|
|
3. Sorting by custom lists.mp4
|
MP4
|
51.5 MB
|
|
|
3. Sorting by custom lists.srt
|
SRT
|
7.9 KB
|
|
|
3. Table layout and customizing the view.mp4
|
MP4
|
117.3 MB
|
|
|
3. Table layout and customizing the view.srt
|
SRT
|
19.1 KB
|
|
|
3. Using count in calculated fields.mp4
|
MP4
|
69.2 MB
|
|
|
3. Using count in calculated fields.srt
|
SRT
|
9.3 KB
|
|
|
3.1 Pivot_Example_Data_103.xlsx
|
XLSX
|
506.9 KB
|
|
|
3.1 Pivot_Example_Data_202.xlsx
|
XLSX
|
507.2 KB
|
|
|
3.1 Pivot_Example_Data_302.xlsx
|
XLSX
|
506 KB
|
|
|
3.1 Pivot_Example_Data_402.xlsx
|
XLSX
|
656.1 KB
|
|
|
3.1 Pivot_Example_Data_502.xlsx
|
XLSX
|
671.2 KB
|
|
|
3.1 Pivot_Example_Data_602.xlsx
|
XLSX
|
675 KB
|
|
|
4. Filtering with manual selections and label filters.mp4
|
MP4
|
92.3 MB
|
|
|
4. Filtering with manual selections and label filters.srt
|
SRT
|
18.9 KB
|
|
|
4. Show values as % of parent total.mp4
|
MP4
|
53.5 MB
|
|
|
4. Show values as % of parent total.srt
|
SRT
|
7.9 KB
|
|
|
4. The PivotTable fields explained.mp4
|
MP4
|
144.6 MB
|
|
|
4. The PivotTable fields explained.srt
|
SRT
|
23.7 KB
|
|
|
4. Using tabular layout to create exportable data sets.mp4
|
MP4
|
25.6 MB
|
|
|
4. Using tabular layout to create exportable data sets.srt
|
SRT
|
4.2 KB
|
|
|
4. Visually improving PivotCharts.mp4
|
MP4
|
59.2 MB
|
|
|
4. Visually improving PivotCharts.srt
|
SRT
|
11.8 KB
|
|
|
4.1 Pivot_Example_Data_104.xlsx
|
XLSX
|
496.8 KB
|
|
|
4.1 Pivot_Example_Data_203.xlsx
|
XLSX
|
506.2 KB
|
|
|
4.1 Pivot_Example_Data_303.xlsx
|
XLSX
|
500.9 KB
|
|
|
4.1 Pivot_Example_Data_403.xlsx
|
XLSX
|
664.7 KB
|
|
|
4.1 Pivot_Example_Data_603.xlsx
|
XLSX
|
685 KB
|
|
|
5. Creating custom PivotTable styles.mp4
|
MP4
|
87.5 MB
|
|
|
5. Creating custom PivotTable styles.srt
|
SRT
|
14.3 KB
|
|
|
5. Multiple dimensions in PivotCharts.mp4
|
MP4
|
65.8 MB
|
|
|
5. Multiple dimensions in PivotCharts.srt
|
SRT
|
10.4 KB
|
|
|
5. PivotTable tabs in the Excel ribbon.mp4
|
MP4
|
19.1 MB
|
|
|
5. PivotTable tabs in the Excel ribbon.srt
|
SRT
|
3 KB
|
|
|
5. Pro tip for faster manual selection filters.mp4
|
MP4
|
19.3 MB
|
|
|
5. Pro tip for faster manual selection filters.srt
|
SRT
|
3 KB
|
|
|
5. Show values as difference.mp4
|
MP4
|
53.7 MB
|
|
|
5. Show values as difference.srt
|
SRT
|
7.5 KB
|
|
|
5.1 Pivot_Example_Data_105.xlsx
|
XLSX
|
496.8 KB
|
|
|
5.1 Pivot_Example_Data_204.xlsx
|
XLSX
|
506.8 KB
|
|
|
5.1 Pivot_Example_Data_303.5.xlsx
|
XLSX
|
560.8 KB
|
|
|
5.1 Pivot_Example_Data_404.xlsx
|
XLSX
|
662.6 KB
|
|
|
5.1 Pivot_Example_Data_604.xlsx
|
XLSX
|
685 KB
|
|
|
6. Changing labels inside of a PivotTable.mp4
|
MP4
|
22.7 MB
|
|
|
6. Changing labels inside of a PivotTable.srt
|
SRT
|
4.5 KB
|
|
|
6. Filtering PivotCharts using timelines and slicers.mp4
|
MP4
|
33.1 MB
|
|
|
6. Filtering PivotCharts using timelines and slicers.srt
|
SRT
|
5.4 KB
|
|
|
6. Filtering with wildcards.mp4
|
MP4
|
59.1 MB
|
|
|
6. Filtering with wildcards.srt
|
SRT
|
10.3 KB
|
|
|
6. PivotTable actions and how we can use them.mp4
|
MP4
|
61.9 MB
|
|
|
6. PivotTable actions and how we can use them.srt
|
SRT
|
10.3 KB
|
|
|
6. Show values as running totals.mp4
|
MP4
|
32.5 MB
|
|
|
6. Show values as running totals.srt
|
SRT
|
4.8 KB
|
|
|
6.1 Pivot_Example_Data_106.xlsx
|
XLSX
|
495.8 KB
|
|
|
6.1 Pivot_Example_Data_205.xlsx
|
XLSX
|
506.5 KB
|
|
|
6.1 Pivot_Example_Data_304.xlsx
|
XLSX
|
642 KB
|
|
|
6.1 Pivot_Example_Data_405.xlsx
|
XLSX
|
664.1 KB
|
|
|
6.1 Pivot_Example_Data_605.xlsx
|
XLSX
|
694.9 KB
|
|
|
7. Conditional formatting to show the highest values.mp4
|
MP4
|
35.4 MB
|
|
|
7. Conditional formatting to show the highest values.srt
|
SRT
|
6.7 KB
|
|
|
7. Creating a dashboard from PivotCharts.mp4
|
MP4
|
72.5 MB
|
|
|
7. Creating a dashboard from PivotCharts.srt
|
SRT
|
11.5 KB
|
|
|
7. Refreshing and Changing the data source for PivotTables.mp4
|
MP4
|
115.2 MB
|
|
|
7. Refreshing and Changing the data source for PivotTables.srt
|
SRT
|
12.5 KB
|
|
|
7. Show values as rank.mp4
|
MP4
|
24.5 MB
|
|
|
7. Show values as rank.srt
|
SRT
|
4.4 KB
|
|
|
7. Using value filters.mp4
|
MP4
|
42.7 MB
|
|
|
7. Using value filters.srt
|
SRT
|
6.8 KB
|
|
|
7.1 Pivot_Example_Data_107.xlsx
|
XLSX
|
500.7 KB
|
|
|
7.1 Pivot_Example_Data_206.xlsx
|
XLSX
|
504.5 KB
|
|
|
7.1 Pivot_Example_Data_305.xlsx
|
XLSX
|
641.5 KB
|
|
|
7.1 Pivot_Example_Data_406.xlsx
|
XLSX
|
664.6 KB
|
|
|
7.1 Pivot_Example_Data_606.xlsx
|
XLSX
|
695.4 KB
|
|
|
8. Highlighting top and bottom values using conditional formatting.mp4
|
MP4
|
52.9 MB
|
|
|
8. Highlighting top and bottom values using conditional formatting.srt
|
SRT
|
10.2 KB
|
|
|
8. Tips for working with growing source data.mp4
|
MP4
|
137.7 MB
|
|
|
8. Tips for working with growing source data.srt
|
SRT
|
16 KB
|
|
|
8. Using multiple filters simultaneously.mp4
|
MP4
|
38.1 MB
|
|
|
8. Using multiple filters simultaneously.srt
|
SRT
|
6 KB
|
|
|
8. Visual improvements for large PivotTables.mp4
|
MP4
|
63.2 MB
|
|
|
8. Visual improvements for large PivotTables.srt
|
SRT
|
8.8 KB
|
|
|
8. Visually improving the dashboard.mp4
|
MP4
|
57.8 MB
|
|
|
8. Visually improving the dashboard.srt
|
SRT
|
9.5 KB
|
|
|
8.1 Pivot_Example_Data_108.xlsx
|
XLSX
|
503.1 KB
|
|
|
8.1 Pivot_Example_Data_207.xlsx
|
XLSX
|
504.6 KB
|
|
|
8.1 Pivot_Example_Data_306.xlsx
|
XLSX
|
642.1 KB
|
|
|
8.1 Pivot_Example_Data_407.xlsx
|
XLSX
|
666.3 KB
|
|
|
8.1 Pivot_Example_Data_607.xlsx
|
XLSX
|
696.1 KB
|
|
|
9. Creating custom groups in a PivotTable.mp4
|
MP4
|
38.9 MB
|
|
|
9. Creating custom groups in a PivotTable.srt
|
SRT
|
7.2 KB
|
|
|
9. Printing the dashboard.mp4
|
MP4
|
24.8 MB
|
|
|
9. Printing the dashboard.srt
|
SRT
|
5.3 KB
|
|
|
9. Show values as index with example.mp4
|
MP4
|
97.9 MB
|
|
|
9. Show values as index with example.srt
|
SRT
|
17 KB
|
|
|
9. The PivotTable Cache explained.mp4
|
MP4
|
116.3 MB
|
|
|
9. The PivotTable Cache explained.srt
|
SRT
|
15.4 KB
|
|
|
9. Visualization with data bars.mp4
|
MP4
|
60.6 MB
|
|
|
9. Visualization with data bars.srt
|
SRT
|
8.6 KB
|
|
|
9.1 Pivot_Example_Data_109_End.xlsx
|
XLSX
|
493.2 KB
|
|
|
9.1 Pivot_Example_Data_208.xlsx
|
XLSX
|
505 KB
|
|
|
9.1 Pivot_Example_Data_307.xlsx
|
XLSX
|
746.4 KB
|
|
|
9.1 Pivot_Example_Data_406.5.xlsx
|
XLSX
|
34 KB
|
|
|
9.1 Pivot_Example_Data_608.xlsx
|
XLSX
|
696.9 KB
|
|
|
9.2 Pivot_Example_Data_109_Start.xlsx
|
XLSX
|
503 KB
|
|
|
Bonus Resources.txt
|
TXT
|
409.6 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
