[ DevCourseWeb.com ] Udemy - Office Fundamentals - PivotTables in Microsoft Excel

File Name

Size

Get Bonus Downloads Here.url

182 B

~Get Your Files Here !/1. Einführung/1. Welcome to the course!.mp4

21 MB

~Get Your Files Here !/1. Einführung/1. Welcome to the course!.srt

1.5 kB

~Get Your Files Here !/1. Einführung/2. Why PivotTables What are they good for.mp4

58 MB

~Get Your Files Here !/1. Einführung/2. Why PivotTables What are they good for.srt

4.0 kB

~Get Your Files Here !/2. PivotTable Fundamentals - Learning the basics/1. Overview and download of the example data file.mp4

43 MB

~Get Your Files Here !/2. PivotTable Fundamentals - Learning the basics/1. Overview and download of the example data file.srt

4.3 kB

~Get Your Files Here !/2. PivotTable Fundamentals - Learning the basics/1.1 Pivot_Example_Data_101.xlsx

363 kB

~Get Your Files Here !/2. PivotTable Fundamentals - Learning the basics/10. Pro tip for generating filtered subsets of data.mp4

32 MB

~Get Your Files Here !/2. PivotTable Fundamentals - Learning the basics/10. Pro tip for generating filtered subsets of data.srt

5.5 kB

~Get Your Files Here !/2. PivotTable Fundamentals - Learning the basics/10.1 Pivot_Example_Data_110.xlsx

503 kB

~Get Your Files Here !/2. PivotTable Fundamentals - Learning the basics/2. Structuring the source data.mp4

123 MB

~Get Your Files Here !/2. PivotTable Fundamentals - Learning the basics/2. Structuring the source data.srt

11 kB

~Get Your Files Here !/2. PivotTable Fundamentals - Learning the basics/2.1 Pivot_Example_Data_102.xlsx

362 kB

~Get Your Files Here !/2. PivotTable Fundamentals - Learning the basics/3. Creating and inserting PivotTables in Microsoft Excel.mp4

50 MB

~Get Your Files Here !/2. PivotTable Fundamentals - Learning the basics/3. Creating and inserting PivotTables in Microsoft Excel.srt

5.1 kB

~Get Your Files Here !/2. PivotTable Fundamentals - Learning the basics/3.1 Pivot_Example_Data_103.xlsx

507 kB

~Get Your Files Here !/2. PivotTable Fundamentals - Learning the basics/4. The PivotTable fields explained.mp4

145 MB

~Get Your Files Here !/2. PivotTable Fundamentals - Learning the basics/4. The PivotTable fields explained.srt

24 kB

~Get Your Files Here !/2. PivotTable Fundamentals - Learning the basics/4.1 Pivot_Example_Data_104.xlsx

497 kB

~Get Your Files Here !/2. PivotTable Fundamentals - Learning the basics/5. PivotTable tabs in the Excel ribbon.mp4

19 MB

~Get Your Files Here !/2. PivotTable Fundamentals - Learning the basics/5. PivotTable tabs in the Excel ribbon.srt

3.0 kB

~Get Your Files Here !/2. PivotTable Fundamentals - Learning the basics/5.1 Pivot_Example_Data_105.xlsx

497 kB

~Get Your Files Here !/2. PivotTable Fundamentals - Learning the basics/6. PivotTable actions and how we can use them.mp4

62 MB

~Get Your Files Here !/2. PivotTable Fundamentals - Learning the basics/6. PivotTable actions and how we can use them.srt

10 kB

~Get Your Files Here !/2. PivotTable Fundamentals - Learning the basics/6.1 Pivot_Example_Data_106.xlsx

496 kB

~Get Your Files Here !/2. PivotTable Fundamentals - Learning the basics/7. Refreshing and Changing the data source for PivotTables.mp4

115 MB

~Get Your Files Here !/2. PivotTable Fundamentals - Learning the basics/7. Refreshing and Changing the data source for PivotTables.srt

12 kB

~Get Your Files Here !/2. PivotTable Fundamentals - Learning the basics/7.1 Pivot_Example_Data_107.xlsx

501 kB

~Get Your Files Here !/2. PivotTable Fundamentals - Learning the basics/8. Tips for working with growing source data.mp4

138 MB

~Get Your Files Here !/2. PivotTable Fundamentals - Learning the basics/8. Tips for working with growing source data.srt

16 kB

~Get Your Files Here !/2. PivotTable Fundamentals - Learning the basics/8.1 Pivot_Example_Data_108.xlsx

503 kB

~Get Your Files Here !/2. PivotTable Fundamentals - Learning the basics/9. The PivotTable Cache explained.mp4

116 MB

~Get Your Files Here !/2. PivotTable Fundamentals - Learning the basics/9. The PivotTable Cache explained.srt

15 kB

~Get Your Files Here !/2. PivotTable Fundamentals - Learning the basics/9.1 Pivot_Example_Data_109_End.xlsx

493 kB

~Get Your Files Here !/2. PivotTable Fundamentals - Learning the basics/9.2 Pivot_Example_Data_109_Start.xlsx

503 kB

~Get Your Files Here !/3. Formatting PivotTables/1. Intro - Formatting PivotTables.mp4

7.8 MB

~Get Your Files Here !/3. Formatting PivotTables/1. Intro - Formatting PivotTables.srt

608 B

~Get Your Files Here !/3. Formatting PivotTables/10. Visualization with icon sets and color scales.mp4

47 MB

~Get Your Files Here !/3. Formatting PivotTables/10. Visualization with icon sets and color scales.srt

7.6 kB

~Get Your Files Here !/3. Formatting PivotTables/10.1 Pivot_Example_Data_209.xlsx

505 kB

~Get Your Files Here !/3. Formatting PivotTables/11. Conditional formatting specifically for PivotTables.mp4

48 MB

~Get Your Files Here !/3. Formatting PivotTables/11. Conditional formatting specifically for PivotTables.srt

7.9 kB

~Get Your Files Here !/3. Formatting PivotTables/11.1 Pivot_Example_Data_210.xlsx

505 kB

~Get Your Files Here !/3. Formatting PivotTables/12. Preventing PivotTables from resizing on update.mp4

34 MB

~Get Your Files Here !/3. Formatting PivotTables/12. Preventing PivotTables from resizing on update.srt

5.7 kB

~Get Your Files Here !/3. Formatting PivotTables/12.1 Pivot_Example_Data_211.xlsx

505 kB

~Get Your Files Here !/3. Formatting PivotTables/2. Number formatting with PivotTables.mp4

38 MB

~Get Your Files Here !/3. Formatting PivotTables/2. Number formatting with PivotTables.srt

5.6 kB

~Get Your Files Here !/3. Formatting PivotTables/2.1 Pivot_Example_Data_201.xlsx

503 kB

~Get Your Files Here !/3. Formatting PivotTables/3. Table layout and customizing the view.mp4

117 MB

~Get Your Files Here !/3. Formatting PivotTables/3. Table layout and customizing the view.srt

19 kB

~Get Your Files Here !/3. Formatting PivotTables/3.1 Pivot_Example_Data_202.xlsx

507 kB

~Get Your Files Here !/3. Formatting PivotTables/4. Using tabular layout to create exportable data sets.mp4

26 MB

~Get Your Files Here !/3. Formatting PivotTables/4. Using tabular layout to create exportable data sets.srt

4.2 kB

~Get Your Files Here !/3. Formatting PivotTables/4.1 Pivot_Example_Data_203.xlsx

506 kB

~Get Your Files Here !/3. Formatting PivotTables/5. Creating custom PivotTable styles.mp4

88 MB

~Get Your Files Here !/3. Formatting PivotTables/5. Creating custom PivotTable styles.srt

14 kB

~Get Your Files Here !/3. Formatting PivotTables/5.1 Pivot_Example_Data_204.xlsx

507 kB

~Get Your Files Here !/3. Formatting PivotTables/6. Changing labels inside of a PivotTable.mp4

23 MB

~Get Your Files Here !/3. Formatting PivotTables/6. Changing labels inside of a PivotTable.srt

4.5 kB

~Get Your Files Here !/3. Formatting PivotTables/6.1 Pivot_Example_Data_205.xlsx

506 kB

~Get Your Files Here !/3. Formatting PivotTables/7. Conditional formatting to show the highest values.mp4

35 MB

~Get Your Files Here !/3. Formatting PivotTables/7. Conditional formatting to show the highest values.srt

6.7 kB

~Get Your Files Here !/3. Formatting PivotTables/7.1 Pivot_Example_Data_206.xlsx

504 kB

~Get Your Files Here !/3. Formatting PivotTables/8. Highlighting top and bottom values using conditional formatting.mp4

53 MB

~Get Your Files Here !/3. Formatting PivotTables/8. Highlighting top and bottom values using conditional formatting.srt

10 kB

~Get Your Files Here !/3. Formatting PivotTables/8.1 Pivot_Example_Data_207.xlsx

505 kB

~Get Your Files Here !/3. Formatting PivotTables/9. Visualization with data bars.mp4

61 MB

~Get Your Files Here !/3. Formatting PivotTables/9. Visualization with data bars.srt

8.6 kB

~Get Your Files Here !/3. Formatting PivotTables/9.1 Pivot_Example_Data_208.xlsx

505 kB

~Get Your Files Here !/4. Sorting, Filtering and Grouping with PivotTables/1. Intro - Sorting, Filtering and Grouping.mp4

13 MB

~Get Your Files Here !/4. Sorting, Filtering and Grouping with PivotTables/1. Intro - Sorting, Filtering and Grouping.srt

1.4 kB

~Get Your Files Here !/4. Sorting, Filtering and Grouping with PivotTables/10. Automatic date grouping and options.mp4

65 MB

~Get Your Files Here !/4. Sorting, Filtering and Grouping with PivotTables/10. Automatic date grouping and options.srt

11 kB

~Get Your Files Here !/4. Sorting, Filtering and Grouping with PivotTables/10.1 Pivot_Example_Data_308.xlsx

722 kB

~Get Your Files Here !/4. Sorting, Filtering and Grouping with PivotTables/11. Visual filtering using slicers.mp4

73 MB

~Get Your Files Here !/4. Sorting, Filtering and Grouping with PivotTables/11. Visual filtering using slicers.srt

9.9 kB

~Get Your Files Here !/4. Sorting, Filtering and Grouping with PivotTables/11.1 Pivot_Example_Data_309.xlsx

658 kB

~Get Your Files Here !/4. Sorting, Filtering and Grouping with PivotTables/12. Visual date filtering using timelines.mp4

58 MB

~Get Your Files Here !/4. Sorting, Filtering and Grouping with PivotTables/12. Visual date filtering using timelines.srt

7.7 kB

~Get Your Files Here !/4. Sorting, Filtering and Grouping with PivotTables/12.1 Pivot_Example_Data_310.xlsx

660 kB

~Get Your Files Here !/4. Sorting, Filtering and Grouping with PivotTables/13. Creating and showing report filter pages.mp4

51 MB

~Get Your Files Here !/4. Sorting, Filtering and Grouping with PivotTables/13. Creating and showing report filter pages.srt

7.5 kB

~Get Your Files Here !/4. Sorting, Filtering and Grouping with PivotTables/13.1 Pivot_Example_Data_311.xlsx

656 kB

~Get Your Files Here !/4. Sorting, Filtering and Grouping with PivotTables/2. Overview of the different sorting options.mp4

60 MB

~Get Your Files Here !/4. Sorting, Filtering and Grouping with PivotTables/2. Overview of the different sorting options.srt

9.0 kB

~Get Your Files Here !/4. Sorting, Filtering and Grouping with PivotTables/2.1 Pivot_Example_Data_301.xlsx

517 kB

~Get Your Files Here !/4. Sorting, Filtering and Grouping with PivotTables/3. Sorting by custom lists.mp4

52 MB

~Get Your Files Here !/4. Sorting, Filtering and Grouping with PivotTables/3. Sorting by custom lists.srt

7.9 kB

~Get Your Files Here !/4. Sorting, Filtering and Grouping with PivotTables/3.1 Pivot_Example_Data_302.xlsx

506 kB

~Get Your Files Here !/4. Sorting, Filtering and Grouping with PivotTables/4. Filtering with manual selections and label filters.mp4

92 MB

~Get Your Files Here !/4. Sorting, Filtering and Grouping with PivotTables/4. Filtering with manual selections and label filters.srt

19 kB

~Get Your Files Here !/4. Sorting, Filtering and Grouping with PivotTables/4.1 Pivot_Example_Data_303.xlsx

501 kB

~Get Your Files Here !/4. Sorting, Filtering and Grouping with PivotTables/5. Pro tip for faster manual selection filters.mp4

19 MB

~Get Your Files Here !/4. Sorting, Filtering and Grouping with PivotTables/5. Pro tip for faster manual selection filters.srt

3.0 kB

~Get Your Files Here !/4. Sorting, Filtering and Grouping with PivotTables/5.1 Pivot_Example_Data_303.5.xlsx

561 kB

~Get Your Files Here !/4. Sorting, Filtering and Grouping with PivotTables/6. Filtering with wildcards.mp4

59 MB

~Get Your Files Here !/4. Sorting, Filtering and Grouping with PivotTables/6. Filtering with wildcards.srt

10 kB

~Get Your Files Here !/4. Sorting, Filtering and Grouping with PivotTables/6.1 Pivot_Example_Data_304.xlsx

642 kB

~Get Your Files Here !/4. Sorting, Filtering and Grouping with PivotTables/7. Using value filters.mp4

43 MB

~Get Your Files Here !/4. Sorting, Filtering and Grouping with PivotTables/7. Using value filters.srt

6.8 kB

~Get Your Files Here !/4. Sorting, Filtering and Grouping with PivotTables/7.1 Pivot_Example_Data_305.xlsx

642 kB

~Get Your Files Here !/4. Sorting, Filtering and Grouping with PivotTables/8. Using multiple filters simultaneously.mp4

38 MB

~Get Your Files Here !/4. Sorting, Filtering and Grouping with PivotTables/8. Using multiple filters simultaneously.srt

6.0 kB

~Get Your Files Here !/4. Sorting, Filtering and Grouping with PivotTables/8.1 Pivot_Example_Data_306.xlsx

642 kB

~Get Your Files Here !/4. Sorting, Filtering and Grouping with PivotTables/9. Creating custom groups in a PivotTable.mp4

39 MB

~Get Your Files Here !/4. Sorting, Filtering and Grouping with PivotTables/9. Creating custom groups in a PivotTable.srt

7.2 kB

~Get Your Files Here !/4. Sorting, Filtering and Grouping with PivotTables/9.1 Pivot_Example_Data_307.xlsx

746 kB

~Get Your Files Here !/5. Working with values in PivotTables/1. Intro - Working with values.mp4

11 MB

~Get Your Files Here !/5. Working with values in PivotTables/1. Intro - Working with values.srt

772 B

~Get Your Files Here !/5. Working with values in PivotTables/2. Summarizing values by different methods.mp4

52 MB

~Get Your Files Here !/5. Working with values in PivotTables/2. Summarizing values by different methods.srt

7.4 kB

~Get Your Files Here !/5. Working with values in PivotTables/2.1 Pivot_Example_Data_401.xlsx

656 kB

~Get Your Files Here !/5. Working with values in PivotTables/3. Show values as... options.mp4

93 MB

~Get Your Files Here !/5. Working with values in PivotTables/3. Show values as... options.srt

13 kB

~Get Your Files Here !/5. Working with values in PivotTables/3.1 Pivot_Example_Data_402.xlsx

656 kB

~Get Your Files Here !/5. Working with values in PivotTables/4. Show values as % of parent total.mp4

54 MB

~Get Your Files Here !/5. Working with values in PivotTables/4. Show values as % of parent total.srt

7.9 kB

~Get Your Files Here !/5. Working with values in PivotTables/4.1 Pivot_Example_Data_403.xlsx

665 kB

~Get Your Files Here !/5. Working with values in PivotTables/5. Show values as difference.mp4

54 MB

~Get Your Files Here !/5. Working with values in PivotTables/5. Show values as difference.srt

7.5 kB

~Get Your Files Here !/5. Working with values in PivotTables/5.1 Pivot_Example_Data_404.xlsx

663 kB

~Get Your Files Here !/5. Working with values in PivotTables/6. Show values as running totals.mp4

32 MB

~Get Your Files Here !/5. Working with values in PivotTables/6. Show values as running totals.srt

4.8 kB

~Get Your Files Here !/5. Working with values in PivotTables/6.1 Pivot_Example_Data_405.xlsx

664 kB

~Get Your Files Here !/5. Working with values in PivotTables/7. Show values as rank.mp4

24 MB

~Get Your Files Here !/5. Working with values in PivotTables/7. Show values as rank.srt

4.4 kB

~Get Your Files Here !/5. Working with values in PivotTables/7.1 Pivot_Example_Data_406.xlsx

665 kB

~Get Your Files Here !/5. Working with values in PivotTables/8. Visual improvements for large PivotTables.mp4

63 MB

~Get Your Files Here !/5. Working with values in PivotTables/8. Visual improvements for large PivotTables.srt

8.8 kB

~Get Your Files Here !/5. Working with values in PivotTables/8.1 Pivot_Example_Data_407.xlsx

666 kB

~Get Your Files Here !/5. Working with values in PivotTables/9. Show values as index with example.mp4

98 MB

~Get Your Files Here !/5. Working with values in PivotTables/9. Show values as index with example.srt

17 kB

~Get Your Files Here !/5. Working with values in PivotTables/9.1 Pivot_Example_Data_406.5.xlsx

34 kB

~Get Your Files Here !/6. Working with calculated fields in PivotTables/1. Intro - Calculated Fields.mp4

17 MB

~Get Your Files Here !/6. Working with calculated fields in PivotTables/1. Intro - Calculated Fields.srt

1.1 kB

~Get Your Files Here !/6. Working with calculated fields in PivotTables/2. Using calculated fields in PivotTables.mp4

76 MB

~Get Your Files Here !/6. Working with calculated fields in PivotTables/2. Using calculated fields in PivotTables.srt

11 kB

~Get Your Files Here !/6. Working with calculated fields in PivotTables/2.1 Pivot_Example_Data_501.xlsx

657 kB

~Get Your Files Here !/6. Working with calculated fields in PivotTables/3. Using count in calculated fields.mp4

69 MB

~Get Your Files Here !/6. Working with calculated fields in PivotTables/3. Using count in calculated fields.srt

9.3 kB

~Get Your Files Here !/6. Working with calculated fields in PivotTables/3.1 Pivot_Example_Data_502.xlsx

671 kB

~Get Your Files Here !/7. Visualizing data analysis with PivotCharts & Dashboards/1. Intro - PivotCharts and Dashboards.mp4

14 MB

~Get Your Files Here !/7. Visualizing data analysis with PivotCharts & Dashboards/1. Intro - PivotCharts and Dashboards.srt

1.1 kB

~Get Your Files Here !/7. Visualizing data analysis with PivotCharts & Dashboards/2. Creating PivotCharts.mp4

43 MB

~Get Your Files Here !/7. Visualizing data analysis with PivotCharts & Dashboards/2. Creating PivotCharts.srt

7.6 kB

~Get Your Files Here !/7. Visualizing data analysis with PivotCharts & Dashboards/2.1 Pivot_Example_Data_601.xlsx

675 kB

~Get Your Files Here !/7. Visualizing data analysis with PivotCharts & Dashboards/3. Pie Charts and using multiple PivotCharts.mp4

75 MB

~Get Your Files Here !/7. Visualizing data analysis with PivotCharts & Dashboards/3. Pie Charts and using multiple PivotCharts.srt

13 kB

~Get Your Files Here !/7. Visualizing data analysis with PivotCharts & Dashboards/3.1 Pivot_Example_Data_602.xlsx

675 kB

~Get Your Files Here !/7. Visualizing data analysis with PivotCharts & Dashboards/4. Visually improving PivotCharts.mp4

59 MB

~Get Your Files Here !/7. Visualizing data analysis with PivotCharts & Dashboards/4. Visually improving PivotCharts.srt

12 kB

~Get Your Files Here !/7. Visualizing data analysis with PivotCharts & Dashboards/4.1 Pivot_Example_Data_603.xlsx

685 kB

~Get Your Files Here !/7. Visualizing data analysis with PivotCharts & Dashboards/5. Multiple dimensions in PivotCharts.mp4

66 MB

~Get Your Files Here !/7. Visualizing data analysis with PivotCharts & Dashboards/5. Multiple dimensions in PivotCharts.srt

10 kB

~Get Your Files Here !/7. Visualizing data analysis with PivotCharts & Dashboards/5.1 Pivot_Example_Data_604.xlsx

685 kB

~Get Your Files Here !/7. Visualizing data analysis with PivotCharts & Dashboards/6. Filtering PivotCharts using timelines and slicers.mp4

33 MB

~Get Your Files Here !/7. Visualizing data analysis with PivotCharts & Dashboards/6. Filtering PivotCharts using timelines and slicers.srt

5.4 kB

~Get Your Files Here !/7. Visualizing data analysis with PivotCharts & Dashboards/6.1 Pivot_Example_Data_605.xlsx

695 kB

~Get Your Files Here !/7. Visualizing data analysis with PivotCharts & Dashboards/7. Creating a dashboard from PivotCharts.mp4

72 MB

~Get Your Files Here !/7. Visualizing data analysis with PivotCharts & Dashboards/7. Creating a dashboard from PivotCharts.srt

12 kB

~Get Your Files Here !/7. Visualizing data analysis with PivotCharts & Dashboards/7.1 Pivot_Example_Data_606.xlsx

695 kB

~Get Your Files Here !/7. Visualizing data analysis with PivotCharts & Dashboards/8. Visually improving the dashboard.mp4

58 MB

~Get Your Files Here !/7. Visualizing data analysis with PivotCharts & Dashboards/8. Visually improving the dashboard.srt

9.5 kB

~Get Your Files Here !/7. Visualizing data analysis with PivotCharts & Dashboards/8.1 Pivot_Example_Data_607.xlsx

696 kB

~Get Your Files Here !/7. Visualizing data analysis with PivotCharts & Dashboards/9. Printing the dashboard.mp4

25 MB

~Get Your Files Here !/7. Visualizing data analysis with PivotCharts & Dashboards/9. Printing the dashboard.srt

5.3 kB

~Get Your Files Here !/7. Visualizing data analysis with PivotCharts & Dashboards/9.1 Pivot_Example_Data_608.xlsx

697 kB

~Get Your Files Here !/Bonus Resources.txt

386 B