[ DevCourseWeb Com ] Udemy - The Best Excel Pivot Tables Course in the World
File List
| File | Size |
|---|---|
| Get Bonus Downloads Here.url | 182 B |
| ~Get Your Files Here !/01 - How to learn Excel/001 The New Excel Learning Curve.mp4 | 57.38 MB |
| ~Get Your Files Here !/02 - Lesson 1. Introduction to pivot tables/001 1-solution.xlsx | 4.24 MB |
| ~Get Your Files Here !/02 - Lesson 1. Introduction to pivot tables/001 1.1. My first pivot table.mp4 | 83.41 MB |
| ~Get Your Files Here !/02 - Lesson 1. Introduction to pivot tables/002 1.2. Insert a pivot table - DIY exercise.mp4 | 27.98 MB |
| ~Get Your Files Here !/02 - Lesson 1. Introduction to pivot tables/003 1.3. Pivot table refresh range vs table.mp4 | 166.59 MB |
| ~Get Your Files Here !/02 - Lesson 1. Introduction to pivot tables/004 1.4. How to prepare data for a pivot table.mp4 | 58.19 MB |
| ~Get Your Files Here !/02 - Lesson 1. Introduction to pivot tables/004 1.4.wrong-data-source-solution.xlsx | 36.51 KB |
| ~Get Your Files Here !/02 - Lesson 1. Introduction to pivot tables/004 1.4.wrong-data-source.xlsx | 13.5 KB |
| ~Get Your Files Here !/03 - Lesson 2. Basic calculations in a pivot table/001 2-solution.xlsx | 3.37 MB |
| ~Get Your Files Here !/03 - Lesson 2. Basic calculations in a pivot table/001 2.1. Sum, Count, Average.mp4 | 83.7 MB |
| ~Get Your Files Here !/03 - Lesson 2. Basic calculations in a pivot table/002 2.2. DIY Summarize values by.mp4 | 35.96 MB |
| ~Get Your Files Here !/03 - Lesson 2. Basic calculations in a pivot table/003 2.3-solution.xlsx | 12.9 KB |
| ~Get Your Files Here !/03 - Lesson 2. Basic calculations in a pivot table/003 2.3. How does the average work.mp4 | 29.57 MB |
| ~Get Your Files Here !/03 - Lesson 2. Basic calculations in a pivot table/003 2.3.xlsx | 9.51 KB |
| ~Get Your Files Here !/03 - Lesson 2. Basic calculations in a pivot table/004 2.4. Drill down - viewing the source data.mp4 | 36.72 MB |
| ~Get Your Files Here !/04 - Lesson 3. Layout, formatting and sorting of a pivot table/001 3-solution.xlsx | 2.82 MB |
| ~Get Your Files Here !/04 - Lesson 3. Layout, formatting and sorting of a pivot table/001 3.1. Auto grouping (+ -), grand totals and subtotals.mp4 | 50.28 MB |
| ~Get Your Files Here !/04 - Lesson 3. Layout, formatting and sorting of a pivot table/002 3.2. Changing the report layout.mp4 | 48.39 MB |
| ~Get Your Files Here !/04 - Lesson 3. Layout, formatting and sorting of a pivot table/003 3.3. Automatic and manual sorting.mp4 | 51.74 MB |
| ~Get Your Files Here !/04 - Lesson 3. Layout, formatting and sorting of a pivot table/004 3.4. DIY Pivot table layout.mp4 | 53.7 MB |
| ~Get Your Files Here !/05 - Lesson 4. Grouping a pivot table/001 4-solution.xlsx | 2.43 MB |
| ~Get Your Files Here !/05 - Lesson 4. Grouping a pivot table/001 4.1. Manual grouping.mp4 | 56.18 MB |
| ~Get Your Files Here !/05 - Lesson 4. Grouping a pivot table/002 4.2. Grouping dates.mp4 | 54.18 MB |
| ~Get Your Files Here !/05 - Lesson 4. Grouping a pivot table/003 4.3-problem-with-dates.xlsx | 14.94 KB |
| ~Get Your Files Here !/05 - Lesson 4. Grouping a pivot table/003 4.3-solution.xlsx | 16 KB |
| ~Get Your Files Here !/05 - Lesson 4. Grouping a pivot table/003 4.3. Problems with date grouping.mp4 | 13.67 MB |
| ~Get Your Files Here !/05 - Lesson 4. Grouping a pivot table/004 4.4. Grouping values.mp4 | 29.61 MB |
| ~Get Your Files Here !/05 - Lesson 4. Grouping a pivot table/005 4.5. DIY Grouping TOP 5 vs Others.mp4 | 35.83 MB |
| ~Get Your Files Here !/06 - Lesson 5. Filtering a pivot table/001 5-solution.xlsx | 2.62 MB |
| ~Get Your Files Here !/06 - Lesson 5. Filtering a pivot table/001 5.1. Filters shelf.mp4 | 42.14 MB |
| ~Get Your Files Here !/06 - Lesson 5. Filtering a pivot table/002 5.2. Rows and columns filter - text, date, number.mp4 | 100.37 MB |
| ~Get Your Files Here !/06 - Lesson 5. Filtering a pivot table/003 5.3. Value filter and TOP N filter.mp4 | 57.18 MB |
| ~Get Your Files Here !/06 - Lesson 5. Filtering a pivot table/004 5.4. Generate report filter pages.mp4 | 23.44 MB |
| ~Get Your Files Here !/06 - Lesson 5. Filtering a pivot table/005 5.5. Slicer.mp4 | 122.54 MB |
| ~Get Your Files Here !/06 - Lesson 5. Filtering a pivot table/006 5.6. Timeline.mp4 | 19.09 MB |
| ~Get Your Files Here !/06 - Lesson 5. Filtering a pivot table/007 5.7. DIY Week slicer.mp4 | 27.98 MB |
| ~Get Your Files Here !/07 - Lesson 6. Pivot charts/001 6-solution.xlsx | 2.43 MB |
| ~Get Your Files Here !/07 - Lesson 6. Pivot charts/001 6.1. Column chart.mp4 | 56.52 MB |
| ~Get Your Files Here !/07 - Lesson 6. Pivot charts/002 6.2. Line chart.mp4 | 41.55 MB |
| ~Get Your Files Here !/07 - Lesson 6. Pivot charts/003 6.3. Combo chart and other charts.mp4 | 51.47 MB |
| ~Get Your Files Here !/07 - Lesson 6. Pivot charts/004 6.4. DIY Combo chart.mp4 | 31.83 MB |
| ~Get Your Files Here !/08 - Lesson 7. Show values as/001 7-solution.xlsx | 4.12 MB |
| ~Get Your Files Here !/08 - Lesson 7. Show values as/001 7.1. % of Grand total.mp4 | 23.81 MB |
| ~Get Your Files Here !/08 - Lesson 7. Show values as/002 7.2. % of Row total.mp4 | 18.66 MB |
| ~Get Your Files Here !/08 - Lesson 7. Show values as/003 7.3. % of Parent total.mp4 | 27.04 MB |
| ~Get Your Files Here !/08 - Lesson 7. Show values as/004 7.4. Year-on-Year % change.mp4 | 26.77 MB |
| ~Get Your Files Here !/08 - Lesson 7. Show values as/005 7.5. Running total.mp4 | 52.06 MB |
| ~Get Your Files Here !/08 - Lesson 7. Show values as/006 7.6. DIY Show values as.mp4 | 103.97 MB |
| ~Get Your Files Here !/09 - Lesson 8. Calculated field/001 8-solution.xlsx | 3.51 MB |
| ~Get Your Files Here !/09 - Lesson 8. Calculated field/001 8.1. Calculated field - multiplication.mp4 | 39.52 MB |
| ~Get Your Files Here !/09 - Lesson 8. Calculated field/002 8.2. Calculated field - division.mp4 | 60.57 MB |
| ~Get Your Files Here !/09 - Lesson 8. Calculated field/003 8.3. Rounding and list of formulas.mp4 | 27.68 MB |
| ~Get Your Files Here !/09 - Lesson 8. Calculated field/004 8.4. DIY Calculated Field.mp4 | 66.13 MB |
| ~Get Your Files Here !/10 - Lesson 9. Designing a dashboard on pivot tables/001 9-solution.xlsx | 48.99 KB |
| ~Get Your Files Here !/10 - Lesson 9. Designing a dashboard on pivot tables/001 9.1. Dashboard part 1 – Sales KPI.mp4 | 16.89 MB |
| ~Get Your Files Here !/10 - Lesson 9. Designing a dashboard on pivot tables/001 9.xlsx | 22.5 KB |
| ~Get Your Files Here !/10 - Lesson 9. Designing a dashboard on pivot tables/002 9.2. Dashboard part 2 – Target realization %.mp4 | 11.81 MB |
| ~Get Your Files Here !/10 - Lesson 9. Designing a dashboard on pivot tables/003 9.3. Dashboard part 3 – Sales vs Target by years.mp4 | 22.68 MB |
| ~Get Your Files Here !/10 - Lesson 9. Designing a dashboard on pivot tables/004 9.4. Dashboard part 4 – Target deviation %.mp4 | 17.82 MB |
| ~Get Your Files Here !/10 - Lesson 9. Designing a dashboard on pivot tables/005 9.5. Dashboard part 5 – Filtering and dashboard design.mp4 | 22.5 MB |
| ~Get Your Files Here !/11 - Lesson 10. Advanced slicers and filtering/001 10-solution.xlsx | 2.87 MB |
| ~Get Your Files Here !/11 - Lesson 10. Advanced slicers and filtering/001 10.1. Text slicer.mp4 | 45.83 MB |
| ~Get Your Files Here !/11 - Lesson 10. Advanced slicers and filtering/002 10.2. Date filter From-To.mp4 | 24.07 MB |
| ~Get Your Files Here !/11 - Lesson 10. Advanced slicers and filtering/003 10.3. Fiscal year slicer.mp4 | 39.67 MB |
| ~Get Your Files Here !/11 - Lesson 10. Advanced slicers and filtering/004 10.4. Year and month slicer.mp4 | 29.2 MB |
| ~Get Your Files Here !/11 - Lesson 10. Advanced slicers and filtering/005 10.5. Last day slicer.mp4 | 24.55 MB |
| ~Get Your Files Here !/11 - Lesson 10. Advanced slicers and filtering/006 10.6. DIY Week of the year slicer.mp4 | 20.02 MB |
| ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/001 11-solution.xlsx | 4.13 MB |
| ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/001 11.1. Distinct count.mp4 | 68.93 MB |
| ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/001 11v2-solution.xlsx | 2.4 MB |
| ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/002 11.2. Count in the calculated field.mp4 | 38.2 MB |
| ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/003 11.3. Calculated item.mp4 | 30.28 MB |
| ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/004 11.4. Calculated item on dates.mp4 | 53.78 MB |
| ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/005 11.5. GETPIVOTDATA formula.mp4 | 23.24 MB |
| ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/006 11.6. Sales vs Target as GETPIVOTDATA.mp4 | 15.39 MB |
| ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/007 11.7. Changing the aggregation of the subtotal.mp4 | 15.44 MB |
| ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/008 11.8-solution.xlsx | 17.24 KB |
| ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/008 11.8. Product.mp4 | 9.06 MB |
| ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/008 11.8.xlsx | 8.72 KB |
| ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/009 11.9-solution.xlsx | 18.73 KB |
| ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/009 11.9. Standard Deviation and Variance.mp4 | 17.21 MB |
| ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/009 11.9.xlsx | 8.82 KB |
| ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/010 11.10. Count Numbers.mp4 | 10.19 MB |
| ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/011 11.11. DIY Selecting a measure from the list.mp4 | 20.8 MB |
| ~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/001 12-solution.xlsx | 3.3 MB |
| ~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/001 12.1. Histogram in a column-line chart.mp4 | 66.1 MB |
| ~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/002 12.2. Conditional formatting.mp4 | 43.3 MB |
| ~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/003 12.3. Calendar heat map.mp4 | 42.37 MB |
| ~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/004 12.4. Cycle plot.mp4 | 18.24 MB |
| ~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/005 12.5. Gantt chart.mp4 | 51.7 MB |
| ~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/006 12.6. Constant line.mp4 | 15.64 MB |
| ~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/007 12.7. TOP 5 vs Others on the pie chart.mp4 | 22.26 MB |
| ~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/008 12.8. Cohort analysis.mp4 | 32.83 MB |
| ~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/009 12.9. Scatter plot.mp4 | 38.44 MB |
| ~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/010 12.10. Filled map.mp4 | 12.62 MB |
| ~Get Your Files Here !/14 - Lesson 13. Power tools for the pivot table user/001 13.1. Power Query.mp4 | 33.28 MB |
| ~Get Your Files Here !/14 - Lesson 13. Power tools for the pivot table user/002 13.2. Power Query animation.mp4 | 44.7 MB |
| ~Get Your Files Here !/14 - Lesson 13. Power tools for the pivot table user/003 13.3. Power Pivot.mp4 | 12.71 MB |
| ~Get Your Files Here !/14 - Lesson 13. Power tools for the pivot table user/004 13.4. Power BI.mp4 | 10.46 MB |
Trackers
No trackers found.