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