- Excel 2013 Pivot Tables In Depth - sum1_here SilverRG
- 收录时间:2018-04-21 00:45:31
- 文件大小:760MB
- 下载次数:17
- 最近下载:2019-02-24 23:02:04
- 磁力链接:
-
文件列表
- 5. Applying Conditional Formats to PivotTables/Highlighting the top or bottom values in a PivotTable .mp4 20MB
- 2. Summarizing PivotTable Data/Changing the data field summary operation.mp4 18MB
- 1. Creating and Pivoting PivotTables/Consolidating data from multiple sources.mp4 18MB
- 5. Applying Conditional Formats to PivotTables/Editing a conditional formatting rule.mp4 15MB
- 4. Formatting PivotTables/Changing the PivotTable layout.mp4 15MB
- 4. Formatting PivotTables/Creating a PivotTable style.mp4 15MB
- 3. Sorting and Filtering PivotTable Data/Creating a custom sort order.mp4 14MB
- 5. Applying Conditional Formats to PivotTables/Highlighting cells by applying a rule.mp4 14MB
- 5. Applying Conditional Formats to PivotTables/Formatting cells using icon sets.mp4 13MB
- 9. Starting with PowerPivot and the Data Model25m 44s/Introducing PowerPivot.mp4 13MB
- 2. Summarizing PivotTable Data/Managing subtotals and grand totals.mp4 12MB
- 3. Sorting and Filtering PivotTable Data/Filtering with report filter fields.mp4 12MB
- 1. Creating and Pivoting PivotTables/Managing PivotTables.mp4 12MB
- 9. Starting with PowerPivot and the Data Model25m 44s/Creating a PowerPivot PivotTable.mp4 12MB
- 2. Summarizing PivotTable Data/Using PivotTable data in a formula.mp4 12MB
- 10. Introducing Data Analysis Expressions/Creating aggregate calculations .mp4 12MB
- 9. Starting with PowerPivot and the Data Model25m 44s/Managing table columns .mp4 11MB
- 5. Applying Conditional Formats to PivotTables/Formatting cells using data bars.mp4 11MB
- 9. Starting with PowerPivot and the Data Model25m 44s/Creating relationships between tables.mp4 11MB
- 9. Starting with PowerPivot and the Data Model25m 44s/Filtering data using a timeline.mp4 11MB
- 3. Sorting and Filtering PivotTable Data/Filtering a PivotTable field by selection.mp4 11MB
- 10. Introducing Data Analysis Expressions/Using DAX operators.mp4 11MB
- 2. Summarizing PivotTable Data/Grouping PivotTable fields.mp4 11MB
- 1. Creating and Pivoting PivotTables/Introducing PivotTables .mp4 11MB
- 7. Printing PivotTables/Printing headers at the top of each printed page.mp4 11MB
- 5. Applying Conditional Formats to PivotTables/Formatting cells using color scales.mp4 11MB
- 3. Sorting and Filtering PivotTable Data/Filtering a PivotTable using a search filter.mp4 10MB
- 1. Creating and Pivoting PivotTables/Configuring a PivotTable.mp4 10MB
- 3. Sorting and Filtering PivotTable Data/Sorting PivotTable data.mp4 10MB
- 8. Manipulating PivotTables Using Macros/Running an Excel macro .mp4 10MB
- 6. Creating and Manipulating PivotCharts/Formatting a PivotChart.mp4 10MB
- 5. Applying Conditional Formats to PivotTables/Controlling how multiple rules are applied.mp4 10MB
- 7. Printing PivotTables/Printing each item on its own pages..mp4 10MB
- 11. Visualizing Power View Data Using Matrices, Cards, and Tiles/Creating a table or matrix .mp4 10MB
- 3. Sorting and Filtering PivotTable Data/Filtering a PivotTable using slicers .mp4 10MB
- 2. Summarizing PivotTable Data/Creating a calculated field .mp4 10MB
- 6. Creating and Manipulating PivotCharts/Changing a PivotChart's layout.mp4 9MB
- 0. Introduction/Welcome.mp4 9MB
- 8. Manipulating PivotTables Using Macros/Recording and reviewing an Excel macro.mp4 9MB
- 4. Formatting PivotTables/Applying a PivotTable style.mp4 9MB
- 12. Visualizing Power View Data Using Charts and Maps/Creating a column or bar chart.mp4 9MB
- 1. Creating and Pivoting PivotTables/Formatting data for use in a PivotTable.mp4 9MB
- 10. Introducing Data Analysis Expressions/Adding calculated fields.mp4 9MB
- 1. Creating and Pivoting PivotTables/Pivoting a PivotTable.mp4 8MB
- 7. Printing PivotTables/Printing a PivotTable.mp4 8MB
- 10. Introducing Data Analysis Expressions/Surveying DAX functions .mp4 8MB
- 6. Creating and Manipulating PivotCharts/Creating a PivotChart .mp4 8MB
- 3. Sorting and Filtering PivotTable Data/Formatting slicers.mp4 8MB
- 4. Formatting PivotTables/Changing the data field number format.mp4 8MB
- 1. Creating and Pivoting PivotTables/Creating a PivotTable .mp4 8MB
- 8. Manipulating PivotTables Using Macros/Creating a simple PivotTable presentation kit.mp4 8MB
- 11. Visualizing Power View Data Using Matrices, Cards, and Tiles/Filtering Power View objects.mp4 8MB
- 6. Creating and Manipulating PivotCharts/Adding a trendline to a PivotChart.mp4 8MB
- 1. Creating and Pivoting PivotTables/Creating a Recommended PivotTable.mp4 8MB
- 3. Sorting and Filtering PivotTable Data/Filtering a PivotTable by rule.mp4 8MB
- 10. Introducing Data Analysis Expressions/Creating filtered calculations .mp4 8MB
- 5. Applying Conditional Formats to PivotTables/Deleting a conditional formatting rule.mp4 7MB
- 10. Introducing Data Analysis Expressions/ntroducing the DAX language.mp4 7MB
- 11. Visualizing Power View Data Using Matrices, Cards, and Tiles/Creating a card.mp4 7MB
- 9. Starting with PowerPivot and the Data Model25m 44s/Importing PowerPivot data 3m .mp4 7MB
- 6. Creating and Manipulating PivotCharts/Filtering a PivotChart .mp4 7MB
- 11. Visualizing Power View Data Using Matrices, Cards, and Tiles/Creating a tile .mp4 7MB
- 11. Visualizing Power View Data Using Matrices, Cards, and Tiles/Installing Microsoft Silverlight .mp4 7MB
- 10. Introducing Data Analysis Expressions/Adding calculated columns .mp4 7MB
- 1. Creating and Pivoting PivotTables/Connecting to an external data source.mp4 7MB
- 2. Summarizing PivotTable Data/Drilling down to the underlying data.mp4 7MB
- 6. Creating and Manipulating PivotCharts/Changing a PivotChart's chart type.mp4 7MB
- 6. Creating and Manipulating PivotCharts/Pivoting a PivotChart .mp4 6MB
- 11. Visualizing Power View Data Using Matrices, Cards, and Tiles/Formatting Power View objects.mp4 6MB
- 2. Summarizing PivotTable Data/Summarizing more than one data field.mp4 6MB
- 12. Visualizing Power View Data Using Charts and Maps/Creating a line chart.mp4 6MB
- 12. Visualizing Power View Data Using Charts and Maps/Creating a map.mp4 6MB
- 12. Visualizing Power View Data Using Charts and Maps/Creating chart multiples.mp4 6MB
- 3. Sorting and Filtering PivotTable Data/Clearing and reapplying PivotTable filters.mp4 6MB
- 12. Visualizing Power View Data Using Charts and Maps/Creating maps with multivalue series.mp4 6MB
- 11. Visualizing Power View Data Using Matrices, Cards, and Tiles/Starting out with Power View.mp4 5MB
- 12. Visualizing Power View Data Using Charts and Maps/Creating a pie chart.mp4 5MB
- 9. Starting with PowerPivot and the Data Model25m 44s/Enabling PowerPivot in Office 2013 Professional.mp4 4MB
- 9. Starting with PowerPivot and the Data Model25m 44s/Adding tables to the data model .mp4 3MB
- 7. Printing PivotTables/Printing a PivotChart .mp4 3MB
- Conclusion/Next steps.mp4 1MB
- 0. Introduction/What you should know before watching this course.mp4 1MB
- 0. Introduction/Using the exercise files.mp4 1MB
- Exercise Files/Chapter09/DataSource.accdb 440KB
- Exercise Files/Chapter09/Timeline.xlsx 215KB
- Exercise Files/Chapter09/Introducing.xlsx 207KB
- Exercise Files/Chapter09/CreatePivot.xlsx 203KB
- Exercise Files/Chapter09/CreateRelationship.xlsx 203KB
- Exercise Files/Chapter11/Filter.xlsx 179KB
- Exercise Files/Chapter11/Format.xlsx 178KB
- Exercise Files/Chapter12/Line.xlsx 178KB
- Exercise Files/Chapter12/ColumnAndBar.xlsx 178KB
- Exercise Files/Chapter12/Pie.xlsx 178KB
- Exercise Files/Chapter11/Tiles.xlsx 176KB
- Exercise Files/Chapter11/Card.xlsx 176KB
- Exercise Files/Chapter10/CalculatedField.xlsx 172KB
- Exercise Files/Chapter10/Introducing.xlsx 159KB
- Exercise Files/Chapter10/Operators.xlsx 158KB
- Exercise Files/Chapter09/ManageColumns.xlsx 158KB
- Exercise Files/Chapter10/Survey.xlsx 158KB
- Exercise Files/Chapter10/CalculatedColumn.xlsx 158KB
- Exercise Files/Chapter12/Map.xlsx 148KB
- Exercise Files/Chapter12/Multiples.xlsx 140KB
- Exercise Files/Chapter12/MultiSeries.xlsx 140KB
- Exercise Files/Chapter11/Table.xlsx 128KB
- Exercise Files/Chapter10/Aggregate.xlsx 128KB
- Exercise Files/Chapter10/Filtered.xlsx 128KB
- Exercise Files/Chapter10/DAX Operators.pptx 35KB
- Exercise Files/Chapter08/PresentationKit.xlsm 21KB
- Exercise Files/Chapter08/RunMacro.xlsm 20KB
- Exercise Files/Chapter07/PrintEachItem.xlsx 20KB
- Exercise Files/Chapter07/PrintHeaders.xlsx 20KB
- Exercise Files/Chapter09/CustomerInfo.xlsx 19KB
- Exercise Files/Chapter06/ChartType.xlsx 19KB
- Exercise Files/Chapter07/PrintChart.xlsx 19KB
- Exercise Files/Chapter06/Formatting.xlsx 19KB
- Exercise Files/Chapter06/Layout.xlsx 19KB
- Exercise Files/Chapter06/Pivoting.xlsx 19KB
- Exercise Files/Chapter06/Filtering.xlsx 19KB
- Exercise Files/Chapter06/Trendline.xlsx 19KB
- Exercise Files/Chapter02/Grouping.xlsx 17KB
- Exercise Files/Chapter01/ExternalData.xlsx 16KB
- Exercise Files/Chapter05/Delete.xlsx 16KB
- Exercise Files/Chapter05/Multiple.xlsx 16KB
- Exercise Files/Chapter05/EditingRules.xlsx 16KB
- Exercise Files/Chapter08/RecordMacro.xlsx 16KB
- Exercise Files/Chapter07/PrintPivot.xlsx 16KB
- Exercise Files/Chapter05/DataBars.xlsx 16KB
- Exercise Files/Chapter04/NumberFormat.xlsx 16KB
- Exercise Files/Chapter05/FormatRule.xlsx 16KB
- Exercise Files/Chapter05/TopValues.xlsx 16KB
- Exercise Files/Chapter05/ColorScales.xlsx 16KB
- Exercise Files/Chapter08/PresentationKit.xlsx 16KB
- Exercise Files/Chapter05/IconSets.xlsx 16KB
- Exercise Files/Chapter03/Sorting.xlsx 16KB
- Exercise Files/Chapter03/Custom.xlsx 15KB
- Exercise Files/Chapter02/Calculated.xlsx 15KB
- Exercise Files/Chapter02/Formula.xlsx 15KB
- Exercise Files/Chapter02/MoreThanOne.xlsx 15KB
- Exercise Files/Chapter01/Introducing.xlsx 15KB
- Exercise Files/Chapter03/FilterSummary.xlsx 15KB
- Exercise Files/Chapter03/Selection.xlsx 15KB
- Exercise Files/Chapter02/DrillDown.xlsx 15KB
- Exercise Files/Chapter04/DefineStyle.xlsx 15KB
- Exercise Files/Chapter04/ApplyStyle.xlsx 15KB
- Exercise Files/Chapter03/Clear.xlsx 15KB
- Exercise Files/Chapter03/SearchFilter.xlsx 14KB
- Exercise Files/Chapter01/Clear.xlsx 14KB
- Exercise Files/Chapter02/Totals.xlsx 14KB
- Exercise Files/Chapter02/Summary.xlsx 14KB
- Exercise Files/Chapter04/Layout.xlsx 14KB
- Exercise Files/Chapter01/Managing.xlsx 14KB
- Exercise Files/Chapter01/Configuring.xlsx 14KB
- Exercise Files/Chapter03/Slicer.xlsx 14KB
- Exercise Files/Chapter03/FormatSlicer.xlsx 14KB
- Exercise Files/Chapter03/Rule.xlsx 14KB
- Exercise Files/Chapter03/ReportFilter.xlsx 14KB
- Exercise Files/Chapter01/Pivoting.xlsx 14KB
- Exercise Files/Chapter09/AddToModel.xlsx 13KB
- Exercise Files/Chapter09/Sales.xlsx 13KB
- Exercise Files/Chapter12/CalculatedColumn.xlsx 13KB
- Exercise Files/Chapter12/Sales.xlsx 13KB
- Exercise Files/Chapter12/BaseData.xlsx 13KB
- Exercise Files/Chapter11/BaseData.xlsx 13KB
- Exercise Files/Chapter01/Consolidating.xlsx 10KB
- Exercise Files/Chapter11/Enable.xlsx 10KB
- Exercise Files/Chapter06/CreatePivot.xlsx 9KB
- Exercise Files/Chapter01/Create.xlsx 9KB
- Exercise Files/Chapter01/Recommended.xlsx 9KB
- Exercise Files/Chapter01/FormatData.xlsx 8KB
- Exercise Files/Chapter01/Connect.xlsx 7KB
- Exercise Files/Chapter09/Import.xlsx 7KB
- Exercise Files/Chapter12/Import.xlsx 7KB
- Exercise Files/Chapter11/BaseData.csv 3KB
- Exercise Files/Chapter12/BaseData.csv 3KB
- Downloaded from SilverTorrent.ORG.txt 64B