~Get Your Files Here !

  1. Einführung

   1. Welcome to the course!.srt

   2. Why PivotTables What are they good for.srt

  2. PivotTable Fundamentals - Learning the basics

   1. Overview and download of the example data file.srt

   10. Pro tip for generating filtered subsets of data.mp4

   10.1 Pivot_Example_Data_110.xlsx

   2. Structuring the source data.srt

   3. Creating and inserting PivotTables in Microsoft Excel.mp4

   3.1 Pivot_Example_Data_103.xlsx

   4. The PivotTable fields explained.srt

   5. PivotTable tabs in the Excel ribbon.mp4

   5.1 Pivot_Example_Data_105.xlsx

   6. PivotTable actions and how we can use them.srt

   7. Refreshing and Changing the data source for PivotTables.mp4

   7.1 Pivot_Example_Data_107.xlsx

   8. Tips for working with growing source data.srt

   9. The PivotTable Cache explained.mp4

   9.1 Pivot_Example_Data_109_End.xlsx

  3. Formatting PivotTables

   1. Intro - Formatting PivotTables.srt

   10. Visualization with icon sets and color scales.srt

   11. Conditional formatting specifically for PivotTables.mp4

   11.1 Pivot_Example_Data_210.xlsx

   12. Preventing PivotTables from resizing on update.srt

   2. Number formatting with PivotTables.mp4

   2.1 Pivot_Example_Data_201.xlsx

   3. Table layout and customizing the view.srt

   4. Using tabular layout to create exportable data sets.mp4

   4.1 Pivot_Example_Data_203.xlsx

   5. Creating custom PivotTable styles.srt

   6. Changing labels inside of a PivotTable.mp4

   6.1 Pivot_Example_Data_205.xlsx

   7. Conditional formatting to show the highest values.srt

   8. Highlighting top and bottom values using conditional formatting.mp4

   8.1 Pivot_Example_Data_207.xlsx

   9. Visualization with data bars.srt

  4. Sorting, Filtering and Grouping with PivotTables

   1. Intro - Sorting, Filtering and Grouping.srt

   10. Automatic date grouping and options.srt

   11. Visual filtering using slicers.mp4

   11.1 Pivot_Example_Data_309.xlsx

   12. Visual date filtering using timelines.srt

   13. Creating and showing report filter pages.mp4

   13.1 Pivot_Example_Data_311.xlsx

   2. Overview of the different sorting options.srt

   3. Sorting by custom lists.mp4

   3.1 Pivot_Example_Data_302.xlsx

   4. Filtering with manual selections and label filters.srt

   5. Pro tip for faster manual selection filters.mp4

   5.1 Pivot_Example_Data_303.5.xlsx

   6. Filtering with wildcards.srt

   7. Using value filters.mp4

   7.1 Pivot_Example_Data_305.xlsx

   8. Using multiple filters simultaneously.srt

   9. Creating custom groups in a PivotTable.mp4

   9.1 Pivot_Example_Data_307.xlsx

  5. Working with values in PivotTables

   1. Intro - Working with values.srt

   2. Summarizing values by different methods.srt

   3. Show values as... options.mp4

   3.1 Pivot_Example_Data_402.xlsx

   4. Show values as % of parent total.srt

   5. Show values as difference.mp4

   5.1 Pivot_Example_Data_404.xlsx

   6. Show values as running totals.srt

   7. Show values as rank.mp4

   7.1 Pivot_Example_Data_406.xlsx

   8. Visual improvements for large PivotTables.srt

   9. Show values as index with example.mp4

   9.1 Pivot_Example_Data_406.5.xlsx

  6. Working with calculated fields in PivotTables

   1. Intro - Calculated Fields.srt

   2. Using calculated fields in PivotTables.srt

   3. Using count in calculated fields.mp4

   3.1 Pivot_Example_Data_502.xlsx

  7. Visualizing data analysis with PivotCharts & Dashboards

   1. Intro - PivotCharts and Dashboards.srt

   2. Creating PivotCharts.srt

   3. Pie Charts and using multiple PivotCharts.mp4

   3.1 Pivot_Example_Data_602.xlsx

   4. Visually improving PivotCharts.srt

   5. Multiple dimensions in PivotCharts.mp4

   5.1 Pivot_Example_Data_604.xlsx

   6. Filtering PivotCharts using timelines and slicers.srt

   7. Creating a dashboard from PivotCharts.mp4

   7.1 Pivot_Example_Data_606.xlsx

   8. Visually improving the dashboard.srt

   9. Printing the dashboard.mp4

   9.1 Pivot_Example_Data_608.xlsx

  Bonus Resources.txt