|
|
001 1-solution.xlsx
|
XLSX
|
4.2 MB
|
|
|
001 1.1. My first pivot table.mp4
|
MP4
|
83.4 MB
|
|
|
001 10-solution.xlsx
|
XLSX
|
2.9 MB
|
|
|
001 10.1. Text slicer.mp4
|
MP4
|
45.8 MB
|
|
|
001 11-solution.xlsx
|
XLSX
|
4.1 MB
|
|
|
001 11.1. Distinct count.mp4
|
MP4
|
68.9 MB
|
|
|
001 11v2-solution.xlsx
|
XLSX
|
2.4 MB
|
|
|
001 12-solution.xlsx
|
XLSX
|
3.3 MB
|
|
|
001 12.1. Histogram in a column-line chart.mp4
|
MP4
|
66.1 MB
|
|
|
001 13.1. Power Query.mp4
|
MP4
|
33.3 MB
|
|
|
001 14.1-solution.xlsx
|
XLSX
|
31.8 KB
|
|
|
001 14.1. How to show all periods on rows.mp4
|
MP4
|
16.7 MB
|
|
|
001 14.1.xlsx
|
XLSX
|
13.9 KB
|
|
|
001 2-solution.xlsx
|
XLSX
|
3.4 MB
|
|
|
001 2.1. Sum, Count, Average.mp4
|
MP4
|
83.7 MB
|
|
|
001 3-solution.xlsx
|
XLSX
|
2.8 MB
|
|
|
001 3.1. Auto grouping (+ -), grand totals and subtotals.mp4
|
MP4
|
50.3 MB
|
|
|
001 4-solution.xlsx
|
XLSX
|
2.4 MB
|
|
|
001 4.1. Manual grouping.mp4
|
MP4
|
56.2 MB
|
|
|
001 5-solution.xlsx
|
XLSX
|
2.6 MB
|
|
|
001 5.1. Filters shelf.mp4
|
MP4
|
42.1 MB
|
|
|
001 6-solution.xlsx
|
XLSX
|
2.4 MB
|
|
|
001 6.1. Column chart.mp4
|
MP4
|
56.5 MB
|
|
|
001 7-solution.xlsx
|
XLSX
|
4.1 MB
|
|
|
001 7.1. % of Grand total.mp4
|
MP4
|
23.8 MB
|
|
|
001 8-solution.xlsx
|
XLSX
|
3.5 MB
|
|
|
001 8.1. Calculated field - multiplication.mp4
|
MP4
|
39.5 MB
|
|
|
001 9-solution.xlsx
|
XLSX
|
49 KB
|
|
|
001 9.1. Dashboard part 1 – Sales KPI.mp4
|
MP4
|
16.9 MB
|
|
|
001 9.xlsx
|
XLSX
|
22.5 KB
|
|
|
001 The New Excel Learning Curve.mp4
|
MP4
|
57.4 MB
|
|
|
002 1.2. Insert a pivot table - DIY exercise.mp4
|
MP4
|
28 MB
|
|
|
002 10.2. Date filter From-To.mp4
|
MP4
|
24.1 MB
|
|
|
002 11.2. Count in the calculated field.mp4
|
MP4
|
38.2 MB
|
|
|
002 12.2. Conditional formatting.mp4
|
MP4
|
43.3 MB
|
|
|
002 13.2. Power Query animation.mp4
|
MP4
|
44.7 MB
|
|
|
002 14.2-solution.xlsx
|
XLSX
|
16.1 KB
|
|
|
002 14.2. Why are there no years after the date grouping.mp4
|
MP4
|
3.9 MB
|
|
|
002 14.2.xlsx
|
XLSX
|
9.7 KB
|
|
|
002 2.2. DIY Summarize values by.mp4
|
MP4
|
36 MB
|
|
|
002 3.2. Changing the report layout.mp4
|
MP4
|
48.4 MB
|
|
|
002 4.2. Grouping dates.mp4
|
MP4
|
54.2 MB
|
|
|
002 5.2. Rows and columns filter - text, date, number.mp4
|
MP4
|
100.4 MB
|
|
|
002 6.2. Line chart.mp4
|
MP4
|
41.5 MB
|
|
|
002 7.2. % of Row total.mp4
|
MP4
|
18.7 MB
|
|
|
002 8.2. Calculated field - division.mp4
|
MP4
|
60.6 MB
|
|
|
002 9.2. Dashboard part 2 – Target realization %.mp4
|
MP4
|
11.8 MB
|
|
|
003 1.3. Pivot table refresh range vs table.mp4
|
MP4
|
166.6 MB
|
|
|
003 10.3. Fiscal year slicer.mp4
|
MP4
|
39.7 MB
|
|
|
003 11.3. Calculated item.mp4
|
MP4
|
30.3 MB
|
|
|
003 12.3. Calendar heat map.mp4
|
MP4
|
42.4 MB
|
|
|
003 13.3. Power Pivot.mp4
|
MP4
|
12.7 MB
|
|
|
003 14.3-solution.xlsx
|
XLSX
|
16.3 KB
|
|
|
003 14.3. How to hide items removed from a data source.mp4
|
MP4
|
9 MB
|
|
|
003 14.3.xlsx
|
XLSX
|
9.6 KB
|
|
|
003 2.3-solution.xlsx
|
XLSX
|
12.9 KB
|
|
|
003 2.3. How does the average work.mp4
|
MP4
|
29.6 MB
|
|
|
003 2.3.xlsx
|
XLSX
|
9.5 KB
|
|
|
003 3.3. Automatic and manual sorting.mp4
|
MP4
|
51.7 MB
|
|
|
003 4.3-problem-with-dates.xlsx
|
XLSX
|
14.9 KB
|
|
|
003 4.3-solution.xlsx
|
XLSX
|
16 KB
|
|
|
003 4.3. Problems with date grouping.mp4
|
MP4
|
13.7 MB
|
|
|
003 5.3. Value filter and TOP N filter.mp4
|
MP4
|
57.2 MB
|
|
|
003 6.3. Combo chart and other charts.mp4
|
MP4
|
51.5 MB
|
|
|
003 7.3. % of Parent total.mp4
|
MP4
|
27 MB
|
|
|
003 8.3. Rounding and list of formulas.mp4
|
MP4
|
27.7 MB
|
|
|
003 9.3. Dashboard part 3 – Sales vs Target by years.mp4
|
MP4
|
22.7 MB
|
|
|
004 1.4. How to prepare data for a pivot table.mp4
|
MP4
|
58.2 MB
|
|
|
004 1.4.wrong-data-source-solution.xlsx
|
XLSX
|
36.5 KB
|
|
|
004 1.4.wrong-data-source.xlsx
|
XLSX
|
13.5 KB
|
|
|
004 10.4. Year and month slicer.mp4
|
MP4
|
29.2 MB
|
|
|
004 11.4. Calculated item on dates.mp4
|
MP4
|
53.8 MB
|
|
|
004 12.4. Cycle plot.mp4
|
MP4
|
18.2 MB
|
|
|
004 13.4. Power BI.mp4
|
MP4
|
10.5 MB
|
|
|
004 14.4-solution.xlsx
|
XLSX
|
14.7 KB
|
|
|
004 14.4. How to show 0 instead of an empty cell.mp4
|
MP4
|
6.3 MB
|
|
|
004 14.4.xlsx
|
XLSX
|
9.6 KB
|
|
|
004 2.4. Drill down - viewing the source data.mp4
|
MP4
|
36.7 MB
|
|
|
004 3.4. DIY Pivot table layout.mp4
|
MP4
|
53.7 MB
|
|
|
004 4.4. Grouping values.mp4
|
MP4
|
29.6 MB
|
|
|
004 5.4. Generate report filter pages.mp4
|
MP4
|
23.4 MB
|
|
|
004 6.4. DIY Combo chart.mp4
|
MP4
|
31.8 MB
|
|
|
004 7.4. Year-on-Year % change.mp4
|
MP4
|
26.8 MB
|
|
|
004 8.4. DIY Calculated Field.mp4
|
MP4
|
66.1 MB
|
|
|
004 9.4. Dashboard part 4 – Target deviation %.mp4
|
MP4
|
17.8 MB
|
|
|
005 10.5. Last day slicer.mp4
|
MP4
|
24.5 MB
|
|
|
005 11.5. GETPIVOTDATA formula.mp4
|
MP4
|
23.2 MB
|
|
|
005 12.5. Gantt chart.mp4
|
MP4
|
51.7 MB
|
|
|
005 14.5-solution.xlsx
|
XLSX
|
16.9 KB
|
|
|
005 14.5. How to I sort items in a table or in a slicer.mp4
|
MP4
|
10.2 MB
|
|
|
005 14.5.xlsx
|
XLSX
|
9.8 KB
|
|
|
005 4.5. DIY Grouping TOP 5 vs Others.mp4
|
MP4
|
35.8 MB
|
|
|
005 5.5. Slicer.mp4
|
MP4
|
122.5 MB
|
|
|
005 7.5. Running total.mp4
|
MP4
|
52.1 MB
|
|
|
005 9.5. Dashboard part 5 – Filtering and dashboard design.mp4
|
MP4
|
22.5 MB
|
|
|
006 10.6. DIY Week of the year slicer.mp4
|
MP4
|
20 MB
|
|
|
006 11.6. Sales vs Target as GETPIVOTDATA.mp4
|
MP4
|
15.4 MB
|
|
|
006 12.6. Constant line.mp4
|
MP4
|
15.6 MB
|
|
|
006 14.6-solution.xlsx
|
XLSX
|
2.4 MB
|
|
|
006 14.6. What is a classic layout How to edit the default pivot table layout.mp4
|
MP4
|
16.9 MB
|
|
|
006 5.6. Timeline.mp4
|
MP4
|
19.1 MB
|
|
|
006 7.6. DIY Show values as.mp4
|
MP4
|
104 MB
|
|
|
007 11.7. Changing the aggregation of the subtotal.mp4
|
MP4
|
15.4 MB
|
|
|
007 12.7. TOP 5 vs Others on the pie chart.mp4
|
MP4
|
22.3 MB
|
|
|
007 14.7-solution.xlsx
|
XLSX
|
12 KB
|
|
|
007 14.7. Can you remove source data from pivot table memory.mp4
|
MP4
|
14.7 MB
|
|
|
007 5.7. DIY Week slicer.mp4
|
MP4
|
28 MB
|
|
|
008 11.8-solution.xlsx
|
XLSX
|
17.2 KB
|
|
|
008 11.8. Product.mp4
|
MP4
|
9.1 MB
|
|
|
008 11.8.xlsx
|
XLSX
|
8.7 KB
|
|
|
008 12.8. Cohort analysis.mp4
|
MP4
|
32.8 MB
|
|
|
008 14.8-solution.xlsx
|
XLSX
|
2.6 MB
|
|
|
008 14.8. What is the Defer Layout Update button for.mp4
|
MP4
|
8.7 MB
|
|
|
009 11.9-solution.xlsx
|
XLSX
|
18.7 KB
|
|
|
009 11.9. Standard Deviation and Variance.mp4
|
MP4
|
17.2 MB
|
|
|
009 11.9.xlsx
|
XLSX
|
8.8 KB
|
|
|
009 12.9. Scatter plot.mp4
|
MP4
|
38.4 MB
|
|
|
009 14.9-solution.xlsx
|
XLSX
|
14.3 KB
|
|
|
009 14.9. Can a pivot table be tabular and compact at the same time.mp4
|
MP4
|
8.2 MB
|
|
|
009 14.9.xlsx
|
XLSX
|
9.8 KB
|
|
|
010 11.10. Count Numbers.mp4
|
MP4
|
10.2 MB
|
|
|
010 12.10. Filled map.mp4
|
MP4
|
12.6 MB
|
|
|
010 14.10-solution.xlsx
|
XLSX
|
13.5 KB
|
|
|
010 14.10. How to disconnect a pivot chart from a pivot table.mp4
|
MP4
|
6.9 MB
|
|
|
010 14.10.xlsx
|
XLSX
|
14.3 KB
|
|
|
011 11.11. DIY Selecting a measure from the list.mp4
|
MP4
|
20.8 MB
|
|
|
011 14.11. How to embed a pivot table and pivot chart in PowerPoint.mp4
|
MP4
|
19.5 MB
|
|
|
011 14.11.pptx
|
PPTX
|
39.3 KB
|
|
|
011 14.11.xlsx
|
XLSX
|
19.4 KB
|
|
|
012 14.12. How to build a Profit and Loss (P&L) statement.mp4
|
MP4
|
27.4 MB
|
|
|
012 14.12.xlsx
|
XLSX
|
31.3 KB
|
|
|
Bonus Resources.txt
|
TXT
|
409.6 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
