Name Excel 2013 - Pivot Tables In Depth

File Type video

Size 760.43MB

UpdateDate 2024-9-7

hash *****178A6C6784BD5CF428A21AAE6F1D379772

Hot 2

Files 5. Applying Conditional Formats to PivotTables/Highlighting the top or bottom values in a PivotTable .mp4 | 20.04MB 2. Summarizing PivotTable Data/Changing the data field summary operation.mp4 | 17.55MB 1. Creating and Pivoting PivotTables/Consolidating data from multiple sources.mp4 | 17.50MB 5. Applying Conditional Formats to PivotTables/Editing a conditional formatting rule.mp4 | 15.34MB 4. Formatting PivotTables/Changing the PivotTable layout.mp4 | 15.14MB 4. Formatting PivotTables/Creating a PivotTable style.mp4 | 14.67MB 3. Sorting and Filtering PivotTable Data/Creating a custom sort order.mp4 | 13.90MB 5. Applying Conditional Formats to PivotTables/Highlighting cells by applying a rule.mp4 | 13.87MB 5. Applying Conditional Formats to PivotTables/Formatting cells using icon sets.mp4 | 13.02MB 9. Starting with PowerPivot and the Data Model25m 44s/Introducing PowerPivot.mp4 | 12.59MB 2. Summarizing PivotTable Data/Managing subtotals and grand totals.mp4 | 12.35MB 3. Sorting and Filtering PivotTable Data/Filtering with report filter fields.mp4 | 12.18MB 1. Creating and Pivoting PivotTables/Managing PivotTables.mp4 | 11.92MB 9. Starting with PowerPivot and the Data Model25m 44s/Creating a PowerPivot PivotTable.mp4 | 11.88MB 2. Summarizing PivotTable Data/Using PivotTable data in a formula.mp4 | 11.71MB 10. Introducing Data Analysis Expressions/Creating aggregate calculations .mp4 | 11.55MB 9. Starting with PowerPivot and the Data Model25m 44s/Managing table columns .mp4 | 11.42MB 5. Applying Conditional Formats to PivotTables/Formatting cells using data bars.mp4 | 11.39MB 9. Starting with PowerPivot and the Data Model25m 44s/Creating relationships between tables.mp4 | 11.35MB 9. Starting with PowerPivot and the Data Model25m 44s/Filtering data using a timeline.mp4 | 11.35MB 3. Sorting and Filtering PivotTable Data/Filtering a PivotTable field by selection.mp4 | 11.19MB 10. Introducing Data Analysis Expressions/Using DAX operators.mp4 | 11.09MB 2. Summarizing PivotTable Data/Grouping PivotTable fields.mp4 | 11.02MB 1. Creating and Pivoting PivotTables/Introducing PivotTables .mp4 | 10.83MB 7. Printing PivotTables/Printing headers at the top of each printed page.mp4 | 10.78MB 5. Applying Conditional Formats to PivotTables/Formatting cells using color scales.mp4 | 10.72MB 3. Sorting and Filtering PivotTable Data/Filtering a PivotTable using a search filter.mp4 | 10.38MB 1. Creating and Pivoting PivotTables/Configuring a PivotTable.mp4 | 10.29MB 3. Sorting and Filtering PivotTable Data/Sorting PivotTable data.mp4 | 10.26MB 8. Manipulating PivotTables Using Macros/Running an Excel macro .mp4 | 10.20MB 6. Creating and Manipulating PivotCharts/Formatting a PivotChart.mp4 | 10.13MB 5. Applying Conditional Formats to PivotTables/Controlling how multiple rules are applied.mp4 | 10.00MB 7. Printing PivotTables/Printing each item on its own pages..mp4 | 9.98MB 11. Visualizing Power View Data Using Matrices, Cards, and Tiles/Creating a table or matrix .mp4 | 9.85MB 3. Sorting and Filtering PivotTable Data/Filtering a PivotTable using slicers .mp4 | 9.76MB 2. Summarizing PivotTable Data/Creating a calculated field .mp4 | 9.54MB 6. Creating and Manipulating PivotCharts/Changing a PivotChart's layout.mp4 | 9.42MB 0. Introduction/Welcome.mp4 | 9.39MB 8. Manipulating PivotTables Using Macros/Recording and reviewing an Excel macro.mp4 | 9.30MB 4. Formatting PivotTables/Applying a PivotTable style.mp4 | 9.28MB 12. Visualizing Power View Data Using Charts and Maps/Creating a column or bar chart.mp4 | 8.79MB 1. Creating and Pivoting PivotTables/Formatting data for use in a PivotTable.mp4 | 8.74MB 10. Introducing Data Analysis Expressions/Adding calculated fields.mp4 | 8.63MB 1. Creating and Pivoting PivotTables/Pivoting a PivotTable.mp4 | 8.47MB 7. Printing PivotTables/Printing a PivotTable.mp4 | 8.36MB 10. Introducing Data Analysis Expressions/Surveying DAX functions .mp4 | 8.24MB 6. Creating and Manipulating PivotCharts/Creating a PivotChart .mp4 | 8.24MB 3. Sorting and Filtering PivotTable Data/Formatting slicers.mp4 | 8.23MB 4. Formatting PivotTables/Changing the data field number format.mp4 | 8.22MB 1. Creating and Pivoting PivotTables/Creating a PivotTable .mp4 | 8.21MB 8. Manipulating PivotTables Using Macros/Creating a simple PivotTable presentation kit.mp4 | 7.99MB 11. Visualizing Power View Data Using Matrices, Cards, and Tiles/Filtering Power View objects.mp4 | 7.98MB 6. Creating and Manipulating PivotCharts/Adding a trendline to a PivotChart.mp4 | 7.87MB 1. Creating and Pivoting PivotTables/Creating a Recommended PivotTable.mp4 | 7.83MB 3. Sorting and Filtering PivotTable Data/Filtering a PivotTable by rule.mp4 | 7.79MB 10. Introducing Data Analysis Expressions/Creating filtered calculations .mp4 | 7.67MB 5. Applying Conditional Formats to PivotTables/Deleting a conditional formatting rule.mp4 | 7.42MB 10. Introducing Data Analysis Expressions/ntroducing the DAX language.mp4 | 7.40MB 11. Visualizing Power View Data Using Matrices, Cards, and Tiles/Creating a card.mp4 | 7.34MB 9. Starting with PowerPivot and the Data Model25m 44s/Importing PowerPivot data 3m .mp4 | 7.24MB 6. Creating and Manipulating PivotCharts/Filtering a PivotChart .mp4 | 7.21MB 11. Visualizing Power View Data Using Matrices, Cards, and Tiles/Creating a tile .mp4 | 7.03MB 11. Visualizing Power View Data Using Matrices, Cards, and Tiles/Installing Microsoft Silverlight .mp4 | 6.69MB 10. Introducing Data Analysis Expressions/Adding calculated columns .mp4 | 6.69MB 1. Creating and Pivoting PivotTables/Connecting to an external data source.mp4 | 6.68MB 2. Summarizing PivotTable Data/Drilling down to the underlying data.mp4 | 6.64MB 6. Creating and Manipulating PivotCharts/Changing a PivotChart's chart type.mp4 | 6.61MB 6. Creating and Manipulating PivotCharts/Pivoting a PivotChart .mp4 | 6.38MB 11. Visualizing Power View Data Using Matrices, Cards, and Tiles/Formatting Power View objects.mp4 | 6.30MB 2. Summarizing PivotTable Data/Summarizing more than one data field.mp4 | 6.27MB 12. Visualizing Power View Data Using Charts and Maps/Creating a line chart.mp4 | 6.15MB 12. Visualizing Power View Data Using Charts and Maps/Creating a map.mp4 | 6.08MB 12. Visualizing Power View Data Using Charts and Maps/Creating chart multiples.mp4 | 6.06MB 3. Sorting and Filtering PivotTable Data/Clearing and reapplying PivotTable filters.mp4 | 5.96MB 12. Visualizing Power View Data Using Charts and Maps/Creating maps with multivalue series.mp4 | 5.88MB 11. Visualizing Power View Data Using Matrices, Cards, and Tiles/Starting out with Power View.mp4 | 5.23MB 12. Visualizing Power View Data Using Charts and Maps/Creating a pie chart.mp4 | 4.56MB 9. Starting with PowerPivot and the Data Model25m 44s/Enabling PowerPivot in Office 2013 Professional.mp4 | 4.07MB 9. Starting with PowerPivot and the Data Model25m 44s/Adding tables to the data model .mp4 | 3.29MB 7. Printing PivotTables/Printing a PivotChart .mp4 | 2.84MB Conclusion/Next steps.mp4 | 1.47MB 0. Introduction/What you should know before watching this course.mp4 | 1.33MB 0. Introduction/Using the exercise files.mp4 | 1.09MB Exercise Files/Chapter09/DataSource.accdb | 440.00KB Exercise Files/Chapter09/Timeline.xlsx | 215.07KB Exercise Files/Chapter09/Introducing.xlsx | 206.84KB Exercise Files/Chapter09/CreatePivot.xlsx | 203.45KB Exercise Files/Chapter09/CreateRelationship.xlsx | 203.41KB Exercise Files/Chapter11/Filter.xlsx | 178.66KB Exercise Files/Chapter11/Format.xlsx | 178.39KB Exercise Files/Chapter12/Line.xlsx | 178.36KB Exercise Files/Chapter12/ColumnAndBar.xlsx | 178.35KB Exercise Files/Chapter12/Pie.xlsx | 178.13KB Exercise Files/Chapter11/Tiles.xlsx | 176.26KB Exercise Files/Chapter11/Card.xlsx | 176.20KB Exercise Files/Chapter10/CalculatedField.xlsx | 171.72KB Exercise Files/Chapter10/Introducing.xlsx | 159.11KB Exercise Files/Chapter10/Operators.xlsx | 158.21KB Exercise Files/Chapter09/ManageColumns.xlsx | 158.17KB Exercise Files/Chapter10/Survey.xlsx | 158.16KB Exercise Files/Chapter10/CalculatedColumn.xlsx | 158.12KB Exercise Files/Chapter12/Map.xlsx | 148.29KB Exercise Files/Chapter12/Multiples.xlsx | 140.47KB Exercise Files/Chapter12/MultiSeries.xlsx | 139.94KB Exercise Files/Chapter11/Table.xlsx | 128.27KB Exercise Files/Chapter10/Aggregate.xlsx | 127.61KB Exercise Files/Chapter10/Filtered.xlsx | 127.61KB Exercise Files/Chapter10/DAX Operators.pptx | 34.60KB Exercise Files/Chapter08/PresentationKit.xlsm | 21.31KB Exercise Files/Chapter08/RunMacro.xlsm | 20.36KB Exercise Files/Chapter07/PrintEachItem.xlsx | 20.30KB Exercise Files/Chapter07/PrintHeaders.xlsx | 20.22KB Exercise Files/Chapter09/CustomerInfo.xlsx | 19.08KB Exercise Files/Chapter06/ChartType.xlsx | 19.07KB Exercise Files/Chapter07/PrintChart.xlsx | 19.03KB Exercise Files/Chapter06/Layout.xlsx | 18.95KB Exercise Files/Chapter06/Formatting.xlsx | 18.95KB Exercise Files/Chapter06/Pivoting.xlsx | 18.95KB Exercise Files/Chapter06/Filtering.xlsx | 18.95KB Exercise Files/Chapter06/Trendline.xlsx | 18.55KB Exercise Files/Chapter02/Grouping.xlsx | 16.87KB Exercise Files/Chapter01/ExternalData.xlsx | 16.42KB Exercise Files/Chapter05/Multiple.xlsx | 16.16KB Exercise Files/Chapter05/Delete.xlsx | 16.16KB Exercise Files/Chapter05/EditingRules.xlsx | 16.08KB Exercise Files/Chapter08/RecordMacro.xlsx | 16.07KB Exercise Files/Chapter07/PrintPivot.xlsx | 16.07KB Exercise Files/Chapter05/DataBars.xlsx | 16.02KB Exercise Files/Chapter04/NumberFormat.xlsx | 16.01KB Exercise Files/Chapter05/FormatRule.xlsx | 16.00KB Exercise Files/Chapter05/TopValues.xlsx | 16.00KB Exercise Files/Chapter05/ColorScales.xlsx | 16.00KB Exercise Files/Chapter08/PresentationKit.xlsx | 15.84KB Exercise Files/Chapter05/IconSets.xlsx | 15.80KB Exercise Files/Chapter03/Sorting.xlsx | 15.60KB Exercise Files/Chapter03/Custom.xlsx | 15.42KB Exercise Files/Chapter02/Calculated.xlsx | 15.00KB Exercise Files/Chapter02/Formula.xlsx | 14.83KB Exercise Files/Chapter02/MoreThanOne.xlsx | 14.78KB Exercise Files/Chapter01/Introducing.xlsx | 14.74KB Exercise Files/Chapter03/FilterSummary.xlsx | 14.72KB Exercise Files/Chapter03/Selection.xlsx | 14.71KB Exercise Files/Chapter02/DrillDown.xlsx | 14.71KB Exercise Files/Chapter04/DefineStyle.xlsx | 14.60KB Exercise Files/Chapter04/ApplyStyle.xlsx | 14.60KB Exercise Files/Chapter03/Clear.xlsx | 14.53KB Exercise Files/Chapter03/SearchFilter.xlsx | 14.48KB Exercise Files/Chapter01/Clear.xlsx | 14.31KB Exercise Files/Chapter02/Totals.xlsx | 14.31KB Exercise Files/Chapter04/Layout.xlsx | 14.31KB Exercise Files/Chapter02/Summary.xlsx | 14.31KB Exercise Files/Chapter01/Managing.xlsx | 14.29KB Exercise Files/Chapter03/Slicer.xlsx | 14.20KB Exercise Files/Chapter01/Configuring.xlsx | 14.20KB Exercise Files/Chapter03/Rule.xlsx | 14.20KB Exercise Files/Chapter03/FormatSlicer.xlsx | 14.20KB Exercise Files/Chapter03/ReportFilter.xlsx | 13.88KB Exercise Files/Chapter01/Pivoting.xlsx | 13.78KB Exercise Files/Chapter12/CalculatedColumn.xlsx | 13.41KB Exercise Files/Chapter09/Sales.xlsx | 13.41KB Exercise Files/Chapter09/AddToModel.xlsx | 13.41KB Exercise Files/Chapter12/Sales.xlsx | 13.41KB Exercise Files/Chapter12/BaseData.xlsx | 12.62KB Exercise Files/Chapter11/BaseData.xlsx | 12.52KB Exercise Files/Chapter01/Consolidating.xlsx | 10.48KB Exercise Files/Chapter11/Enable.xlsx | 10.35KB Exercise Files/Chapter06/CreatePivot.xlsx | 9.41KB Exercise Files/Chapter01/Create.xlsx | 9.41KB Exercise Files/Chapter01/Recommended.xlsx | 9.41KB Exercise Files/Chapter01/FormatData.xlsx | 8.49KB Exercise Files/Chapter01/Connect.xlsx | 7.46KB Exercise Files/Chapter09/Import.xlsx | 7.46KB Exercise Files/Chapter12/Import.xlsx | 7.46KB Exercise Files/Chapter12/BaseData.csv | 2.61KB Exercise Files/Chapter11/BaseData.csv | 2.61KB