~Get Your Files Here !/02 - Lesson 1. Introduction to pivot tables/003 1.3. Pivot table refresh range vs table.mp4 174.7 MB
~Get Your Files Here !/06 - Lesson 5. Filtering a pivot table/005 5.5. Slicer.mp4 128.5 MB
~Get Your Files Here !/08 - Lesson 7. Show values as/006 7.6. DIY Show values as.mp4 109.0 MB
~Get Your Files Here !/06 - Lesson 5. Filtering a pivot table/002 5.2. Rows and columns filter - text, date, number.mp4 105.2 MB
~Get Your Files Here !/03 - Lesson 2. Basic calculations in a pivot table/001 2.1. Sum, Count, Average.mp4 87.8 MB
~Get Your Files Here !/02 - Lesson 1. Introduction to pivot tables/001 1.1. My first pivot table.mp4 87.5 MB
~Get Your Files Here !/12 - Lesson 11. Advanced calculations/001 11.1. Distinct count.mp4 72.3 MB
~Get Your Files Here !/09 - Lesson 8. Calculated field/004 8.4. DIY Calculated Field.mp4 69.3 MB
~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/001 12.1. Histogram in a column-line chart.mp4 69.3 MB
~Get Your Files Here !/09 - Lesson 8. Calculated field/002 8.2. Calculated field - division.mp4 63.5 MB
~Get Your Files Here !/02 - Lesson 1. Introduction to pivot tables/004 1.4. How to prepare data for a pivot table.mp4 61.0 MB
~Get Your Files Here !/01 - How to learn Excel/001 The New Excel Learning Curve.mp4 60.2 MB
~Get Your Files Here !/06 - Lesson 5. Filtering a pivot table/003 5.3. Value filter and TOP N filter.mp4 60.0 MB
~Get Your Files Here !/07 - Lesson 6. Pivot charts/001 6.1. Column chart.mp4 59.3 MB
~Get Your Files Here !/05 - Lesson 4. Grouping a pivot table/001 4.1. Manual grouping.mp4 58.9 MB
~Get Your Files Here !/05 - Lesson 4. Grouping a pivot table/002 4.2. Grouping dates.mp4 56.8 MB
~Get Your Files Here !/12 - Lesson 11. Advanced calculations/004 11.4. Calculated item on dates.mp4 56.4 MB
~Get Your Files Here !/04 - Lesson 3. Layout, formatting and sorting of a pivot table/004 3.4. DIY Pivot table layout.mp4 56.3 MB
~Get Your Files Here !/08 - Lesson 7. Show values as/005 7.5. Running total.mp4 54.6 MB
~Get Your Files Here !/04 - Lesson 3. Layout, formatting and sorting of a pivot table/003 3.3. Automatic and manual sorting.mp4 54.2 MB
~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/005 12.5. Gantt chart.mp4 54.2 MB
~Get Your Files Here !/07 - Lesson 6. Pivot charts/003 6.3. Combo chart and other charts.mp4 54.0 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 52.7 MB
~Get Your Files Here !/04 - Lesson 3. Layout, formatting and sorting of a pivot table/002 3.2. Changing the report layout.mp4 50.7 MB
~Get Your Files Here !/11 - Lesson 10. Advanced slicers and filtering/001 10.1. Text slicer.mp4 48.1 MB
~Get Your Files Here !/14 - Lesson 13. Power tools for the pivot table user/002 13.2. Power Query animation.mp4 46.9 MB
~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/002 12.2. Conditional formatting.mp4 45.4 MB
~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/003 12.3. Calendar heat map.mp4 44.4 MB
~Get Your Files Here !/06 - Lesson 5. Filtering a pivot table/001 5.1. Filters shelf.mp4 44.2 MB
~Get Your Files Here !/07 - Lesson 6. Pivot charts/002 6.2. Line chart.mp4 43.6 MB
~Get Your Files Here !/11 - Lesson 10. Advanced slicers and filtering/003 10.3. Fiscal year slicer.mp4 41.6 MB
~Get Your Files Here !/09 - Lesson 8. Calculated field/001 8.1. Calculated field - multiplication.mp4 41.4 MB
~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/009 12.9. Scatter plot.mp4 40.3 MB
~Get Your Files Here !/12 - Lesson 11. Advanced calculations/002 11.2. Count in the calculated field.mp4 40.1 MB
~Get Your Files Here !/03 - Lesson 2. Basic calculations in a pivot table/004 2.4. Drill down - viewing the source data.mp4 38.5 MB
~Get Your Files Here !/03 - Lesson 2. Basic calculations in a pivot table/002 2.2. DIY Summarize values by.mp4 37.7 MB
~Get Your Files Here !/05 - Lesson 4. Grouping a pivot table/005 4.5. DIY Grouping TOP 5 vs Others.mp4 37.6 MB
~Get Your Files Here !/14 - Lesson 13. Power tools for the pivot table user/001 13.1. Power Query.mp4 34.9 MB
~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/008 12.8. Cohort analysis.mp4 34.4 MB
~Get Your Files Here !/07 - Lesson 6. Pivot charts/004 6.4. DIY Combo chart.mp4 33.4 MB
~Get Your Files Here !/12 - Lesson 11. Advanced calculations/003 11.3. Calculated item.mp4 31.8 MB
~Get Your Files Here !/05 - Lesson 4. Grouping a pivot table/004 4.4. Grouping values.mp4 31.0 MB
~Get Your Files Here !/03 - Lesson 2. Basic calculations in a pivot table/003 2.3. How does the average work.mp4 31.0 MB
~Get Your Files Here !/11 - Lesson 10. Advanced slicers and filtering/004 10.4. Year and month slicer.mp4 30.6 MB
~Get Your Files Here !/02 - Lesson 1. Introduction to pivot tables/002 1.2. Insert a pivot table - DIY exercise.mp4 29.3 MB
~Get Your Files Here !/06 - Lesson 5. Filtering a pivot table/007 5.7. DIY Week slicer.mp4 29.3 MB
~Get Your Files Here !/09 - Lesson 8. Calculated field/003 8.3. Rounding and list of formulas.mp4 29.0 MB
~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 28.7 MB
~Get Your Files Here !/08 - Lesson 7. Show values as/003 7.3. % of Parent total.mp4 28.3 MB
~Get Your Files Here !/08 - Lesson 7. Show values as/004 7.4. Year-on-Year % change.mp4 28.1 MB
~Get Your Files Here !/11 - Lesson 10. Advanced slicers and filtering/005 10.5. Last day slicer.mp4 25.7 MB
~Get Your Files Here !/11 - Lesson 10. Advanced slicers and filtering/002 10.2. Date filter From-To.mp4 25.2 MB
~Get Your Files Here !/08 - Lesson 7. Show values as/001 7.1. % of Grand total.mp4 25.0 MB
~Get Your Files Here !/06 - Lesson 5. Filtering a pivot table/004 5.4. Generate report filter pages.mp4 24.6 MB
~Get Your Files Here !/12 - Lesson 11. Advanced calculations/005 11.5. GETPIVOTDATA formula.mp4 24.4 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 23.8 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 23.6 MB
~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/007 12.7. TOP 5 vs Others on the pie chart.mp4 23.3 MB
~Get Your Files Here !/12 - Lesson 11. Advanced calculations/011 11.11. DIY Selecting a measure from the list.mp4 21.8 MB
~Get Your Files Here !/11 - Lesson 10. Advanced slicers and filtering/006 10.6. DIY Week of the year slicer.mp4 21.0 MB
~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 20.5 MB
~Get Your Files Here !/06 - Lesson 5. Filtering a pivot table/006 5.6. Timeline.mp4 20.0 MB
~Get Your Files Here !/08 - Lesson 7. Show values as/002 7.2. % of Row total.mp4 19.6 MB
~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/004 12.4. Cycle plot.mp4 19.1 MB
~Get Your Files Here !/10 - Lesson 9. Designing a dashboard on pivot tables/004 9.4. Dashboard part 4 – Target deviation %.mp4 18.7 MB
~Get Your Files Here !/12 - Lesson 11. Advanced calculations/009 11.9. Standard Deviation and Variance.mp4 18.1 MB
~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 17.7 MB
~Get Your Files Here !/10 - Lesson 9. Designing a dashboard on pivot tables/001 9.1. Dashboard part 1 – Sales KPI.mp4 17.7 MB
~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/001 14.1. How to show all periods on rows.mp4 17.5 MB
~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/006 12.6. Constant line.mp4 16.4 MB
~Get Your Files Here !/12 - Lesson 11. Advanced calculations/007 11.7. Changing the aggregation of the subtotal.mp4 16.2 MB
~Get Your Files Here !/12 - Lesson 11. Advanced calculations/006 11.6. Sales vs Target as GETPIVOTDATA.mp4 16.1 MB
~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 15.5 MB
~Get Your Files Here !/05 - Lesson 4. Grouping a pivot table/003 4.3. Problems with date grouping.mp4 14.3 MB
~Get Your Files Here !/14 - Lesson 13. Power tools for the pivot table user/003 13.3. Power Pivot.mp4 13.3 MB
~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/010 12.10. Filled map.mp4 13.2 MB
~Get Your Files Here !/10 - Lesson 9. Designing a dashboard on pivot tables/002 9.2. Dashboard part 2 – Target realization %.mp4 12.4 MB
~Get Your Files Here !/14 - Lesson 13. Power tools for the pivot table user/004 13.4. Power BI.mp4 11.0 MB
~Get Your Files Here !/12 - Lesson 11. Advanced calculations/010 11.10. Count Numbers.mp4 10.7 MB
~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.7 MB
~Get Your Files Here !/12 - Lesson 11. Advanced calculations/008 11.8. Product.mp4 9.5 MB
~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.5 MB
~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 9.1 MB
~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.6 MB
~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 7.2 MB
~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.7 MB
~Get Your Files Here !/02 - Lesson 1. Introduction to pivot tables/001 1-solution.xlsx 4.4 MB
~Get Your Files Here !/12 - Lesson 11. Advanced calculations/001 11-solution.xlsx 4.3 MB
~Get Your Files Here !/08 - Lesson 7. Show values as/001 7-solution.xlsx 4.3 MB
~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 4.1 MB
~Get Your Files Here !/09 - Lesson 8. Calculated field/001 8-solution.xlsx 3.7 MB
~Get Your Files Here !/03 - Lesson 2. Basic calculations in a pivot table/001 2-solution.xlsx 3.5 MB
~Get Your Files Here !/13 - Lesson 12. Advanced pivot charts/001 12-solution.xlsx 3.5 MB
~Get Your Files Here !/11 - Lesson 10. Advanced slicers and filtering/001 10-solution.xlsx 3.0 MB
~Get Your Files Here !/04 - Lesson 3. Layout, formatting and sorting of a pivot table/001 3-solution.xlsx 3.0 MB
~Get Your Files Here !/06 - Lesson 5. Filtering a pivot table/001 5-solution.xlsx 2.7 MB
~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/008 14.8-solution.xlsx 2.7 MB
~Get Your Files Here !/05 - Lesson 4. Grouping a pivot table/001 4-solution.xlsx 2.6 MB
~Get Your Files Here !/07 - Lesson 6. Pivot charts/001 6-solution.xlsx 2.5 MB
~Get Your Files Here !/12 - Lesson 11. Advanced calculations/001 11v2-solution.xlsx 2.5 MB
~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/006 14.6-solution.xlsx 2.5 MB
~Get Your Files Here !/10 - Lesson 9. Designing a dashboard on pivot tables/001 9-solution.xlsx 50.2 kB
~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/011 14.11.pptx 40.2 kB
~Get Your Files Here !/02 - Lesson 1. Introduction to pivot tables/004 1.4.wrong-data-source-solution.xlsx 37.4 kB
~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/001 14.1-solution.xlsx 32.5 kB
~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/012 14.12.xlsx 32.0 kB
~Get Your Files Here !/10 - Lesson 9. Designing a dashboard on pivot tables/001 9.xlsx 23.0 kB
~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/011 14.11.xlsx 19.8 kB
~Get Your Files Here !/12 - Lesson 11. Advanced calculations/009 11.9-solution.xlsx 19.2 kB
~Get Your Files Here !/12 - Lesson 11. Advanced calculations/008 11.8-solution.xlsx 17.7 kB
~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/005 14.5-solution.xlsx 17.3 kB
~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/003 14.3-solution.xlsx 16.7 kB
~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/002 14.2-solution.xlsx 16.5 kB
~Get Your Files Here !/05 - Lesson 4. Grouping a pivot table/003 4.3-solution.xlsx 16.4 kB
~Get Your Files Here !/05 - Lesson 4. Grouping a pivot table/003 4.3-problem-with-dates.xlsx 15.3 kB
~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/004 14.4-solution.xlsx 15.1 kB
~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/009 14.9-solution.xlsx 14.7 kB
~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/010 14.10.xlsx 14.7 kB
~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/001 14.1.xlsx 14.3 kB
~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/010 14.10-solution.xlsx 13.8 kB
~Get Your Files Here !/02 - Lesson 1. Introduction to pivot tables/004 1.4.wrong-data-source.xlsx 13.8 kB
~Get Your Files Here !/03 - Lesson 2. Basic calculations in a pivot table/003 2.3-solution.xlsx 13.2 kB
~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/007 14.7-solution.xlsx 12.3 kB
~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/009 14.9.xlsx 10.1 kB
~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/005 14.5.xlsx 10.1 kB
~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/002 14.2.xlsx 9.9 kB
~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/003 14.3.xlsx 9.9 kB
~Get Your Files Here !/15 - Lesson 14. Frequently asked questions about pivot tables/004 14.4.xlsx 9.8 kB
~Get Your Files Here !/03 - Lesson 2. Basic calculations in a pivot table/003 2.3.xlsx 9.7 kB
~Get Your Files Here !/12 - Lesson 11. Advanced calculations/009 11.9.xlsx 9.0 kB
~Get Your Files Here !/12 - Lesson 11. Advanced calculations/008 11.8.xlsx 8.9 kB
~Get Your Files Here !/Bonus Resources.txt 386 Bytes