Excel 2013 - Pivot Tables In Depth

1. 5. Applying Conditional Formats to PivotTables/Highlighting the top or bottom values in a PivotTable .mp420.04MB
2. 2. Summarizing PivotTable Data/Changing the data field summary operation.mp417.55MB
3. 1. Creating and Pivoting PivotTables/Consolidating data from multiple sources.mp417.5MB
4. 5. Applying Conditional Formats to PivotTables/Editing a conditional formatting rule.mp415.34MB
5. 4. Formatting PivotTables/Changing the PivotTable layout.mp415.14MB
6. 4. Formatting PivotTables/Creating a PivotTable style.mp414.67MB
7. 3. Sorting and Filtering PivotTable Data/Creating a custom sort order.mp413.9MB
8. 5. Applying Conditional Formats to PivotTables/Highlighting cells by applying a rule.mp413.87MB
9. 5. Applying Conditional Formats to PivotTables/Formatting cells using icon sets.mp413.02MB
10. 9. Starting with PowerPivot and the Data Model25m 44s/Introducing PowerPivot.mp412.59MB
11. 2. Summarizing PivotTable Data/Managing subtotals and grand totals.mp412.35MB
12. 3. Sorting and Filtering PivotTable Data/Filtering with report filter fields.mp412.18MB
13. 1. Creating and Pivoting PivotTables/Managing PivotTables.mp411.92MB
14. 9. Starting with PowerPivot and the Data Model25m 44s/Creating a PowerPivot PivotTable.mp411.88MB
15. 2. Summarizing PivotTable Data/Using PivotTable data in a formula.mp411.71MB
16. 10. Introducing Data Analysis Expressions/Creating aggregate calculations .mp411.55MB
17. 9. Starting with PowerPivot and the Data Model25m 44s/Managing table columns .mp411.42MB
18. 5. Applying Conditional Formats to PivotTables/Formatting cells using data bars.mp411.39MB
19. 9. Starting with PowerPivot and the Data Model25m 44s/Creating relationships between tables.mp411.35MB
20. 9. Starting with PowerPivot and the Data Model25m 44s/Filtering data using a timeline.mp411.35MB
21. 3. Sorting and Filtering PivotTable Data/Filtering a PivotTable field by selection.mp411.19MB
22. 10. Introducing Data Analysis Expressions/Using DAX operators.mp411.09MB
23. 2. Summarizing PivotTable Data/Grouping PivotTable fields.mp411.02MB
24. 1. Creating and Pivoting PivotTables/Introducing PivotTables .mp410.83MB
25. 7. Printing PivotTables/Printing headers at the top of each printed page.mp410.78MB
26. 5. Applying Conditional Formats to PivotTables/Formatting cells using color scales.mp410.72MB
27. 3. Sorting and Filtering PivotTable Data/Filtering a PivotTable using a search filter.mp410.38MB
28. 1. Creating and Pivoting PivotTables/Configuring a PivotTable.mp410.29MB
29. 3. Sorting and Filtering PivotTable Data/Sorting PivotTable data.mp410.26MB
30. 8. Manipulating PivotTables Using Macros/Running an Excel macro .mp410.2MB
31. 6. Creating and Manipulating PivotCharts/Formatting a PivotChart.mp410.13MB
32. 5. Applying Conditional Formats to PivotTables/Controlling how multiple rules are applied.mp410MB
33. 7. Printing PivotTables/Printing each item on its own pages..mp49.98MB
34. 11. Visualizing Power View Data Using Matrices, Cards, and Tiles/Creating a table or matrix .mp49.85MB
35. 3. Sorting and Filtering PivotTable Data/Filtering a PivotTable using slicers .mp49.76MB
36. 2. Summarizing PivotTable Data/Creating a calculated field .mp49.54MB
37. 6. Creating and Manipulating PivotCharts/Changing a PivotChart's layout.mp49.42MB
38. 0. Introduction/Welcome.mp49.39MB
39. 8. Manipulating PivotTables Using Macros/Recording and reviewing an Excel macro.mp49.3MB
40. 4. Formatting PivotTables/Applying a PivotTable style.mp49.28MB
41. 12. Visualizing Power View Data Using Charts and Maps/Creating a column or bar chart.mp48.79MB
42. 1. Creating and Pivoting PivotTables/Formatting data for use in a PivotTable.mp48.74MB
43. 10. Introducing Data Analysis Expressions/Adding calculated fields.mp48.63MB
44. 1. Creating and Pivoting PivotTables/Pivoting a PivotTable.mp48.47MB
45. 7. Printing PivotTables/Printing a PivotTable.mp48.36MB
46. 10. Introducing Data Analysis Expressions/Surveying DAX functions .mp48.24MB
47. 6. Creating and Manipulating PivotCharts/Creating a PivotChart .mp48.24MB
48. 3. Sorting and Filtering PivotTable Data/Formatting slicers.mp48.23MB
49. 4. Formatting PivotTables/Changing the data field number format.mp48.22MB
50. 1. Creating and Pivoting PivotTables/Creating a PivotTable .mp48.21MB
51. 8. Manipulating PivotTables Using Macros/Creating a simple PivotTable presentation kit.mp47.99MB
52. 11. Visualizing Power View Data Using Matrices, Cards, and Tiles/Filtering Power View objects.mp47.98MB
53. 6. Creating and Manipulating PivotCharts/Adding a trendline to a PivotChart.mp47.87MB
54. 1. Creating and Pivoting PivotTables/Creating a Recommended PivotTable.mp47.83MB
55. 3. Sorting and Filtering PivotTable Data/Filtering a PivotTable by rule.mp47.79MB
56. 10. Introducing Data Analysis Expressions/Creating filtered calculations .mp47.67MB
57. 5. Applying Conditional Formats to PivotTables/Deleting a conditional formatting rule.mp47.42MB
58. 10. Introducing Data Analysis Expressions/ntroducing the DAX language.mp47.4MB
59. 11. Visualizing Power View Data Using Matrices, Cards, and Tiles/Creating a card.mp47.34MB
60. 9. Starting with PowerPivot and the Data Model25m 44s/Importing PowerPivot data 3m .mp47.24MB
61. 6. Creating and Manipulating PivotCharts/Filtering a PivotChart .mp47.21MB
62. 11. Visualizing Power View Data Using Matrices, Cards, and Tiles/Creating a tile .mp47.03MB
63. 11. Visualizing Power View Data Using Matrices, Cards, and Tiles/Installing Microsoft Silverlight .mp46.69MB
64. 10. Introducing Data Analysis Expressions/Adding calculated columns .mp46.69MB
65. 1. Creating and Pivoting PivotTables/Connecting to an external data source.mp46.68MB
66. 2. Summarizing PivotTable Data/Drilling down to the underlying data.mp46.64MB
67. 6. Creating and Manipulating PivotCharts/Changing a PivotChart's chart type.mp46.61MB
68. 6. Creating and Manipulating PivotCharts/Pivoting a PivotChart .mp46.38MB
69. 11. Visualizing Power View Data Using Matrices, Cards, and Tiles/Formatting Power View objects.mp46.3MB
70. 2. Summarizing PivotTable Data/Summarizing more than one data field.mp46.27MB
71. 12. Visualizing Power View Data Using Charts and Maps/Creating a line chart.mp46.15MB
72. 12. Visualizing Power View Data Using Charts and Maps/Creating a map.mp46.08MB
73. 12. Visualizing Power View Data Using Charts and Maps/Creating chart multiples.mp46.06MB
74. 3. Sorting and Filtering PivotTable Data/Clearing and reapplying PivotTable filters.mp45.96MB
75. 12. Visualizing Power View Data Using Charts and Maps/Creating maps with multivalue series.mp45.88MB
76. 11. Visualizing Power View Data Using Matrices, Cards, and Tiles/Starting out with Power View.mp45.23MB
77. 12. Visualizing Power View Data Using Charts and Maps/Creating a pie chart.mp44.56MB
78. 9. Starting with PowerPivot and the Data Model25m 44s/Enabling PowerPivot in Office 2013 Professional.mp44.07MB
79. 9. Starting with PowerPivot and the Data Model25m 44s/Adding tables to the data model .mp43.29MB
80. 7. Printing PivotTables/Printing a PivotChart .mp42.84MB
81. Conclusion/Next steps.mp41.47MB
82. 0. Introduction/What you should know before watching this course.mp41.33MB
83. 0. Introduction/Using the exercise files.mp41.09MB