Filename Size 0. Introduction/Using the exercise files.mp4 1.1 MB 0. Introduction/Welcome.mp4 9.4 MB 0. Introduction/What you should know before watching this course.mp4 1.3 MB 1. Creating and Pivoting PivotTables/Configuring a PivotTable.mp4 10.3 MB 1. Creating and Pivoting PivotTables/Connecting to an external data source.mp4 6.7 MB 1. Creating and Pivoting PivotTables/Consolidating data from multiple sources.mp4 17.5 MB 1. Creating and Pivoting PivotTables/Creating a PivotTable .mp4 8.2 MB 1. Creating and Pivoting PivotTables/Creating a Recommended PivotTable.mp4 7.8 MB 1. Creating and Pivoting PivotTables/Formatting data for use in a PivotTable.mp4 8.7 MB 1. Creating and Pivoting PivotTables/Introducing PivotTables .mp4 10.8 MB 1. Creating and Pivoting PivotTables/Managing PivotTables.mp4 11.9 MB 1. Creating and Pivoting PivotTables/Pivoting a PivotTable.mp4 8.5 MB 10. Introducing Data Analysis Expressions/Adding calculated columns .mp4 6.7 MB 10. Introducing Data Analysis Expressions/Adding calculated fields.mp4 8.6 MB 10. Introducing Data Analysis Expressions/Creating aggregate calculations .mp4 11.6 MB 10. Introducing Data Analysis Expressions/Creating filtered calculations .mp4 7.7 MB 10. Introducing Data Analysis Expressions/ntroducing the DAX language.mp4 7.4 MB 10. Introducing Data Analysis Expressions/Surveying DAX functions .mp4 8.2 MB 10. Introducing Data Analysis Expressions/Using DAX operators.mp4 11.1 MB 11. Visualizing Power View Data Using Matrices, Cards, and Tiles/Creating a card.mp4 7.3 MB 11. Visualizing Power View Data Using Matrices, Cards, and Tiles/Creating a table or matrix .mp4 9.8 MB 11. Visualizing Power View Data Using Matrices, Cards, and Tiles/Creating a tile .mp4 7 MB 11. Visualizing Power View Data Using Matrices, Cards, and Tiles/Filtering Power View objects.mp4 8 MB 11. Visualizing Power View Data Using Matrices, Cards, and Tiles/Formatting Power View objects.mp4 6.3 MB 11. Visualizing Power View Data Using Matrices, Cards, and Tiles/Installing Microsoft Silverlight .mp4 6.7 MB 11. Visualizing Power View Data Using Matrices, Cards, and Tiles/Starting out with Power View.mp4 5.2 MB 12. Visualizing Power View Data Using Charts and Maps/Creating a column or bar chart.mp4 8.8 MB 12. Visualizing Power View Data Using Charts and Maps/Creating a line chart.mp4 6.2 MB 12. Visualizing Power View Data Using Charts and Maps/Creating a map.mp4 6.1 MB 12. Visualizing Power View Data Using Charts and Maps/Creating a pie chart.mp4 4.6 MB 12. Visualizing Power View Data Using Charts and Maps/Creating chart multiples.mp4 6.1 MB 12. Visualizing Power View Data Using Charts and Maps/Creating maps with multivalue series.mp4 5.9 MB 2. Summarizing PivotTable Data/Changing the data field summary operation.mp4 17.6 MB 2. Summarizing PivotTable Data/Creating a calculated field .mp4 9.5 MB 2. Summarizing PivotTable Data/Drilling down to the underlying data.mp4 6.6 MB 2. Summarizing PivotTable Data/Grouping PivotTable fields.mp4 11 MB 2. Summarizing PivotTable Data/Managing subtotals and grand totals.mp4 12.3 MB 2. Summarizing PivotTable Data/Summarizing more than one data field.mp4 6.3 MB 2. Summarizing PivotTable Data/Using PivotTable data in a formula.mp4 11.7 MB 3. Sorting and Filtering PivotTable Data/Clearing and reapplying PivotTable filters.mp4 6 MB 3. Sorting and Filtering PivotTable Data/Creating a custom sort order.mp4 13.9 MB 3. Sorting and Filtering PivotTable Data/Filtering a PivotTable by rule.mp4 7.8 MB 3. Sorting and Filtering PivotTable Data/Filtering a PivotTable field by selection.mp4 11.2 MB 3. Sorting and Filtering PivotTable Data/Filtering a PivotTable using a search filter.mp4 10.4 MB 3. Sorting and Filtering PivotTable Data/Filtering a PivotTable using slicers .mp4 9.8 MB 3. Sorting and Filtering PivotTable Data/Filtering with report filter fields.mp4 12.2 MB 3. Sorting and Filtering PivotTable Data/Formatting slicers.mp4 8.2 MB 3. Sorting and Filtering PivotTable Data/Sorting PivotTable data.mp4 10.3 MB 4. Formatting PivotTables/Applying a PivotTable style.mp4 9.3 MB 4. Formatting PivotTables/Changing the data field number format.mp4 8.2 MB 4. Formatting PivotTables/Changing the PivotTable layout.mp4 15.1 MB 4. Formatting PivotTables/Creating a PivotTable style.mp4 14.7 MB 5. Applying Conditional Formats to PivotTables/Controlling how multiple rules are applied.mp4 10 MB 5. Applying Conditional Formats to PivotTables/Deleting a conditional formatting rule.mp4 7.4 MB 5. Applying Conditional Formats to PivotTables/Editing a conditional formatting rule.mp4 15.3 MB 5. Applying Conditional Formats to PivotTables/Formatting cells using color scales.mp4 10.7 MB 5. Applying Conditional Formats to PivotTables/Formatting cells using data bars.mp4 11.4 MB 5. Applying Conditional Formats to PivotTables/Formatting cells using icon sets.mp4 13 MB 5. Applying Conditional Formats to PivotTables/Highlighting cells by applying a rule.mp4 13.9 MB 5. Applying Conditional Formats to PivotTables/Highlighting the top or bottom values in a PivotTable .mp4 20 MB 6. Creating and Manipulating PivotCharts/Adding a trendline to a PivotChart.mp4 7.9 MB 6. Creating and Manipulating PivotCharts/Changing a PivotChart's chart type.mp4 6.6 MB 6. Creating and Manipulating PivotCharts/Changing a PivotChart's layout.mp4 9.4 MB 6. Creating and Manipulating PivotCharts/Creating a PivotChart .mp4 8.2 MB 6. Creating and Manipulating PivotCharts/Filtering a PivotChart .mp4 7.2 MB 6. Creating and Manipulating PivotCharts/Formatting a PivotChart.mp4 10.1 MB 6. Creating and Manipulating PivotCharts/Pivoting a PivotChart .mp4 6.4 MB 7. Printing PivotTables/Printing a PivotChart .mp4 2.8 MB 7. Printing PivotTables/Printing a PivotTable.mp4 8.4 MB 7. Printing PivotTables/Printing each item on its own pages..mp4 10 MB 7. Printing PivotTables/Printing headers at the top of each printed page.mp4 10.8 MB 8. Manipulating PivotTables Using Macros/Creating a simple PivotTable presentation kit.mp4 8 MB 8. Manipulating PivotTables Using Macros/Recording and reviewing an Excel macro.mp4 9.3 MB 8. Manipulating PivotTables Using Macros/Running an Excel macro .mp4 10.2 MB 9. Starting with PowerPivot and the Data Model25m 44s/Adding tables to the data model .mp4 3.3 MB 9. Starting with PowerPivot and the Data Model25m 44s/Creating a PowerPivot PivotTable.mp4 11.9 MB 9. Starting with PowerPivot and the Data Model25m 44s/Creating relationships between tables.mp4 11.4 MB 9. Starting with PowerPivot and the Data Model25m 44s/Enabling PowerPivot in Office 2013 Professional.mp4 4.1 MB 9. Starting with PowerPivot and the Data Model25m 44s/Filtering data using a timeline.mp4 11.3 MB 9. Starting with PowerPivot and the Data Model25m 44s/Importing PowerPivot data 3m .mp4 7.2 MB 9. Starting with PowerPivot and the Data Model25m 44s/Introducing PowerPivot.mp4 12.6 MB 9. Starting with PowerPivot and the Data Model25m 44s/Managing table columns .mp4 11.4 MB Conclusion/Next steps.mp4 1.5 MB Exercise Files/Chapter09/CreatePivot.xlsx 203.5 KB Exercise Files/Chapter09/CreateRelationship.xlsx 203.4 KB Exercise Files/Chapter09/DataSource.accdb 440 KB Exercise Files/Chapter09/Introducing.xlsx 206.8 KB Exercise Files/Chapter09/ManageColumns.xlsx 158.2 KB Exercise Files/Chapter09/Timeline.xlsx 215.1 KB Exercise Files/Chapter10/CalculatedField.xlsx 171.7 KB Exercise Files/Chapter10/Introducing.xlsx 159.1 KB Exercise Files/Chapter10/Operators.xlsx 158.2 KB Exercise Files/Chapter11/Card.xlsx 176.2 KB Exercise Files/Chapter11/Filter.xlsx 178.7 KB Exercise Files/Chapter11/Format.xlsx 178.4 KB Exercise Files/Chapter11/Tiles.xlsx 176.3 KB Exercise Files/Chapter12/ColumnAndBar.xlsx 178.4 KB Exercise Files/Chapter12/Line.xlsx 178.4 KB Exercise Files/Chapter12/Pie.xlsx 178.1 KB