Download link
File List
-
5. Applying Conditional Formats to PivotTables/Highlighting the top or bottom values in a PivotTable .mp4 20.04 MB
2. Summarizing PivotTable Data/Changing the data field summary operation.mp4 17.55 MB
1. Creating and Pivoting PivotTables/Consolidating data from multiple sources.mp4 17.5 MB
5. Applying Conditional Formats to PivotTables/Editing a conditional formatting rule.mp4 15.34 MB
4. Formatting PivotTables/Changing the PivotTable layout.mp4 15.14 MB
4. Formatting PivotTables/Creating a PivotTable style.mp4 14.67 MB
3. Sorting and Filtering PivotTable Data/Creating a custom sort order.mp4 13.9 MB
5. Applying Conditional Formats to PivotTables/Highlighting cells by applying a rule.mp4 13.87 MB
5. Applying Conditional Formats to PivotTables/Formatting cells using icon sets.mp4 13.02 MB
9. Starting with PowerPivot and the Data Model25m 44s/Introducing PowerPivot.mp4 12.59 MB
2. Summarizing PivotTable Data/Managing subtotals and grand totals.mp4 12.35 MB
3. Sorting and Filtering PivotTable Data/Filtering with report filter fields.mp4 12.18 MB
1. Creating and Pivoting PivotTables/Managing PivotTables.mp4 11.92 MB
9. Starting with PowerPivot and the Data Model25m 44s/Creating a PowerPivot PivotTable.mp4 11.88 MB
2. Summarizing PivotTable Data/Using PivotTable data in a formula.mp4 11.71 MB
10. Introducing Data Analysis Expressions/Creating aggregate calculations .mp4 11.55 MB
9. Starting with PowerPivot and the Data Model25m 44s/Managing table columns .mp4 11.42 MB
5. Applying Conditional Formats to PivotTables/Formatting cells using data bars.mp4 11.39 MB
9. Starting with PowerPivot and the Data Model25m 44s/Creating relationships between tables.mp4 11.35 MB
9. Starting with PowerPivot and the Data Model25m 44s/Filtering data using a timeline.mp4 11.35 MB
3. Sorting and Filtering PivotTable Data/Filtering a PivotTable field by selection.mp4 11.19 MB
10. Introducing Data Analysis Expressions/Using DAX operators.mp4 11.09 MB
2. Summarizing PivotTable Data/Grouping PivotTable fields.mp4 11.02 MB
1. Creating and Pivoting PivotTables/Introducing PivotTables .mp4 10.83 MB
7. Printing PivotTables/Printing headers at the top of each printed page.mp4 10.78 MB
5. Applying Conditional Formats to PivotTables/Formatting cells using color scales.mp4 10.72 MB
3. Sorting and Filtering PivotTable Data/Filtering a PivotTable using a search filter.mp4 10.38 MB
1. Creating and Pivoting PivotTables/Configuring a PivotTable.mp4 10.29 MB
3. Sorting and Filtering PivotTable Data/Sorting PivotTable data.mp4 10.26 MB
8. Manipulating PivotTables Using Macros/Running an Excel macro .mp4 10.2 MB
6. Creating and Manipulating PivotCharts/Formatting a PivotChart.mp4 10.13 MB
5. Applying Conditional Formats to PivotTables/Controlling how multiple rules are applied.mp4 10 MB
7. Printing PivotTables/Printing each item on its own pages..mp4 9.98 MB
11. Visualizing Power View Data Using Matrices, Cards, and Tiles/Creating a table or matrix .mp4 9.85 MB
3. Sorting and Filtering PivotTable Data/Filtering a PivotTable using slicers .mp4 9.76 MB
2. Summarizing PivotTable Data/Creating a calculated field .mp4 9.54 MB
6. Creating and Manipulating PivotCharts/Changing a PivotChart's layout.mp4 9.42 MB
0. Introduction/Welcome.mp4 9.39 MB
8. Manipulating PivotTables Using Macros/Recording and reviewing an Excel macro.mp4 9.3 MB
4. Formatting PivotTables/Applying a PivotTable style.mp4 9.28 MB
12. Visualizing Power View Data Using Charts and Maps/Creating a column or bar chart.mp4 8.79 MB
1. Creating and Pivoting PivotTables/Formatting data for use in a PivotTable.mp4 8.74 MB
10. Introducing Data Analysis Expressions/Adding calculated fields.mp4 8.63 MB
1. Creating and Pivoting PivotTables/Pivoting a PivotTable.mp4 8.47 MB
7. Printing PivotTables/Printing a PivotTable.mp4 8.36 MB
10. Introducing Data Analysis Expressions/Surveying DAX functions .mp4 8.24 MB
6. Creating and Manipulating PivotCharts/Creating a PivotChart .mp4 8.24 MB
3. Sorting and Filtering PivotTable Data/Formatting slicers.mp4 8.23 MB
4. Formatting PivotTables/Changing the data field number format.mp4 8.22 MB
1. Creating and Pivoting PivotTables/Creating a PivotTable .mp4 8.21 MB
8. Manipulating PivotTables Using Macros/Creating a simple PivotTable presentation kit.mp4 7.99 MB
11. Visualizing Power View Data Using Matrices, Cards, and Tiles/Filtering Power View objects.mp4 7.98 MB
6. Creating and Manipulating PivotCharts/Adding a trendline to a PivotChart.mp4 7.87 MB
1. Creating and Pivoting PivotTables/Creating a Recommended PivotTable.mp4 7.83 MB
3. Sorting and Filtering PivotTable Data/Filtering a PivotTable by rule.mp4 7.79 MB
10. Introducing Data Analysis Expressions/Creating filtered calculations .mp4 7.67 MB
5. Applying Conditional Formats to PivotTables/Deleting a conditional formatting rule.mp4 7.42 MB
10. Introducing Data Analysis Expressions/ntroducing the DAX language.mp4 7.4 MB
11. Visualizing Power View Data Using Matrices, Cards, and Tiles/Creating a card.mp4 7.34 MB
9. Starting with PowerPivot and the Data Model25m 44s/Importing PowerPivot data 3m .mp4 7.24 MB
6. Creating and Manipulating PivotCharts/Filtering a PivotChart .mp4 7.21 MB
11. Visualizing Power View Data Using Matrices, Cards, and Tiles/Creating a tile .mp4 7.03 MB
11. Visualizing Power View Data Using Matrices, Cards, and Tiles/Installing Microsoft Silverlight .mp4 6.69 MB
10. Introducing Data Analysis Expressions/Adding calculated columns .mp4 6.69 MB
1. Creating and Pivoting PivotTables/Connecting to an external data source.mp4 6.68 MB
2. Summarizing PivotTable Data/Drilling down to the underlying data.mp4 6.64 MB
6. Creating and Manipulating PivotCharts/Changing a PivotChart's chart type.mp4 6.61 MB
6. Creating and Manipulating PivotCharts/Pivoting a PivotChart .mp4 6.38 MB
11. Visualizing Power View Data Using Matrices, Cards, and Tiles/Formatting Power View objects.mp4 6.3 MB
2. Summarizing PivotTable Data/Summarizing more than one data field.mp4 6.27 MB
12. Visualizing Power View Data Using Charts and Maps/Creating a line chart.mp4 6.15 MB
12. Visualizing Power View Data Using Charts and Maps/Creating a map.mp4 6.08 MB
12. Visualizing Power View Data Using Charts and Maps/Creating chart multiples.mp4 6.06 MB
3. Sorting and Filtering PivotTable Data/Clearing and reapplying PivotTable filters.mp4 5.96 MB
12. Visualizing Power View Data Using Charts and Maps/Creating maps with multivalue series.mp4 5.88 MB
11. Visualizing Power View Data Using Matrices, Cards, and Tiles/Starting out with Power View.mp4 5.23 MB
12. Visualizing Power View Data Using Charts and Maps/Creating a pie chart.mp4 4.56 MB
9. Starting with PowerPivot and the Data Model25m 44s/Enabling PowerPivot in Office 2013 Professional.mp4 4.07 MB
9. Starting with PowerPivot and the Data Model25m 44s/Adding tables to the data model .mp4 3.29 MB
7. Printing PivotTables/Printing a PivotChart .mp4 2.84 MB
Conclusion/Next steps.mp4 1.47 MB
0. Introduction/What you should know before watching this course.mp4 1.33 MB
0. Introduction/Using the exercise files.mp4 1.09 MB
Exercise Files/Chapter09/DataSource.accdb 440 KB
Exercise Files/Chapter09/Timeline.xlsx 215.07 KB
Exercise Files/Chapter09/Introducing.xlsx 206.84 KB
Exercise Files/Chapter09/CreatePivot.xlsx 203.45 KB
Exercise Files/Chapter09/CreateRelationship.xlsx 203.41 KB
Exercise Files/Chapter11/Filter.xlsx 178.66 KB
Exercise Files/Chapter11/Format.xlsx 178.39 KB
Exercise Files/Chapter12/Line.xlsx 178.36 KB
Exercise Files/Chapter12/ColumnAndBar.xlsx 178.35 KB
Exercise Files/Chapter12/Pie.xlsx 178.13 KB
Exercise Files/Chapter11/Tiles.xlsx 176.26 KB
Exercise Files/Chapter11/Card.xlsx 176.2 KB
Exercise Files/Chapter10/CalculatedField.xlsx 171.72 KB
Exercise Files/Chapter10/Introducing.xlsx 159.11 KB
Exercise Files/Chapter10/Operators.xlsx 158.21 KB
Exercise Files/Chapter09/ManageColumns.xlsx 158.17 KB
Exercise Files/Chapter10/Survey.xlsx 158.16 KB
Exercise Files/Chapter10/CalculatedColumn.xlsx 158.12 KB
Exercise Files/Chapter12/Map.xlsx 148.29 KB
Exercise Files/Chapter12/Multiples.xlsx 140.47 KB
Exercise Files/Chapter12/MultiSeries.xlsx 139.94 KB
Exercise Files/Chapter11/Table.xlsx 128.27 KB
Exercise Files/Chapter10/Aggregate.xlsx 127.61 KB
Exercise Files/Chapter10/Filtered.xlsx 127.61 KB
Exercise Files/Chapter10/DAX Operators.pptx 34.6 KB
Exercise Files/Chapter08/PresentationKit.xlsm 21.31 KB
Exercise Files/Chapter08/RunMacro.xlsm 20.36 KB
Exercise Files/Chapter07/PrintEachItem.xlsx 20.3 KB
Exercise Files/Chapter07/PrintHeaders.xlsx 20.22 KB
Exercise Files/Chapter09/CustomerInfo.xlsx 19.08 KB
Exercise Files/Chapter06/ChartType.xlsx 19.07 KB
Exercise Files/Chapter07/PrintChart.xlsx 19.03 KB
Exercise Files/Chapter06/Layout.xlsx 18.95 KB
Exercise Files/Chapter06/Formatting.xlsx 18.95 KB
Exercise Files/Chapter06/Pivoting.xlsx 18.95 KB
Exercise Files/Chapter06/Filtering.xlsx 18.95 KB
Exercise Files/Chapter06/Trendline.xlsx 18.55 KB
Exercise Files/Chapter02/Grouping.xlsx 16.87 KB
Exercise Files/Chapter01/ExternalData.xlsx 16.42 KB
Exercise Files/Chapter05/Multiple.xlsx 16.16 KB
Exercise Files/Chapter05/Delete.xlsx 16.16 KB
Exercise Files/Chapter05/EditingRules.xlsx 16.08 KB
Exercise Files/Chapter08/RecordMacro.xlsx 16.07 KB
Exercise Files/Chapter07/PrintPivot.xlsx 16.07 KB
Exercise Files/Chapter05/DataBars.xlsx 16.02 KB
Exercise Files/Chapter04/NumberFormat.xlsx 16.01 KB
Exercise Files/Chapter05/FormatRule.xlsx 16 KB
Exercise Files/Chapter05/TopValues.xlsx 16 KB
Exercise Files/Chapter05/ColorScales.xlsx 16 KB
Exercise Files/Chapter08/PresentationKit.xlsx 15.84 KB
Exercise Files/Chapter05/IconSets.xlsx 15.8 KB
Exercise Files/Chapter03/Sorting.xlsx 15.6 KB
Exercise Files/Chapter03/Custom.xlsx 15.42 KB
Exercise Files/Chapter02/Calculated.xlsx 15 KB
Exercise Files/Chapter02/Formula.xlsx 14.83 KB
Exercise Files/Chapter02/MoreThanOne.xlsx 14.78 KB
Exercise Files/Chapter01/Introducing.xlsx 14.74 KB
Exercise Files/Chapter03/FilterSummary.xlsx 14.72 KB
Exercise Files/Chapter03/Selection.xlsx 14.71 KB
Exercise Files/Chapter02/DrillDown.xlsx 14.71 KB
Exercise Files/Chapter04/DefineStyle.xlsx 14.6 KB
Exercise Files/Chapter04/ApplyStyle.xlsx 14.6 KB
Exercise Files/Chapter03/Clear.xlsx 14.53 KB
Exercise Files/Chapter03/SearchFilter.xlsx 14.48 KB
Exercise Files/Chapter01/Clear.xlsx 14.31 KB
Exercise Files/Chapter02/Totals.xlsx 14.31 KB
Exercise Files/Chapter04/Layout.xlsx 14.31 KB
Exercise Files/Chapter02/Summary.xlsx 14.31 KB
Exercise Files/Chapter01/Managing.xlsx 14.29 KB
Exercise Files/Chapter03/Slicer.xlsx 14.2 KB
Exercise Files/Chapter01/Configuring.xlsx 14.2 KB
Exercise Files/Chapter03/Rule.xlsx 14.2 KB
Exercise Files/Chapter03/FormatSlicer.xlsx 14.2 KB
Exercise Files/Chapter03/ReportFilter.xlsx 13.88 KB
Exercise Files/Chapter01/Pivoting.xlsx 13.78 KB
Exercise Files/Chapter12/CalculatedColumn.xlsx 13.41 KB
Exercise Files/Chapter09/Sales.xlsx 13.41 KB
Exercise Files/Chapter09/AddToModel.xlsx 13.41 KB
Exercise Files/Chapter12/Sales.xlsx 13.41 KB
Exercise Files/Chapter12/BaseData.xlsx 12.62 KB
Exercise Files/Chapter11/BaseData.xlsx 12.52 KB
Exercise Files/Chapter01/Consolidating.xlsx 10.48 KB
Exercise Files/Chapter11/Enable.xlsx 10.35 KB
Exercise Files/Chapter06/CreatePivot.xlsx 9.41 KB
Exercise Files/Chapter01/Create.xlsx 9.41 KB
Exercise Files/Chapter01/Recommended.xlsx 9.41 KB
Exercise Files/Chapter01/FormatData.xlsx 8.49 KB
Exercise Files/Chapter01/Connect.xlsx 7.46 KB
Exercise Files/Chapter09/Import.xlsx 7.46 KB
Exercise Files/Chapter12/Import.xlsx 7.46 KB
Exercise Files/Chapter12/BaseData.csv 2.61 KB
Exercise Files/Chapter11/BaseData.csv 2.61 KB
Download Info
-
Tips
“Excel 2013 - Pivot Tables In Depth” Its related downloads are collected from the DHT sharing network, the site will be 24 hours of real-time updates, to ensure that you get the latest resources.This site is not responsible for the authenticity of the resources, please pay attention to screening.If found bad resources, please send a report below the right, we will be the first time shielding.
-
DMCA Notice and Takedown Procedure
If this resource infringes your copyright, please email([email protected]) us or leave your message here ! we will block the download link as soon as possiable.