Name [ DevCourseWeb.com ] Udemy - The best Excel pivot tables course in the world

File Type video

Size 3.13GB

UpdateDate 2025-1-1

hash *****288619EB2AF48C97303868EC436B407A7C

Hot 20

Files Get Bonus Downloads Here.url | 182B ~Get Your Files Here !/01 - How to learn Excel/001 The New Excel Learning Curve.mp4 | 57.38MB ~Get Your Files Here !/02 - Lesson 1. Introduction to pivot tables/001 1-solution.xlsx | 4.24MB ~Get Your Files Here !/02 - Lesson 1. Introduction to pivot tables/001 1.1. My first pivot table.mp4 | 83.41MB ~Get Your Files Here !/02 - Lesson 1. Introduction to pivot tables/002 1.2. Insert a pivot table - DIY exercise.mp4 | 27.98MB ~Get Your Files Here !/02 - Lesson 1. Introduction to pivot tables/003 1.3. Pivot table refresh range vs table.mp4 | 166.59MB ~Get Your Files Here !/02 - Lesson 1. Introduction to pivot tables/004 1.4. How to prepare data for a pivot table.mp4 | 58.19MB ~Get Your Files Here !/02 - Lesson 1. Introduction to pivot tables/004 1.4.wrong-data-source-solution.xlsx | 36.51KB ~Get Your Files Here !/02 - Lesson 1. Introduction to pivot tables/004 1.4.wrong-data-source.xlsx | 13.50KB ~Get Your Files Here !/03 - Lesson 2. Basic calculations in a pivot table/001 2-solution.xlsx | 3.37MB ~Get Your Files Here !/03 - Lesson 2. Basic calculations in a pivot table/001 2.1. Sum, Count, Average.mp4 | 83.70MB ~Get Your Files Here !/03 - Lesson 2. Basic calculations in a pivot table/002 2.2. DIY Summarize values by.mp4 | 35.96MB ~Get Your Files Here !/03 - Lesson 2. Basic calculations in a pivot table/003 2.3-solution.xlsx | 12.90KB ~Get Your Files Here !/03 - Lesson 2. Basic calculations in a pivot table/003 2.3. How does the average work.mp4 | 29.57MB ~Get Your Files Here !/03 - Lesson 2. Basic calculations in a pivot table/003 2.3.xlsx | 9.51KB ~Get Your Files Here !/03 - Lesson 2. Basic calculations in a pivot table/004 2.4. Drill down - viewing the source data.mp4 | 36.72MB ~Get Your Files Here !/04 - Lesson 3. Layout, formatting and sorting of a pivot table/001 3-solution.xlsx | 2.82MB ~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.28MB ~Get Your Files Here !/04 - Lesson 3. Layout, formatting and sorting of a pivot table/002 3.2. Changing the report layout.mp4 | 48.39MB ~Get Your Files Here !/04 - Lesson 3. Layout, formatting and sorting of a pivot table/003 3.3. Automatic and manual sorting.mp4 | 51.74MB ~Get Your Files Here !/04 - Lesson 3. Layout, formatting and sorting of a pivot table/004 3.4. DIY Pivot table layout.mp4 | 53.70MB ~Get Your Files Here !/05 - Lesson 4. Grouping a pivot table/001 4-solution.xlsx | 2.43MB ~Get Your Files Here !/05 - Lesson 4. Grouping a pivot table/001 4.1. Manual grouping.mp4 | 56.18MB ~Get Your Files Here !/05 - Lesson 4. Grouping a pivot table/002 4.2. Grouping dates.mp4 | 54.18MB ~Get Your Files Here !/05 - Lesson 4. Grouping a pivot table/003 4.3-problem-with-dates.xlsx | 14.94KB ~Get Your Files Here !/05 - Lesson 4. Grouping a pivot table/003 4.3-solution.xlsx | 16.00KB ~Get Your Files Here !/05 - Lesson 4. Grouping a pivot table/003 4.3. Problems with date grouping.mp4 | 13.67MB ~Get Your Files Here !/05 - Lesson 4. Grouping a pivot table/004 4.4. Grouping values.mp4 | 29.61MB ~Get Your Files Here !/05 - Lesson 4. Grouping a pivot table/005 4.5. DIY Grouping TOP 5 vs Others.mp4 | 35.83MB ~Get Your Files Here !/06 - Lesson 5. Filtering a pivot table/001 5-solution.xlsx | 2.62MB ~Get Your Files Here !/06 - Lesson 5. Filtering a pivot table/001 5.1. Filters shelf.mp4 | 42.14MB ~Get Your Files Here !/06 - Lesson 5. Filtering a pivot table/002 5.2. Rows and columns filter - text, date, number.mp4 | 100.37MB ~Get Your Files Here !/06 - Lesson 5. Filtering a pivot table/003 5.3. Value filter and TOP N filter.mp4 | 57.18MB ~Get Your Files Here !/06 - Lesson 5. Filtering a pivot table/004 5.4. Generate report filter pages.mp4 | 23.44MB ~Get Your Files Here !/06 - Lesson 5. Filtering a pivot table/005 5.5. Slicer.mp4 | 122.54MB ~Get Your Files Here !/06 - Lesson 5. Filtering a pivot table/006 5.6. Timeline.mp4 | 19.09MB ~Get Your Files Here !/06 - Lesson 5. Filtering a pivot table/007 5.7. DIY Week slicer.mp4 | 27.98MB ~Get Your Files Here !/07 - Lesson 6. Pivot charts/001 6-solution.xlsx | 2.43MB ~Get Your Files Here !/07 - Lesson 6. Pivot charts/001 6.1. Column chart.mp4 | 56.52MB ~Get Your Files Here !/07 - Lesson 6. Pivot charts/002 6.2. Line chart.mp4 | 41.55MB ~Get Your Files Here !/07 - Lesson 6. Pivot charts/003 6.3. Combo chart and other charts.mp4 | 51.47MB ~Get Your Files Here !/07 - Lesson 6. Pivot charts/004 6.4. DIY Combo chart.mp4 | 31.83MB ~Get Your Files Here !/08 - Lesson 7. Show values as/001 7-solution.xlsx | 4.12MB ~Get Your Files Here !/08 - Lesson 7. Show values as/001 7.1. % of Grand total.mp4 | 23.81MB ~Get Your Files Here !/08 - Lesson 7. Show values as/002 7.2. % of Row total.mp4 | 18.66MB ~Get Your Files Here !/08 - Lesson 7. Show values as/003 7.3. % of Parent total.mp4 | 27.04MB ~Get Your Files Here !/08 - Lesson 7. Show values as/004 7.4. Year-on-Year % change.mp4 | 26.77MB ~Get Your Files Here !/08 - Lesson 7. Show values as/005 7.5. Running total.mp4 | 52.06MB ~Get Your Files Here !/08 - Lesson 7. Show values as/006 7.6. DIY Show values as.mp4 | 103.97MB ~Get Your Files Here !/09 - Lesson 8. Calculated field/001 8-solution.xlsx | 3.51MB ~Get Your Files Here !/09 - Lesson 8. Calculated field/001 8.1. Calculated field - multiplication.mp4 | 39.52MB ~Get Your Files Here !/09 - Lesson 8. Calculated field/002 8.2. Calculated field - division.mp4 | 60.57MB ~Get Your Files Here !/09 - Lesson 8. Calculated field/003 8.3. Rounding and list of formulas.mp4 | 27.68MB ~Get Your Files Here !/09 - Lesson 8. Calculated field/004 8.4. DIY Calculated Field.mp4 | 66.13MB ~Get Your Files Here !/10 - Lesson 9. Designing a dashboard on pivot tables/001 9-solution.xlsx | 48.99KB ~Get Your Files Here !/10 - Lesson 9. Designing a dashboard on pivot tables/001 9.1. Dashboard part 1 – Sales KPI.mp4 | 16.89MB ~Get Your Files Here !/10 - Lesson 9. Designing a dashboard on pivot tables/001 9.xlsx | 22.50KB ~Get Your Files Here !/10 - Lesson 9. Designing a dashboard on pivot tables/002 9.2. Dashboard part 2 – Target realization %.mp4 | 11.81MB ~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.68MB ~Get Your Files Here !/10 - Lesson 9. Designing a dashboard on pivot tables/004 9.4. Dashboard part 4 – Target deviation %.mp4 | 17.82MB ~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.50MB ~Get Your Files Here !/11 - Lesson 10. Advanced slicers and filtering/001 10-solution.xlsx | 2.87MB ~Get Your Files Here !/11 - Lesson 10. Advanced slicers and filtering/001 10.1. Text slicer.mp4 | 45.83MB ~Get Your Files Here !/11 - Lesson 10. Advanced slicers and filtering/002 10.2. Date filter From-To.mp4 | 24.07MB ~Get Your Files Here !/11 - Lesson 10. Advanced slicers and filtering/003 10.3. Fiscal year slicer.mp4 | 39.67MB ~Get Your Files Here !/11 - Lesson 10. Advanced slicers and filtering/004 10.4. Year and month slicer.mp4 | 29.20MB ~Get Your Files Here !/11 - Lesson 10. Advanced slicers and filtering/005 10.5. Last day slicer.mp4 | 24.55MB ~Get Your Files Here !/11 - Lesson 10. Advanced slicers and filtering/006 10.6. DIY Week of the year slicer.mp4 | 20.02MB ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/001 11-solution.xlsx | 4.13MB ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/001 11.1. Distinct count.mp4 | 68.93MB ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/001 11v2-solution.xlsx | 2.40MB ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/002 11.2. Count in the calculated field.mp4 | 38.20MB ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/003 11.3. Calculated item.mp4 | 30.28MB ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/004 11.4. Calculated item on dates.mp4 | 53.78MB ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/005 11.5. GETPIVOTDATA formula.mp4 | 23.24MB ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/006 11.6. Sales vs Target as GETPIVOTDATA.mp4 | 15.39MB ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/007 11.7. Changing the aggregation of the subtotal.mp4 | 15.44MB ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/008 11.8-solution.xlsx | 17.24KB ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/008 11.8. Product.mp4 | 9.06MB ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/008 11.8.xlsx | 8.72KB ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/009 11.9-solution.xlsx | 18.73KB ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/009 11.9. Standard Deviation and Variance.mp4 | 17.21MB ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/009 11.9.xlsx | 8.82KB ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/010 11.10. Count Numbers.mp4 | 10.19MB ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/011 11.11. DIY Selecting a measure from the list.mp4 | 20.80MB ~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/001 12-solution.xlsx | 3.30MB ~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/001 12.1. Histogram in a column-line chart.mp4 | 66.10MB ~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/002 12.2. Conditional formatting.mp4 | 43.30MB ~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/003 12.3. Calendar heat map.mp4 | 42.37MB ~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/004 12.4. Cycle plot.mp4 | 18.24MB ~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/005 12.5. Gantt chart.mp4 | 51.70MB ~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/006 12.6. Constant line.mp4 | 15.64MB ~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/007 12.7. TOP 5 vs Others on the pie chart.mp4 | 22.26MB ~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/008 12.8. Cohort analysis.mp4 | 32.83MB ~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/009 12.9. Scatter plot.mp4 | 38.44MB ~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/010 12.10. Filled map.mp4 | 12.62MB ~Get Your Files Here !/14 - Lesson 13. Power tools for the pivot table user/001 13.1. Power Query.mp4 | 33.28MB ~Get Your Files Here !/14 - Lesson 13. Power tools for the pivot table user/002 13.2. Power Query animation.mp4 | 44.70MB ~Get Your Files Here !/14 - Lesson 13. Power tools for the pivot table user/003 13.3. Power Pivot.mp4 | 12.71MB ~Get Your Files Here !/14 - Lesson 13. Power tools for the pivot table user/004 13.4. Power BI.mp4 | 10.46MB ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/001 14.1-solution.xlsx | 31.79KB ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/001 14.1. How to show all periods on rows.mp4 | 16.71MB ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/001 14.1.xlsx | 13.94KB ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/002 14.2-solution.xlsx | 16.11KB ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/002 14.2. Why are there no years after the date grouping.mp4 | 3.93MB ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/002 14.2.xlsx | 9.68KB ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/003 14.3-solution.xlsx | 16.34KB ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/003 14.3. How to hide items removed from a data source.mp4 | 9.03MB ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/003 14.3.xlsx | 9.62KB ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/004 14.4-solution.xlsx | 14.70KB ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/004 14.4. How to show 0 instead of an empty cell.mp4 | 6.35MB ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/004 14.4.xlsx | 9.60KB ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/005 14.5-solution.xlsx | 16.85KB ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/005 14.5. How to I sort items in a table or in a slicer.mp4 | 10.19MB ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/005 14.5.xlsx | 9.82KB ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/006 14.6-solution.xlsx | 2.39MB ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/006 14.6. What is a classic layout How to edit the default pivot table layout.mp4 | 16.91MB ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/007 14.7-solution.xlsx | 12.02KB ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/007 14.7. Can you remove source data from pivot table memory.mp4 | 14.74MB ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/008 14.8-solution.xlsx | 2.56MB ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/008 14.8. What is the Defer Layout Update button for.mp4 | 8.70MB ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/009 14.9-solution.xlsx | 14.32KB ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/009 14.9. Can a pivot table be tabular and compact at the same time.mp4 | 8.17MB ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/009 14.9.xlsx | 9.83KB ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/010 14.10-solution.xlsx | 13.52KB ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/010 14.10. How to disconnect a pivot chart from a pivot table.mp4 | 6.85MB ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/010 14.10.xlsx | 14.32KB ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/011 14.11. How to embed a pivot table and pivot chart in PowerPoint.mp4 | 19.55MB ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/011 14.11.pptx | 39.30KB ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/011 14.11.xlsx | 19.37KB ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/012 14.12. How to build a Profit and Loss (P&L) statement.mp4 | 27.41MB ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/012 14.12.xlsx | 31.28KB ~Get Your Files Here !/Bonus Resources.txt | 386B