|
|
001-course-materials-outline.mp4
|
MP4
|
6.8 MB
|
|
|
001-quiz-pivottable-101.html
|
HTML
|
7.2 KB
|
|
|
002-downloading-the-course-resources.mp4
|
MP4
|
2.2 MB
|
|
|
002-quiz-pivottable-formatting.html
|
HTML
|
5.5 KB
|
|
|
003-getting-to-know-the-imdb-movie-database.mp4
|
MP4
|
9.3 MB
|
|
|
003-quiz-sorting-filtering-grouping.html
|
HTML
|
8.4 KB
|
|
|
004-quiz-calculated-values-fields.html
|
HTML
|
10.4 KB
|
|
|
004-setting-expectations.mp4
|
MP4
|
2.8 MB
|
|
|
005-quiz-pivotcharts.html
|
HTML
|
8.2 KB
|
|
|
005-why-pivottables.mp4
|
MP4
|
9.9 MB
|
|
|
006-structuring-your-source-data.mp4
|
MP4
|
5.4 MB
|
|
|
007-inserting-your-first-pivottable.mp4
|
MP4
|
15.4 MB
|
|
|
008-navigating-the-field-list.mp4
|
MP4
|
20.7 MB
|
|
|
009-knowledge-check-manipulating-pivottable-views.html
|
HTML
|
614.4 B
|
|
|
010-pivottable-options-analyze-design.mp4
|
MP4
|
4.6 MB
|
|
|
011-selecting-clearing-moving-copying-pivots.mp4
|
MP4
|
14.5 MB
|
|
|
012-refreshing-updating-pivots.mp4
|
MP4
|
37.6 MB
|
|
|
013-pro-tip-dealing-with-growing-source-data.mp4
|
MP4
|
41.6 MB
|
|
|
014-how-pivottables-actually-work.mp4
|
MP4
|
10.6 MB
|
|
|
015-homework-pivottable-101.html
|
HTML
|
3.3 KB
|
|
|
016-number-formatting.mp4
|
MP4
|
6.3 MB
|
|
|
017-pro-tip-automatically-formatting-empty-cells.mp4
|
MP4
|
5.6 MB
|
|
|
018-table-layouts-styles.mp4
|
MP4
|
17.5 MB
|
|
|
019-pro-tip-using-tabular-tables-to-create-new-source-data.mp4
|
MP4
|
8.4 MB
|
|
|
020-customizing-headers-labels.mp4
|
MP4
|
3.2 MB
|
|
|
021-conditional-formatting.mp4
|
MP4
|
26.5 MB
|
|
|
022-pro-tip-data-bars-with-invisible-text.mp4
|
MP4
|
7.4 MB
|
|
|
023-homework-pivottable-formatting.html
|
HTML
|
2.7 KB
|
|
|
024-sorting-options.mp4
|
MP4
|
16.8 MB
|
|
|
025-pro-tip-why-is-my-alphabetical-sorting-wrong.mp4
|
MP4
|
8.5 MB
|
|
|
026-label-filters-manual-selections.mp4
|
MP4
|
30.2 MB
|
|
|
027-pro-tip-using-label-filters-with-wildcards.mp4
|
MP4
|
16.5 MB
|
|
|
028-value-filters.mp4
|
MP4
|
10.3 MB
|
|
|
029-pro-tip-enabling-multiple-filters.mp4
|
MP4
|
11.7 MB
|
|
|
030-grouping-data.mp4
|
MP4
|
13.4 MB
|
|
|
031-pro-tip-automatic-date-grouping.mp4
|
MP4
|
15 MB
|
|
|
032-using-slicers-timelines-to-filter-data.mp4
|
MP4
|
13.7 MB
|
|
|
033-breaking-out-report-filter-pages.mp4
|
MP4
|
12.7 MB
|
|
|
034-homework-sorting-filtering-grouping.html
|
HTML
|
2.1 KB
|
|
|
035-summarize-values-by-options.mp4
|
MP4
|
11.9 MB
|
|
|
036-pro-tip-avoiding-the-count-of-trap.mp4
|
MP4
|
13.5 MB
|
|
|
037-show-values-as-calculations.mp4
|
MP4
|
8.3 MB
|
|
|
038-show-values-as-of-columnrow.mp4
|
MP4
|
11.8 MB
|
|
|
039-show-values-as-of-parent.mp4
|
MP4
|
8.8 MB
|
|
|
040-show-values-as-difference-from.mp4
|
MP4
|
13.7 MB
|
|
|
041-show-values-as-running-total.mp4
|
MP4
|
8.1 MB
|
|
|
042-show-values-as-rank.mp4
|
MP4
|
8 MB
|
|
|
043-show-values-as-index.mp4
|
MP4
|
28.9 MB
|
|
|
044-knowledge-check-show-values-as.html
|
HTML
|
1.1 KB
|
|
|
045-inserting-calculated-fields.mp4
|
MP4
|
21.2 MB
|
|
|
046-calculations-in-pivots-vs.-raw-data.mp4
|
MP4
|
14.4 MB
|
|
|
047-pro-tip-calculating-using-counts.mp4
|
MP4
|
22.7 MB
|
|
|
048-pro-tip-calculating-using-counts-part-2.mp4
|
MP4
|
13.8 MB
|
|
|
049-inserting-a-calculated-item-not-recommended.mp4
|
MP4
|
15 MB
|
|
|
050-the-solve-order-list-formulas-tools.mp4
|
MP4
|
13.5 MB
|
|
|
051-homework-calculated-values-fields.html
|
HTML
|
2.9 KB
|
|
|
052-intro-to-pivotcharts.mp4
|
MP4
|
5.8 MB
|
|
|
053-pivotchart-demo-column-chart.mp4
|
MP4
|
10.3 MB
|
|
|
054-pivotchart-demo-piedonut-chart.mp4
|
MP4
|
14.6 MB
|
|
|
055-pivotchart-demo-clustered-bar-chart.mp4
|
MP4
|
9.6 MB
|
|
|
056-pro-tip-prevent-charts-from-resizing-with-cells.mp4
|
MP4
|
11.5 MB
|
|
|
057-changing-chart-types-on-the-fly.mp4
|
MP4
|
8 MB
|
|
|
058-pivotchart-demo-stacked-area-chart.mp4
|
MP4
|
18.1 MB
|
|
|
059-pivotchart-layouts-styles.mp4
|
MP4
|
9.9 MB
|
|
|
060-moving-pivotcharts-to-new-sheets.mp4
|
MP4
|
5.6 MB
|
|
|
061-applying-slicers-timelines-to-multiple-charts.mp4
|
MP4
|
13.7 MB
|
|
|
062-building-a-dynamic-dashboard.mp4
|
MP4
|
35.8 MB
|
|
|
063-homework-pivotcharts.html
|
HTML
|
2.7 KB
|
|
|
064-setting-expectations.mp4
|
MP4
|
4.6 MB
|
|
|
065-u.s.-voters-2012.mp4
|
MP4
|
37.6 MB
|
|
|
066-homework-u.s.-voters-2012.html
|
HTML
|
2.7 KB
|
|
|
067-san-francisco-salaries.mp4
|
MP4
|
54.1 MB
|
|
|
068-homework-san-francisco-salaries.html
|
HTML
|
2.2 KB
|
|
|
069-shark-attack-records.mp4
|
MP4
|
30.8 MB
|
|
|
070-homework-shark-attack-records.html
|
HTML
|
2.6 KB
|
|
|
071-stock-market-data.mp4
|
MP4
|
54.6 MB
|
|
|
072-homework-stock-market-data.html
|
HTML
|
2 KB
|
|
|
073-baseball-team-stats.mp4
|
MP4
|
46.2 MB
|
|
|
074-homework-baseball-team-stats.html
|
HTML
|
2.4 KB
|
|
|
075-san-diego-burrito-ratings.mp4
|
MP4
|
63.4 MB
|
|
|
076-homework-san-diego-burrito-ratings.html
|
HTML
|
2.4 KB
|
|
|
077-daily-weather-conditions.mp4
|
MP4
|
42.9 MB
|
|
|
078-homework-daily-weather-conditions.html
|
HTML
|
2.1 KB
|
|
|
079-spartan-race-facebook-posts.mp4
|
MP4
|
51.8 MB
|
|
|
080-homework-spartan-race-facebook-posts.html
|
HTML
|
1.9 KB
|
|
|
081-resources-next-steps.mp4
|
MP4
|
5.4 MB
|
|
|
082-bonus-lecture-more-from-excel-maven.html
|
HTML
|
1.4 KB
|
|
|
2016-Movies.xlsx
|
XLSX
|
9.8 KB
|
|
|
Excel-PivotTable-Slides.pdf
|
PDF
|
2.2 MB
|
|
|
IMDd-Movie-Database.xlsx
|
XLSX
|
457.6 KB
|
|
|
PivotTable-Case-Studies.pdf
|
PDF
|
2.3 MB
|
|
|
PivotTable-Case-Studies.xlsx
|
XLSX
|
4.7 MB
|
|
|
[FreeCourseLab.com].url
|
URL
|
102.4 B
|
