FreeTutorials Us data-analysis-with-excel-pivot-tables

1. 01-before-we-dive-in/001-course-materials-outline.mp46.76MB
2. 01-before-we-dive-in/002-downloading-the-course-resources.mp42.19MB
3. 01-before-we-dive-in/003-getting-to-know-the-imdb-movie-database.mp49.31MB
4. 01-before-we-dive-in/004-setting-expectations.mp42.77MB
5. 02-pivottable-101/005-why-pivottables.mp49.92MB
6. 02-pivottable-101/006-structuring-your-source-data.mp45.45MB
7. 02-pivottable-101/007-inserting-your-first-pivottable.mp415.36MB
8. 02-pivottable-101/008-navigating-the-field-list.mp420.73MB
9. 02-pivottable-101/010-pivottable-options-analyze-design.mp44.56MB
10. 02-pivottable-101/011-selecting-clearing-moving-copying-pivots.mp414.48MB
11. 02-pivottable-101/012-refreshing-updating-pivots.mp437.56MB
12. 02-pivottable-101/013-pro-tip-dealing-with-growing-source-data.mp441.6MB
13. 02-pivottable-101/014-how-pivottables-actually-work.mp410.56MB
14. 03-pivottable-formatting/016-number-formatting.mp46.28MB
15. 03-pivottable-formatting/017-pro-tip-automatically-formatting-empty-cells.mp45.63MB
16. 03-pivottable-formatting/018-table-layouts-styles.mp417.46MB
17. 03-pivottable-formatting/019-pro-tip-using-tabular-tables-to-create-new-source-data.mp48.39MB
18. 03-pivottable-formatting/020-customizing-headers-labels.mp43.22MB
19. 03-pivottable-formatting/021-conditional-formatting.mp426.53MB
20. 03-pivottable-formatting/022-pro-tip-data-bars-with-invisible-text.mp47.45MB
21. 04-sorting-filtering-grouping/024-sorting-options.mp416.77MB
22. 04-sorting-filtering-grouping/025-pro-tip-why-is-my-alphabetical-sorting-wrong.mp48.51MB
23. 04-sorting-filtering-grouping/026-label-filters-manual-selections.mp430.23MB
24. 04-sorting-filtering-grouping/027-pro-tip-using-label-filters-with-wildcards.mp416.47MB
25. 04-sorting-filtering-grouping/028-value-filters.mp410.26MB
26. 04-sorting-filtering-grouping/029-pro-tip-enabling-multiple-filters.mp411.71MB
27. 04-sorting-filtering-grouping/030-grouping-data.mp413.38MB
28. 04-sorting-filtering-grouping/031-pro-tip-automatic-date-grouping.mp414.98MB
29. 04-sorting-filtering-grouping/032-using-slicers-timelines-to-filter-data.mp413.66MB
30. 04-sorting-filtering-grouping/033-breaking-out-report-filter-pages.mp412.72MB
31. 05-calculated-values-fields-items/035-summarize-values-by-options.mp411.85MB
32. 05-calculated-values-fields-items/036-pro-tip-avoiding-the-count-of-trap.mp413.54MB
33. 05-calculated-values-fields-items/037-show-values-as-calculations.mp48.29MB
34. 05-calculated-values-fields-items/038-show-values-as-of-columnrow.mp411.77MB
35. 05-calculated-values-fields-items/039-show-values-as-of-parent.mp48.83MB
36. 05-calculated-values-fields-items/040-show-values-as-difference-from.mp413.65MB
37. 05-calculated-values-fields-items/041-show-values-as-running-total.mp48.1MB
38. 05-calculated-values-fields-items/042-show-values-as-rank.mp48.04MB
39. 05-calculated-values-fields-items/043-show-values-as-index.mp428.9MB
40. 05-calculated-values-fields-items/045-inserting-calculated-fields.mp421.15MB
41. 05-calculated-values-fields-items/046-calculations-in-pivots-vs.-raw-data.mp414.44MB
42. 05-calculated-values-fields-items/047-pro-tip-calculating-using-counts.mp422.73MB
43. 05-calculated-values-fields-items/048-pro-tip-calculating-using-counts-part-2.mp413.78MB
44. 05-calculated-values-fields-items/049-inserting-a-calculated-item-not-recommended.mp415.04MB
45. 05-calculated-values-fields-items/050-the-solve-order-list-formulas-tools.mp413.46MB
46. 06-pivotcharts/052-intro-to-pivotcharts.mp45.83MB
47. 06-pivotcharts/053-pivotchart-demo-column-chart.mp410.29MB
48. 06-pivotcharts/054-pivotchart-demo-piedonut-chart.mp414.63MB
49. 06-pivotcharts/055-pivotchart-demo-clustered-bar-chart.mp49.61MB
50. 06-pivotcharts/056-pro-tip-prevent-charts-from-resizing-with-cells.mp411.54MB
51. 06-pivotcharts/057-changing-chart-types-on-the-fly.mp48.02MB
52. 06-pivotcharts/058-pivotchart-demo-stacked-area-chart.mp418.12MB
53. 06-pivotcharts/059-pivotchart-layouts-styles.mp49.9MB
54. 06-pivotcharts/060-moving-pivotcharts-to-new-sheets.mp45.64MB
55. 06-pivotcharts/061-applying-slicers-timelines-to-multiple-charts.mp413.67MB
56. 06-pivotcharts/062-building-a-dynamic-dashboard.mp435.77MB
57. 07-pivottable-case-studies/064-setting-expectations.mp44.64MB
58. 07-pivottable-case-studies/065-u.s.-voters-2012.mp437.59MB
59. 07-pivottable-case-studies/067-san-francisco-salaries.mp454.06MB
60. 07-pivottable-case-studies/069-shark-attack-records.mp430.8MB
61. 07-pivottable-case-studies/071-stock-market-data.mp454.58MB
62. 07-pivottable-case-studies/073-baseball-team-stats.mp446.19MB
63. 07-pivottable-case-studies/075-san-diego-burrito-ratings.mp463.39MB
64. 07-pivottable-case-studies/077-daily-weather-conditions.mp442.87MB
65. 07-pivottable-case-studies/079-spartan-race-facebook-posts.mp451.78MB
66. 08-wrapping-up/081-resources-next-steps.mp45.42MB