| 1. Intro - Calculated Fields.mp4 | 16.9 MB | ||
| 1. Intro - Calculated Fields.srt | 1.1 KB | ||
| 1. Intro - Formatting PivotTables.mp4 | 7.8 MB | ||
| 1. Intro - Formatting PivotTables.srt | 614.4 B | ||
| 1. Intro - PivotCharts and Dashboards.mp4 | 14.2 MB | ||
| 1. Intro - PivotCharts and Dashboards.srt | 1.1 KB | ||
| 1. Intro - Sorting, Filtering and Grouping.mp4 | 12.7 MB | ||
| 1. Intro - Sorting, Filtering and Grouping.srt | 1.4 KB | ||
| 1. Intro - Working with values.mp4 | 11.1 MB | ||
| 1. Intro - Working with values.srt | 819.2 B | ||
| 1. Overview and download of the example data file.mp4 | 43.2 MB | ||
| 1. Overview and download of the example data file.srt | 4.3 KB | ||
| 1. Welcome to the course!.mp4 | 20.6 MB | ||
| 1. Welcome to the course!.srt | 1.5 KB | ||
| 1.1 Pivot_Example_Data_101.xlsx | 362.7 KB | ||
| 10. Automatic date grouping and options.mp4 | 65.1 MB | ||
| 10. Automatic date grouping and options.srt | 11 KB | ||
| 10. Pro tip for generating filtered subsets of data.mp4 | 32.1 MB | ||
| 10. Pro tip for generating filtered subsets of data.srt | 5.5 KB | ||
| 10. Visualization with icon sets and color scales.mp4 | 46.7 MB | ||
| 10. Visualization with icon sets and color scales.srt | 7.6 KB | ||
| 10.1 Pivot_Example_Data_110.xlsx | 503 KB | ||
| 10.1 Pivot_Example_Data_209.xlsx | 504.6 KB | ||
| 10.1 Pivot_Example_Data_308.xlsx | 722.4 KB | ||
| 11. Conditional formatting specifically for PivotTables.mp4 | 48.1 MB | ||
| 11. Conditional formatting specifically for PivotTables.srt | 7.9 KB | ||
| 11. Visual filtering using slicers.mp4 | 73 MB | ||
| 11. Visual filtering using slicers.srt | 9.9 KB | ||
| 11.1 Pivot_Example_Data_210.xlsx | 504.8 KB | ||
| 11.1 Pivot_Example_Data_309.xlsx | 658.3 KB | ||
| 12. Preventing PivotTables from resizing on update.mp4 | 34.5 MB | ||
| 12. Preventing PivotTables from resizing on update.srt | 5.7 KB | ||
| 12. Visual date filtering using timelines.mp4 | 58.1 MB | ||
| 12. Visual date filtering using timelines.srt | 7.7 KB | ||
| 12.1 Pivot_Example_Data_211.xlsx | 504.9 KB | ||
| 12.1 Pivot_Example_Data_310.xlsx | 660 KB | ||
| 13. Creating and showing report filter pages.mp4 | 50.9 MB | ||
| 13. Creating and showing report filter pages.srt | 7.5 KB | ||
| 13.1 Pivot_Example_Data_311.xlsx | 655.9 KB | ||
| 2. Creating PivotCharts.mp4 | 42.7 MB | ||
| 2. Creating PivotCharts.srt | 7.6 KB | ||
| 2. Number formatting with PivotTables.mp4 | 37.8 MB | ||
| 2. Number formatting with PivotTables.srt | 5.6 KB | ||
| 2. Overview of the different sorting options.mp4 | 59.5 MB | ||
| 2. Overview of the different sorting options.srt | 9 KB | ||
| 2. Structuring the source data.mp4 | 123.2 MB | ||
| 2. Structuring the source data.srt | 11.3 KB | ||
| 2. Summarizing values by different methods.mp4 | 52 MB | ||
| 2. Summarizing values by different methods.srt | 7.4 KB | ||
| 2. Using calculated fields in PivotTables.mp4 | 76 MB | ||
| 2. Using calculated fields in PivotTables.srt | 11.3 KB | ||
| 2. Why PivotTables What are they good for.mp4 | 58.2 MB | ||
| 2. Why PivotTables What are they good for.srt | 4 KB | ||
| 2.1 Pivot_Example_Data_102.xlsx | 361.9 KB | ||
| 2.1 Pivot_Example_Data_201.xlsx | 503.3 KB | ||
| 2.1 Pivot_Example_Data_301.xlsx | 517 KB | ||
| 2.1 Pivot_Example_Data_401.xlsx | 655.7 KB | ||
| 2.1 Pivot_Example_Data_501.xlsx | 656.9 KB | ||
| 2.1 Pivot_Example_Data_601.xlsx | 675 KB | ||
| 3. Creating and inserting PivotTables in Microsoft Excel.mp4 | 50.3 MB | ||
| 3. Creating and inserting PivotTables in Microsoft Excel.srt | 5.1 KB | ||
| 3. Pie Charts and using multiple PivotCharts.mp4 | 75.4 MB | ||
| 3. Pie Charts and using multiple PivotCharts.srt | 13.1 KB | ||
| 3. Show values as... options.mp4 | 92.9 MB | ||
| 3. Show values as... options.srt | 13.1 KB | ||
| 3. Sorting by custom lists.mp4 | 51.5 MB | ||
| 3. Sorting by custom lists.srt | 7.9 KB | ||
| 3. Table layout and customizing the view.mp4 | 117.3 MB | ||
| 3. Table layout and customizing the view.srt | 19.1 KB | ||
| 3. Using count in calculated fields.mp4 | 69.2 MB | ||
| 3. Using count in calculated fields.srt | 9.3 KB | ||
| 3.1 Pivot_Example_Data_103.xlsx | 506.9 KB | ||
| 3.1 Pivot_Example_Data_202.xlsx | 507.2 KB | ||
| 3.1 Pivot_Example_Data_302.xlsx | 506 KB | ||
| 3.1 Pivot_Example_Data_402.xlsx | 656.1 KB | ||
| 3.1 Pivot_Example_Data_502.xlsx | 671.2 KB | ||
| 3.1 Pivot_Example_Data_602.xlsx | 675 KB | ||
| 4. Filtering with manual selections and label filters.mp4 | 92.3 MB | ||
| 4. Filtering with manual selections and label filters.srt | 18.9 KB | ||
| 4. Show values as % of parent total.mp4 | 53.5 MB | ||
| 4. Show values as % of parent total.srt | 7.9 KB | ||
| 4. The PivotTable fields explained.mp4 | 144.6 MB | ||
| 4. The PivotTable fields explained.srt | 23.7 KB | ||
| 4. Using tabular layout to create exportable data sets.mp4 | 25.6 MB | ||
| 4. Using tabular layout to create exportable data sets.srt | 4.2 KB | ||
| 4. Visually improving PivotCharts.mp4 | 59.2 MB | ||
| 4. Visually improving PivotCharts.srt | 11.8 KB | ||
| 4.1 Pivot_Example_Data_104.xlsx | 496.8 KB | ||
| 4.1 Pivot_Example_Data_203.xlsx | 506.2 KB | ||
| 4.1 Pivot_Example_Data_303.xlsx | 500.9 KB | ||
| 4.1 Pivot_Example_Data_403.xlsx | 664.7 KB | ||
| 4.1 Pivot_Example_Data_603.xlsx | 685 KB | ||
| 5. Creating custom PivotTable styles.mp4 | 87.5 MB | ||
| 5. Creating custom PivotTable styles.srt | 14.3 KB | ||
| 5. Multiple dimensions in PivotCharts.mp4 | 65.8 MB | ||
| 5. Multiple dimensions in PivotCharts.srt | 10.4 KB | ||
| 5. PivotTable tabs in the Excel ribbon.mp4 | 19.1 MB | ||
| 5. PivotTable tabs in the Excel ribbon.srt | 3 KB | ||
| 5. Pro tip for faster manual selection filters.mp4 | 19.3 MB | ||
| 5. Pro tip for faster manual selection filters.srt | 3 KB | ||
| 5. Show values as difference.mp4 | 53.7 MB | ||
| 5. Show values as difference.srt | 7.5 KB | ||
| 5.1 Pivot_Example_Data_105.xlsx | 496.8 KB | ||
| 5.1 Pivot_Example_Data_204.xlsx | 506.8 KB | ||
| 5.1 Pivot_Example_Data_303.5.xlsx | 560.8 KB | ||
| 5.1 Pivot_Example_Data_404.xlsx | 662.6 KB | ||
| 5.1 Pivot_Example_Data_604.xlsx | 685 KB | ||
| 6. Changing labels inside of a PivotTable.mp4 | 22.7 MB | ||
| 6. Changing labels inside of a PivotTable.srt | 4.5 KB | ||
| 6. Filtering PivotCharts using timelines and slicers.mp4 | 33.1 MB | ||
| 6. Filtering PivotCharts using timelines and slicers.srt | 5.4 KB | ||
| 6. Filtering with wildcards.mp4 | 59.1 MB | ||
| 6. Filtering with wildcards.srt | 10.3 KB | ||
| 6. PivotTable actions and how we can use them.mp4 | 61.9 MB | ||
| 6. PivotTable actions and how we can use them.srt | 10.3 KB | ||
| 6. Show values as running totals.mp4 | 32.5 MB | ||
| 6. Show values as running totals.srt | 4.8 KB | ||
| 6.1 Pivot_Example_Data_106.xlsx | 495.8 KB | ||
| 6.1 Pivot_Example_Data_205.xlsx | 506.5 KB | ||
| 6.1 Pivot_Example_Data_304.xlsx | 642 KB | ||
| 6.1 Pivot_Example_Data_405.xlsx | 664.1 KB | ||
| 6.1 Pivot_Example_Data_605.xlsx | 694.9 KB | ||
| 7. Conditional formatting to show the highest values.mp4 | 35.4 MB | ||
| 7. Conditional formatting to show the highest values.srt | 6.7 KB | ||
| 7. Creating a dashboard from PivotCharts.mp4 | 72.5 MB | ||
| 7. Creating a dashboard from PivotCharts.srt | 11.5 KB | ||
| 7. Refreshing and Changing the data source for PivotTables.mp4 | 115.2 MB | ||
| 7. Refreshing and Changing the data source for PivotTables.srt | 12.5 KB | ||
| 7. Show values as rank.mp4 | 24.5 MB | ||
| 7. Show values as rank.srt | 4.4 KB | ||
| 7. Using value filters.mp4 | 42.7 MB | ||
| 7. Using value filters.srt | 6.8 KB | ||
| 7.1 Pivot_Example_Data_107.xlsx | 500.7 KB | ||
| 7.1 Pivot_Example_Data_206.xlsx | 504.5 KB | ||
| 7.1 Pivot_Example_Data_305.xlsx | 641.5 KB | ||
| 7.1 Pivot_Example_Data_406.xlsx | 664.6 KB | ||
| 7.1 Pivot_Example_Data_606.xlsx | 695.4 KB | ||
| 8. Highlighting top and bottom values using conditional formatting.mp4 | 52.9 MB | ||
| 8. Highlighting top and bottom values using conditional formatting.srt | 10.2 KB | ||
| 8. Tips for working with growing source data.mp4 | 137.7 MB | ||
| 8. Tips for working with growing source data.srt | 16 KB | ||
| 8. Using multiple filters simultaneously.mp4 | 38.1 MB | ||
| 8. Using multiple filters simultaneously.srt | 6 KB | ||
| 8. Visual improvements for large PivotTables.mp4 | 63.2 MB | ||
| 8. Visual improvements for large PivotTables.srt | 8.8 KB | ||
| 8. Visually improving the dashboard.mp4 | 57.8 MB | ||
| 8. Visually improving the dashboard.srt | 9.5 KB | ||
| 8.1 Pivot_Example_Data_108.xlsx | 503.1 KB | ||
| 8.1 Pivot_Example_Data_207.xlsx | 504.6 KB | ||
| 8.1 Pivot_Example_Data_306.xlsx | 642.1 KB | ||
| 8.1 Pivot_Example_Data_407.xlsx | 666.3 KB | ||
| 8.1 Pivot_Example_Data_607.xlsx | 696.1 KB | ||
| 9. Creating custom groups in a PivotTable.mp4 | 38.9 MB | ||
| 9. Creating custom groups in a PivotTable.srt | 7.2 KB | ||
| 9. Printing the dashboard.mp4 | 24.8 MB | ||
| 9. Printing the dashboard.srt | 5.3 KB | ||
| 9. Show values as index with example.mp4 | 97.9 MB | ||
| 9. Show values as index with example.srt | 17 KB | ||
| 9. The PivotTable Cache explained.mp4 | 116.3 MB | ||
| 9. The PivotTable Cache explained.srt | 15.4 KB | ||
| 9. Visualization with data bars.mp4 | 60.6 MB | ||
| 9. Visualization with data bars.srt | 8.6 KB | ||
| 9.1 Pivot_Example_Data_109_End.xlsx | 493.2 KB | ||
| 9.1 Pivot_Example_Data_208.xlsx | 505 KB | ||
| 9.1 Pivot_Example_Data_307.xlsx | 746.4 KB | ||
| 9.1 Pivot_Example_Data_406.5.xlsx | 34 KB | ||
| 9.1 Pivot_Example_Data_608.xlsx | 696.9 KB | ||
| 9.2 Pivot_Example_Data_109_Start.xlsx | 503 KB | ||
| Bonus Resources.txt | 409.6 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 170 total files | |||
Office Fundamentals - PivotTables in Microsoft Excel
https://DevCourseWeb.com
Genre: eLearning | MP4 | Video: h264, 1280x720 | Audio: AAC, 48.0 KHz
Language: English | Size: 3.20 GB | Duration: 5h 44m
Learn everything about creating and using PivotTables in Excel to analyze data and plot with PivotCharts & dashboards
What you'll learn
Properly structure raw data for analysis with Pivot
Insert and create PivotTables
Editing PivotTable fields
Analysis and organization of data
Sort, filter, and group pivot data
Working with values in PivotTables
Calculations with calculated fields
Create visual representations with PivotCharts & Dashboards
Requirements
A PC
Microsoft Excel
Description
Pivot tables are a quick and easy way to organize, summarize, and analyze raw data.
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 848.4 MB | freecoursewb | 1 month | 0 | 0 | |
| 2 GB | freecoursewb | 2 months | 0 | 0 | |
| 1 GB | freecoursewb | 2 months | 20 | 5 | |
| 399.4 MB | freecoursewb | 2 months | 1 | 18 | |
|
Udemy - Excel, Word and PowerPoint in One Course - Become Office Ready Posted by
freecoursewb in Other
|
2 GB | freecoursewb | 3 months | 6 | 11 |
All Comments