| 文件 | 大小 |
|---|
| 01-before-we-dive-in/001-course-materials-outline.mp4 | 6.76 MB |
| 01-before-we-dive-in/002-downloading-the-course-resources.mp4 | 2.19 MB |
| 01-before-we-dive-in/003-getting-to-know-the-imdb-movie-database.mp4 | 9.31 MB |
| 01-before-we-dive-in/004-setting-expectations.mp4 | 2.77 MB |
| 01-before-we-dive-in/attached_files/002-downloading-the-course-resources/Excel-PivotTable-Slides.pdf | 2.24 MB |
| 01-before-we-dive-in/attached_files/002-downloading-the-course-resources/IMDd-Movie-Database.xlsx | 457.64 kB |
| 02-pivottable-101/005-why-pivottables.mp4 | 9.92 MB |
| 02-pivottable-101/006-structuring-your-source-data.mp4 | 5.45 MB |
| 02-pivottable-101/007-inserting-your-first-pivottable.mp4 | 15.36 MB |
| 02-pivottable-101/008-navigating-the-field-list.mp4 | 20.73 MB |
| 02-pivottable-101/009-knowledge-check-manipulating-pivottable-views.html | 663.00 B |
| 02-pivottable-101/010-pivottable-options-analyze-design.mp4 | 4.56 MB |
| 02-pivottable-101/011-selecting-clearing-moving-copying-pivots.mp4 | 14.48 MB |
| 02-pivottable-101/012-refreshing-updating-pivots.mp4 | 37.56 MB |
| 02-pivottable-101/013-pro-tip-dealing-with-growing-source-data.mp4 | 41.60 MB |
| 02-pivottable-101/014-how-pivottables-actually-work.mp4 | 10.56 MB |
| 02-pivottable-101/015-homework-pivottable-101.html | 3.32 kB |
| 02-pivottable-101/attached_files/013-pro-tip-dealing-with-growing-source-data/2016-Movies.xlsx | 9.83 kB |
| 02-pivottable-101/quizzes/001-quiz-pivottable-101.html | 7.24 kB |
| 03-pivottable-formatting/016-number-formatting.mp4 | 6.28 MB |
| 03-pivottable-formatting/017-pro-tip-automatically-formatting-empty-cells.mp4 | 5.63 MB |
| 03-pivottable-formatting/018-table-layouts-styles.mp4 | 17.46 MB |
| 03-pivottable-formatting/019-pro-tip-using-tabular-tables-to-create-new-source-data.mp4 | 8.39 MB |
| 03-pivottable-formatting/020-customizing-headers-labels.mp4 | 3.22 MB |
| 03-pivottable-formatting/021-conditional-formatting.mp4 | 26.53 MB |
| 03-pivottable-formatting/022-pro-tip-data-bars-with-invisible-text.mp4 | 7.45 MB |
| 03-pivottable-formatting/023-homework-pivottable-formatting.html | 2.68 kB |
| 03-pivottable-formatting/quizzes/002-quiz-pivottable-formatting.html | 5.48 kB |
| 04-sorting-filtering-grouping/024-sorting-options.mp4 | 16.77 MB |
| 04-sorting-filtering-grouping/025-pro-tip-why-is-my-alphabetical-sorting-wrong.mp4 | 8.51 MB |
| 04-sorting-filtering-grouping/026-label-filters-manual-selections.mp4 | 30.23 MB |
| 04-sorting-filtering-grouping/027-pro-tip-using-label-filters-with-wildcards.mp4 | 16.47 MB |
| 04-sorting-filtering-grouping/028-value-filters.mp4 | 10.26 MB |
| 04-sorting-filtering-grouping/029-pro-tip-enabling-multiple-filters.mp4 | 11.71 MB |
| 04-sorting-filtering-grouping/030-grouping-data.mp4 | 13.38 MB |
| 04-sorting-filtering-grouping/031-pro-tip-automatic-date-grouping.mp4 | 14.98 MB |
| 04-sorting-filtering-grouping/032-using-slicers-timelines-to-filter-data.mp4 | 13.66 MB |
| 04-sorting-filtering-grouping/033-breaking-out-report-filter-pages.mp4 | 12.72 MB |
| 04-sorting-filtering-grouping/034-homework-sorting-filtering-grouping.html | 2.10 kB |
| 04-sorting-filtering-grouping/quizzes/003-quiz-sorting-filtering-grouping.html | 8.44 kB |
| 05-calculated-values-fields-items/035-summarize-values-by-options.mp4 | 11.85 MB |
| 05-calculated-values-fields-items/036-pro-tip-avoiding-the-count-of-trap.mp4 | 13.54 MB |
| 05-calculated-values-fields-items/037-show-values-as-calculations.mp4 | 8.29 MB |
| 05-calculated-values-fields-items/038-show-values-as-of-columnrow.mp4 | 11.77 MB |
| 05-calculated-values-fields-items/039-show-values-as-of-parent.mp4 | 8.83 MB |
| 05-calculated-values-fields-items/040-show-values-as-difference-from.mp4 | 13.65 MB |
| 05-calculated-values-fields-items/041-show-values-as-running-total.mp4 | 8.10 MB |
| 05-calculated-values-fields-items/042-show-values-as-rank.mp4 | 8.04 MB |
| 05-calculated-values-fields-items/043-show-values-as-index.mp4 | 28.90 MB |
| 05-calculated-values-fields-items/044-knowledge-check-show-values-as.html | 1.07 kB |
| 05-calculated-values-fields-items/045-inserting-calculated-fields.mp4 | 21.15 MB |
| 05-calculated-values-fields-items/046-calculations-in-pivots-vs.-raw-data.mp4 | 14.44 MB |
| 05-calculated-values-fields-items/047-pro-tip-calculating-using-counts.mp4 | 22.73 MB |
| 05-calculated-values-fields-items/048-pro-tip-calculating-using-counts-part-2.mp4 | 13.78 MB |
| 05-calculated-values-fields-items/049-inserting-a-calculated-item-not-recommended.mp4 | 15.04 MB |
| 05-calculated-values-fields-items/050-the-solve-order-list-formulas-tools.mp4 | 13.46 MB |
| 05-calculated-values-fields-items/051-homework-calculated-values-fields.html | 2.93 kB |
| 05-calculated-values-fields-items/quizzes/004-quiz-calculated-values-fields.html | 10.38 kB |
| 06-pivotcharts/052-intro-to-pivotcharts.mp4 | 5.83 MB |
| 06-pivotcharts/053-pivotchart-demo-column-chart.mp4 | 10.29 MB |
| 06-pivotcharts/054-pivotchart-demo-piedonut-chart.mp4 | 14.63 MB |
| 06-pivotcharts/055-pivotchart-demo-clustered-bar-chart.mp4 | 9.61 MB |
| 06-pivotcharts/056-pro-tip-prevent-charts-from-resizing-with-cells.mp4 | 11.54 MB |
| 06-pivotcharts/057-changing-chart-types-on-the-fly.mp4 | 8.02 MB |
| 06-pivotcharts/058-pivotchart-demo-stacked-area-chart.mp4 | 18.12 MB |
| 06-pivotcharts/059-pivotchart-layouts-styles.mp4 | 9.90 MB |
| 06-pivotcharts/060-moving-pivotcharts-to-new-sheets.mp4 | 5.64 MB |
| 06-pivotcharts/061-applying-slicers-timelines-to-multiple-charts.mp4 | 13.67 MB |
| 06-pivotcharts/062-building-a-dynamic-dashboard.mp4 | 35.77 MB |
| 06-pivotcharts/063-homework-pivotcharts.html | 2.66 kB |
| 06-pivotcharts/quizzes/005-quiz-pivotcharts.html | 8.23 kB |
| 07-pivottable-case-studies/064-setting-expectations.mp4 | 4.64 MB |
| 07-pivottable-case-studies/065-u.s.-voters-2012.mp4 | 37.59 MB |
| 07-pivottable-case-studies/066-homework-u.s.-voters-2012.html | 2.70 kB |
| 07-pivottable-case-studies/067-san-francisco-salaries.mp4 | 54.06 MB |
| 07-pivottable-case-studies/068-homework-san-francisco-salaries.html | 2.21 kB |
| 07-pivottable-case-studies/069-shark-attack-records.mp4 | 30.80 MB |
| 07-pivottable-case-studies/070-homework-shark-attack-records.html | 2.63 kB |
| 07-pivottable-case-studies/071-stock-market-data.mp4 | 54.58 MB |
| 07-pivottable-case-studies/072-homework-stock-market-data.html | 2.01 kB |
| 07-pivottable-case-studies/073-baseball-team-stats.mp4 | 46.19 MB |
| 07-pivottable-case-studies/074-homework-baseball-team-stats.html | 2.35 kB |
| 07-pivottable-case-studies/075-san-diego-burrito-ratings.mp4 | 63.39 MB |
| 07-pivottable-case-studies/076-homework-san-diego-burrito-ratings.html | 2.45 kB |
| 07-pivottable-case-studies/077-daily-weather-conditions.mp4 | 42.87 MB |
| 07-pivottable-case-studies/078-homework-daily-weather-conditions.html | 2.06 kB |
| 07-pivottable-case-studies/079-spartan-race-facebook-posts.mp4 | 51.78 MB |
| 07-pivottable-case-studies/080-homework-spartan-race-facebook-posts.html | 1.91 kB |
| 07-pivottable-case-studies/attached_files/064-setting-expectations/PivotTable-Case-Studies.pdf | 2.27 MB |
| 07-pivottable-case-studies/attached_files/064-setting-expectations/PivotTable-Case-Studies.xlsx | 4.67 MB |
| 08-wrapping-up/081-resources-next-steps.mp4 | 5.42 MB |
| 08-wrapping-up/082-bonus-lecture-more-from-excel-maven.html | 1.40 kB |
| [FreeCourseLab.com].url | 126.00 B |
-