|
Please note that this page does not hosts or makes available any of the listed filenames. You
cannot download any of those files from here.
|
| 1.1 Pivot_Example_Data_101.xlsx |
362.66KB |
| 1. Intro - Calculated Fields.mp4 |
16.93MB |
| 1. Intro - Calculated Fields.srt |
1.14KB |
| 1. Intro - Formatting PivotTables.mp4 |
7.83MB |
| 1. Intro - Formatting PivotTables.srt |
608B |
| 1. Intro - PivotCharts and Dashboards.mp4 |
14.16MB |
| 1. Intro - PivotCharts and Dashboards.srt |
1.12KB |
| 1. Intro - Sorting, Filtering and Grouping.mp4 |
12.68MB |
| 1. Intro - Sorting, Filtering and Grouping.srt |
1.41KB |
| 1. Intro - Working with values.mp4 |
11.12MB |
| 1. Intro - Working with values.srt |
772B |
| 1. Overview and download of the example data file.mp4 |
43.24MB |
| 1. Overview and download of the example data file.srt |
4.32KB |
| 1. Welcome to the course!.mp4 |
20.62MB |
| 1. Welcome to the course!.srt |
1.47KB |
| 10.1 Pivot_Example_Data_110.xlsx |
503.03KB |
| 10.1 Pivot_Example_Data_209.xlsx |
504.61KB |
| 10.1 Pivot_Example_Data_308.xlsx |
722.39KB |
| 10. Automatic date grouping and options.mp4 |
65.05MB |
| 10. Automatic date grouping and options.srt |
11.00KB |
| 10. Pro tip for generating filtered subsets of data.mp4 |
32.11MB |
| 10. Pro tip for generating filtered subsets of data.srt |
5.51KB |
| 10. Visualization with icon sets and color scales.mp4 |
46.72MB |
| 10. Visualization with icon sets and color scales.srt |
7.63KB |
| 11.1 Pivot_Example_Data_210.xlsx |
504.78KB |
| 11.1 Pivot_Example_Data_309.xlsx |
658.27KB |
| 11. Conditional formatting specifically for PivotTables.mp4 |
48.11MB |
| 11. Conditional formatting specifically for PivotTables.srt |
7.92KB |
| 11. Visual filtering using slicers.mp4 |
72.97MB |
| 11. Visual filtering using slicers.srt |
9.94KB |
| 12.1 Pivot_Example_Data_211.xlsx |
504.90KB |
| 12.1 Pivot_Example_Data_310.xlsx |
660.00KB |
| 12. Preventing PivotTables from resizing on update.mp4 |
34.52MB |
| 12. Preventing PivotTables from resizing on update.srt |
5.70KB |
| 12. Visual date filtering using timelines.mp4 |
58.14MB |
| 12. Visual date filtering using timelines.srt |
7.73KB |
| 13.1 Pivot_Example_Data_311.xlsx |
655.91KB |
| 13. Creating and showing report filter pages.mp4 |
50.86MB |
| 13. Creating and showing report filter pages.srt |
7.46KB |
| 2.1 Pivot_Example_Data_102.xlsx |
361.94KB |
| 2.1 Pivot_Example_Data_201.xlsx |
503.30KB |
| 2.1 Pivot_Example_Data_301.xlsx |
517.04KB |
| 2.1 Pivot_Example_Data_401.xlsx |
655.67KB |
| 2.1 Pivot_Example_Data_501.xlsx |
656.92KB |
| 2.1 Pivot_Example_Data_601.xlsx |
674.97KB |
| 2. Creating PivotCharts.mp4 |
42.72MB |
| 2. Creating PivotCharts.srt |
7.55KB |
| 2. Number formatting with PivotTables.mp4 |
37.79MB |
| 2. Number formatting with PivotTables.srt |
5.57KB |
| 2. Overview of the different sorting options.mp4 |
59.51MB |
| 2. Overview of the different sorting options.srt |
8.99KB |
| 2. Structuring the source data.mp4 |
123.15MB |
| 2. Structuring the source data.srt |
11.29KB |
| 2. Summarizing values by different methods.mp4 |
51.98MB |
| 2. Summarizing values by different methods.srt |
7.43KB |
| 2. Using calculated fields in PivotTables.mp4 |
75.96MB |
| 2. Using calculated fields in PivotTables.srt |
11.29KB |
| 2. Why PivotTables What are they good for.mp4 |
58.16MB |
| 2. Why PivotTables What are they good for.srt |
4.01KB |
| 3.1 Pivot_Example_Data_103.xlsx |
506.90KB |
| 3.1 Pivot_Example_Data_202.xlsx |
507.18KB |
| 3.1 Pivot_Example_Data_302.xlsx |
506.03KB |
| 3.1 Pivot_Example_Data_402.xlsx |
656.07KB |
| 3.1 Pivot_Example_Data_502.xlsx |
671.23KB |
| 3.1 Pivot_Example_Data_602.xlsx |
674.97KB |
| 3. Creating and inserting PivotTables in Microsoft Excel.mp4 |
50.27MB |
| 3. Creating and inserting PivotTables in Microsoft Excel.srt |
5.12KB |
| 3. Pie Charts and using multiple PivotCharts.mp4 |
75.40MB |
| 3. Pie Charts and using multiple PivotCharts.srt |
13.05KB |
| 3. Show values as... options.mp4 |
92.90MB |
| 3. Show values as... options.srt |
13.10KB |
| 3. Sorting by custom lists.mp4 |
51.45MB |
| 3. Sorting by custom lists.srt |
7.86KB |
| 3. Table layout and customizing the view.mp4 |
117.30MB |
| 3. Table layout and customizing the view.srt |
19.10KB |
| 3. Using count in calculated fields.mp4 |
69.23MB |
| 3. Using count in calculated fields.srt |
9.27KB |
| 4.1 Pivot_Example_Data_104.xlsx |
496.76KB |
| 4.1 Pivot_Example_Data_203.xlsx |
506.17KB |
| 4.1 Pivot_Example_Data_303.xlsx |
500.90KB |
| 4.1 Pivot_Example_Data_403.xlsx |
664.69KB |
| 4.1 Pivot_Example_Data_603.xlsx |
684.99KB |
| 4. Filtering with manual selections and label filters.mp4 |
92.28MB |
| 4. Filtering with manual selections and label filters.srt |
18.90KB |
| 4. Show values as % of parent total.mp4 |
53.51MB |
| 4. Show values as % of parent total.srt |
7.95KB |
| 4. The PivotTable fields explained.mp4 |
144.62MB |
| 4. The PivotTable fields explained.srt |
23.66KB |
| 4. Using tabular layout to create exportable data sets.mp4 |
25.58MB |
| 4. Using tabular layout to create exportable data sets.srt |
4.23KB |
| 4. Visually improving PivotCharts.mp4 |
59.21MB |
| 4. Visually improving PivotCharts.srt |
11.78KB |
| 5.1 Pivot_Example_Data_105.xlsx |
496.76KB |
| 5.1 Pivot_Example_Data_204.xlsx |
506.82KB |
| 5.1 Pivot_Example_Data_303.5.xlsx |
560.76KB |
| 5.1 Pivot_Example_Data_404.xlsx |
662.65KB |
| 5.1 Pivot_Example_Data_604.xlsx |
685.00KB |
| 5. Creating custom PivotTable styles.mp4 |
87.51MB |
| 5. Creating custom PivotTable styles.srt |
14.26KB |
| 5. Multiple dimensions in PivotCharts.mp4 |
65.81MB |
| 5. Multiple dimensions in PivotCharts.srt |
10.41KB |
| 5. PivotTable tabs in the Excel ribbon.mp4 |
19.09MB |
| 5. PivotTable tabs in the Excel ribbon.srt |
3.01KB |
| 5. Pro tip for faster manual selection filters.mp4 |
19.27MB |
| 5. Pro tip for faster manual selection filters.srt |
3.03KB |
| 5. Show values as difference.mp4 |
53.74MB |
| 5. Show values as difference.srt |
7.53KB |
| 6.1 Pivot_Example_Data_106.xlsx |
495.81KB |
| 6.1 Pivot_Example_Data_205.xlsx |
506.45KB |
| 6.1 Pivot_Example_Data_304.xlsx |
642.04KB |
| 6.1 Pivot_Example_Data_405.xlsx |
664.06KB |
| 6.1 Pivot_Example_Data_605.xlsx |
694.90KB |
| 6. Changing labels inside of a PivotTable.mp4 |
22.74MB |
| 6. Changing labels inside of a PivotTable.srt |
4.55KB |
| 6. Filtering PivotCharts using timelines and slicers.mp4 |
33.12MB |
| 6. Filtering PivotCharts using timelines and slicers.srt |
5.45KB |
| 6. Filtering with wildcards.mp4 |
59.13MB |
| 6. Filtering with wildcards.srt |
10.34KB |
| 6. PivotTable actions and how we can use them.mp4 |
61.88MB |
| 6. PivotTable actions and how we can use them.srt |
10.29KB |
| 6. Show values as running totals.mp4 |
32.54MB |
| 6. Show values as running totals.srt |
4.83KB |
| 7.1 Pivot_Example_Data_107.xlsx |
500.68KB |
| 7.1 Pivot_Example_Data_206.xlsx |
504.52KB |
| 7.1 Pivot_Example_Data_305.xlsx |
641.47KB |
| 7.1 Pivot_Example_Data_406.xlsx |
664.64KB |
| 7.1 Pivot_Example_Data_606.xlsx |
695.41KB |
| 7. Conditional formatting to show the highest values.mp4 |
35.43MB |
| 7. Conditional formatting to show the highest values.srt |
6.66KB |
| 7. Creating a dashboard from PivotCharts.mp4 |
72.54MB |
| 7. Creating a dashboard from PivotCharts.srt |
11.54KB |
| 7. Refreshing and Changing the data source for PivotTables.mp4 |
115.18MB |
| 7. Refreshing and Changing the data source for PivotTables.srt |
12.47KB |
| 7. Show values as rank.mp4 |
24.50MB |
| 7. Show values as rank.srt |
4.36KB |
| 7. Using value filters.mp4 |
42.69MB |
| 7. Using value filters.srt |
6.77KB |
| 8.1 Pivot_Example_Data_108.xlsx |
503.05KB |
| 8.1 Pivot_Example_Data_207.xlsx |
504.65KB |
| 8.1 Pivot_Example_Data_306.xlsx |
642.15KB |
| 8.1 Pivot_Example_Data_407.xlsx |
666.25KB |
| 8.1 Pivot_Example_Data_607.xlsx |
696.11KB |
| 8. Highlighting top and bottom values using conditional formatting.mp4 |
52.92MB |
| 8. Highlighting top and bottom values using conditional formatting.srt |
10.21KB |
| 8. Tips for working with growing source data.mp4 |
137.73MB |
| 8. Tips for working with growing source data.srt |
16.04KB |
| 8. Using multiple filters simultaneously.mp4 |
38.12MB |
| 8. Using multiple filters simultaneously.srt |
6.05KB |
| 8. Visual improvements for large PivotTables.mp4 |
63.18MB |
| 8. Visual improvements for large PivotTables.srt |
8.81KB |
| 8. Visually improving the dashboard.mp4 |
57.82MB |
| 8. Visually improving the dashboard.srt |
9.45KB |
| 9.1 Pivot_Example_Data_109_End.xlsx |
493.16KB |
| 9.1 Pivot_Example_Data_208.xlsx |
505.05KB |
| 9.1 Pivot_Example_Data_307.xlsx |
746.39KB |
| 9.1 Pivot_Example_Data_406.5.xlsx |
33.99KB |
| 9.1 Pivot_Example_Data_608.xlsx |
696.86KB |
| 9.2 Pivot_Example_Data_109_Start.xlsx |
503.05KB |
| 9. Creating custom groups in a PivotTable.mp4 |
38.86MB |
| 9. Creating custom groups in a PivotTable.srt |
7.16KB |
| 9. Printing the dashboard.mp4 |
24.84MB |
| 9. Printing the dashboard.srt |
5.25KB |
| 9. Show values as index with example.mp4 |
97.94MB |
| 9. Show values as index with example.srt |
17.04KB |
| 9. The PivotTable Cache explained.mp4 |
116.28MB |
| 9. The PivotTable Cache explained.srt |
15.45KB |
| 9. Visualization with data bars.mp4 |
60.64MB |
| 9. Visualization with data bars.srt |
8.64KB |
| Bonus Resources.txt |
386B |
| Get Bonus Downloads Here.url |
182B |