[ ] Udemy - The best Excel pivot tables course in the world
- 收录时间:2023-05-22 14:58:18
- 文件大小:3GB
- 下载次数:1
- 最近下载:2023-05-22 14:58:18
- 磁力链接:
-
文件列表
- ~Get Your Files Here !/02 - Lesson 1. Introduction to pivot tables/003 1.3. Pivot table refresh range vs table.mp4 167MB
- ~Get Your Files Here !/06 - Lesson 5. Filtering a pivot table/005 5.5. Slicer.mp4 123MB
- ~Get Your Files Here !/08 - Lesson 7. Show values as/006 7.6. DIY Show values as.mp4 104MB
- ~Get Your Files Here !/06 - Lesson 5. Filtering a pivot table/002 5.2. Rows and columns filter - text, date, number.mp4 100MB
- ~Get Your Files Here !/03 - Lesson 2. Basic calculations in a pivot table/001 2.1. Sum, Count, Average.mp4 84MB
- ~Get Your Files Here !/02 - Lesson 1. Introduction to pivot tables/001 1.1. My first pivot table.mp4 83MB
- ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/001 11.1. Distinct count.mp4 69MB
- ~Get Your Files Here !/09 - Lesson 8. Calculated field/004 8.4. DIY Calculated Field.mp4 66MB
- ~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/001 12.1. Histogram in a column-line chart.mp4 66MB
- ~Get Your Files Here !/09 - Lesson 8. Calculated field/002 8.2. Calculated field - division.mp4 61MB
- ~Get Your Files Here !/02 - Lesson 1. Introduction to pivot tables/004 1.4. How to prepare data for a pivot table.mp4 58MB
- ~Get Your Files Here !/01 - How to learn Excel/001 The New Excel Learning Curve.mp4 57MB
- ~Get Your Files Here !/06 - Lesson 5. Filtering a pivot table/003 5.3. Value filter and TOP N filter.mp4 57MB
- ~Get Your Files Here !/07 - Lesson 6. Pivot charts/001 6.1. Column chart.mp4 57MB
- ~Get Your Files Here !/05 - Lesson 4. Grouping a pivot table/001 4.1. Manual grouping.mp4 56MB
- ~Get Your Files Here !/05 - Lesson 4. Grouping a pivot table/002 4.2. Grouping dates.mp4 54MB
- ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/004 11.4. Calculated item on dates.mp4 54MB
- ~Get Your Files Here !/04 - Lesson 3. Layout, formatting and sorting of a pivot table/004 3.4. DIY Pivot table layout.mp4 54MB
- ~Get Your Files Here !/08 - Lesson 7. Show values as/005 7.5. Running total.mp4 52MB
- ~Get Your Files Here !/04 - Lesson 3. Layout, formatting and sorting of a pivot table/003 3.3. Automatic and manual sorting.mp4 52MB
- ~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/005 12.5. Gantt chart.mp4 52MB
- ~Get Your Files Here !/07 - Lesson 6. Pivot charts/003 6.3. Combo chart and other charts.mp4 51MB
- ~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 50MB
- ~Get Your Files Here !/04 - Lesson 3. Layout, formatting and sorting of a pivot table/002 3.2. Changing the report layout.mp4 48MB
- ~Get Your Files Here !/11 - Lesson 10. Advanced slicers and filtering/001 10.1. Text slicer.mp4 46MB
- ~Get Your Files Here !/14 - Lesson 13. Power tools for the pivot table user/002 13.2. Power Query animation.mp4 45MB
- ~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/002 12.2. Conditional formatting.mp4 43MB
- ~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/003 12.3. Calendar heat map.mp4 42MB
- ~Get Your Files Here !/06 - Lesson 5. Filtering a pivot table/001 5.1. Filters shelf.mp4 42MB
- ~Get Your Files Here !/07 - Lesson 6. Pivot charts/002 6.2. Line chart.mp4 42MB
- ~Get Your Files Here !/11 - Lesson 10. Advanced slicers and filtering/003 10.3. Fiscal year slicer.mp4 40MB
- ~Get Your Files Here !/09 - Lesson 8. Calculated field/001 8.1. Calculated field - multiplication.mp4 40MB
- ~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/009 12.9. Scatter plot.mp4 38MB
- ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/002 11.2. Count in the calculated field.mp4 38MB
- ~Get Your Files Here !/03 - Lesson 2. Basic calculations in a pivot table/004 2.4. Drill down - viewing the source data.mp4 37MB
- ~Get Your Files Here !/03 - Lesson 2. Basic calculations in a pivot table/002 2.2. DIY Summarize values by.mp4 36MB
- ~Get Your Files Here !/05 - Lesson 4. Grouping a pivot table/005 4.5. DIY Grouping TOP 5 vs Others.mp4 36MB
- ~Get Your Files Here !/14 - Lesson 13. Power tools for the pivot table user/001 13.1. Power Query.mp4 33MB
- ~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/008 12.8. Cohort analysis.mp4 33MB
- ~Get Your Files Here !/07 - Lesson 6. Pivot charts/004 6.4. DIY Combo chart.mp4 32MB
- ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/003 11.3. Calculated item.mp4 30MB
- ~Get Your Files Here !/05 - Lesson 4. Grouping a pivot table/004 4.4. Grouping values.mp4 30MB
- ~Get Your Files Here !/03 - Lesson 2. Basic calculations in a pivot table/003 2.3. How does the average work.mp4 30MB
- ~Get Your Files Here !/11 - Lesson 10. Advanced slicers and filtering/004 10.4. Year and month slicer.mp4 29MB
- ~Get Your Files Here !/02 - Lesson 1. Introduction to pivot tables/002 1.2. Insert a pivot table - DIY exercise.mp4 28MB
- ~Get Your Files Here !/06 - Lesson 5. Filtering a pivot table/007 5.7. DIY Week slicer.mp4 28MB
- ~Get Your Files Here !/09 - Lesson 8. Calculated field/003 8.3. Rounding and list of formulas.mp4 28MB
- ~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 27MB
- ~Get Your Files Here !/08 - Lesson 7. Show values as/003 7.3. % of Parent total.mp4 27MB
- ~Get Your Files Here !/08 - Lesson 7. Show values as/004 7.4. Year-on-Year % change.mp4 27MB
- ~Get Your Files Here !/11 - Lesson 10. Advanced slicers and filtering/005 10.5. Last day slicer.mp4 25MB
- ~Get Your Files Here !/11 - Lesson 10. Advanced slicers and filtering/002 10.2. Date filter From-To.mp4 24MB
- ~Get Your Files Here !/08 - Lesson 7. Show values as/001 7.1. % of Grand total.mp4 24MB
- ~Get Your Files Here !/06 - Lesson 5. Filtering a pivot table/004 5.4. Generate report filter pages.mp4 23MB
- ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/005 11.5. GETPIVOTDATA formula.mp4 23MB
- ~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 23MB
- ~Get Your Files Here !/10 - Lesson 9. Designing a dashboard on pivot tables/005 9.5. Dashboard part 5 – Filtering and dashboard design.mp4 22MB
- ~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/007 12.7. TOP 5 vs Others on the pie chart.mp4 22MB
- ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/011 11.11. DIY Selecting a measure from the list.mp4 21MB
- ~Get Your Files Here !/11 - Lesson 10. Advanced slicers and filtering/006 10.6. DIY Week of the year slicer.mp4 20MB
- ~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 20MB
- ~Get Your Files Here !/06 - Lesson 5. Filtering a pivot table/006 5.6. Timeline.mp4 19MB
- ~Get Your Files Here !/08 - Lesson 7. Show values as/002 7.2. % of Row total.mp4 19MB
- ~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/004 12.4. Cycle plot.mp4 18MB
- ~Get Your Files Here !/10 - Lesson 9. Designing a dashboard on pivot tables/004 9.4. Dashboard part 4 – Target deviation %.mp4 18MB
- ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/009 11.9. Standard Deviation and Variance.mp4 17MB
- ~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 17MB
- ~Get Your Files Here !/10 - Lesson 9. Designing a dashboard on pivot tables/001 9.1. Dashboard part 1 – Sales KPI.mp4 17MB
- ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/001 14.1. How to show all periods on rows.mp4 17MB
- ~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/006 12.6. Constant line.mp4 16MB
- ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/007 11.7. Changing the aggregation of the subtotal.mp4 15MB
- ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/006 11.6. Sales vs Target as GETPIVOTDATA.mp4 15MB
- ~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 15MB
- ~Get Your Files Here !/05 - Lesson 4. Grouping a pivot table/003 4.3. Problems with date grouping.mp4 14MB
- ~Get Your Files Here !/14 - Lesson 13. Power tools for the pivot table user/003 13.3. Power Pivot.mp4 13MB
- ~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/010 12.10. Filled map.mp4 13MB
- ~Get Your Files Here !/10 - Lesson 9. Designing a dashboard on pivot tables/002 9.2. Dashboard part 2 – Target realization %.mp4 12MB
- ~Get Your Files Here !/14 - Lesson 13. Power tools for the pivot table user/004 13.4. Power BI.mp4 10MB
- ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/010 11.10. Count Numbers.mp4 10MB
- ~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 10MB
- ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/008 11.8. Product.mp4 9MB
- ~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 9MB
- ~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 9MB
- ~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 8MB
- ~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 7MB
- ~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 6MB
- ~Get Your Files Here !/02 - Lesson 1. Introduction to pivot tables/001 1-solution.xlsx 4MB
- ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/001 11-solution.xlsx 4MB
- ~Get Your Files Here !/08 - Lesson 7. Show values as/001 7-solution.xlsx 4MB
- ~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 4MB
- ~Get Your Files Here !/09 - Lesson 8. Calculated field/001 8-solution.xlsx 4MB
- ~Get Your Files Here !/03 - Lesson 2. Basic calculations in a pivot table/001 2-solution.xlsx 3MB
- ~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/001 12-solution.xlsx 3MB
- ~Get Your Files Here !/11 - Lesson 10. Advanced slicers and filtering/001 10-solution.xlsx 3MB
- ~Get Your Files Here !/04 - Lesson 3. Layout, formatting and sorting of a pivot table/001 3-solution.xlsx 3MB
- ~Get Your Files Here !/06 - Lesson 5. Filtering a pivot table/001 5-solution.xlsx 3MB
- ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/008 14.8-solution.xlsx 3MB
- ~Get Your Files Here !/05 - Lesson 4. Grouping a pivot table/001 4-solution.xlsx 2MB
- ~Get Your Files Here !/07 - Lesson 6. Pivot charts/001 6-solution.xlsx 2MB
- ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/001 11v2-solution.xlsx 2MB
- ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/006 14.6-solution.xlsx 2MB
- ~Get Your Files Here !/10 - Lesson 9. Designing a dashboard on pivot tables/001 9-solution.xlsx 49KB
- ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/011 14.11.pptx 39KB
- ~Get Your Files Here !/02 - Lesson 1. Introduction to pivot tables/004 1.4.wrong-data-source-solution.xlsx 37KB
- ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/001 14.1-solution.xlsx 32KB
- ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/012 14.12.xlsx 31KB
- ~Get Your Files Here !/10 - Lesson 9. Designing a dashboard on pivot tables/001 9.xlsx 22KB
- ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/011 14.11.xlsx 19KB
- ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/009 11.9-solution.xlsx 19KB
- ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/008 11.8-solution.xlsx 17KB
- ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/005 14.5-solution.xlsx 17KB
- ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/003 14.3-solution.xlsx 16KB
- ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/002 14.2-solution.xlsx 16KB
- ~Get Your Files Here !/05 - Lesson 4. Grouping a pivot table/003 4.3-solution.xlsx 16KB
- ~Get Your Files Here !/05 - Lesson 4. Grouping a pivot table/003 4.3-problem-with-dates.xlsx 15KB
- ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/004 14.4-solution.xlsx 15KB
- ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/009 14.9-solution.xlsx 14KB
- ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/010 14.10.xlsx 14KB
- ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/001 14.1.xlsx 14KB
- ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/010 14.10-solution.xlsx 14KB
- ~Get Your Files Here !/02 - Lesson 1. Introduction to pivot tables/004 1.4.wrong-data-source.xlsx 13KB
- ~Get Your Files Here !/03 - Lesson 2. Basic calculations in a pivot table/003 2.3-solution.xlsx 13KB
- ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/007 14.7-solution.xlsx 12KB
- ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/009 14.9.xlsx 10KB
- ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/005 14.5.xlsx 10KB
- ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/002 14.2.xlsx 10KB
- ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/003 14.3.xlsx 10KB
- ~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/004 14.4.xlsx 10KB
- ~Get Your Files Here !/03 - Lesson 2. Basic calculations in a pivot table/003 2.3.xlsx 10KB
- ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/009 11.9.xlsx 9KB
- ~Get Your Files Here !/12 - Lesson 11. Advanced calculations/008 11.8.xlsx 9KB
- ~Get Your Files Here !/Bonus Resources.txt 386B
- Get Bonus Downloads Here.url 182B