Excel 2013 Pivot Tables In Depth | D5F4C178A6C6784BD5CF428A21AAE6F1D3797722

Excel 2013 Pivot Tables In Depth

Name	Excel 2013 - Pivot Tables In Depth	DOWNLOAD Copy Link
Total Size	797.4 MB
Total Files	175
Hash	D5F4C178A6C6784BD5CF428A21AAE6F1D3797722

/5. Applying Conditional Formats to PivotTables/
Highlighting the top or bottom values in a PivotTable .mp4	21.0 MB
Editing a conditional formatting rule.mp4	16.1 MB
Highlighting cells by applying a rule.mp4	14.5 MB
Formatting cells using icon sets.mp4	13.6 MB
Formatting cells using data bars.mp4	11.9 MB
Formatting cells using color scales.mp4	11.2 MB
Controlling how multiple rules are applied.mp4	10.5 MB
Deleting a conditional formatting rule.mp4	7.8 MB
/2. Summarizing PivotTable Data/
Changing the data field summary operation.mp4	18.4 MB
Managing subtotals and grand totals.mp4	12.9 MB
Using PivotTable data in a formula.mp4	12.3 MB
Grouping PivotTable fields.mp4	11.6 MB
Creating a calculated field .mp4	10.0 MB
Drilling down to the underlying data.mp4	7.0 MB
Summarizing more than one data field.mp4	6.6 MB
/1. Creating and Pivoting PivotTables/
Consolidating data from multiple sources.mp4	18.4 MB
Managing PivotTables.mp4	12.5 MB
Introducing PivotTables .mp4	11.4 MB
Configuring a PivotTable.mp4	10.8 MB
Formatting data for use in a PivotTable.mp4	9.2 MB
Pivoting a PivotTable.mp4	8.9 MB
Creating a PivotTable .mp4	8.6 MB
Creating a Recommended PivotTable.mp4	8.2 MB
Connecting to an external data source.mp4	7.0 MB
/4. Formatting PivotTables/
Changing the PivotTable layout.mp4	15.9 MB
Creating a PivotTable style.mp4	15.4 MB
Applying a PivotTable style.mp4	9.7 MB
Changing the data field number format.mp4	8.6 MB
/3. Sorting and Filtering PivotTable Data/
Creating a custom sort order.mp4	14.6 MB
Filtering with report filter fields.mp4	12.8 MB
Filtering a PivotTable field by selection.mp4	11.7 MB
Filtering a PivotTable using a search filter.mp4	10.9 MB
Sorting PivotTable data.mp4	10.8 MB
Filtering a PivotTable using slicers .mp4	10.2 MB
Formatting slicers.mp4	8.6 MB
Filtering a PivotTable by rule.mp4	8.2 MB
Clearing and reapplying PivotTable filters.mp4	6.2 MB
/9. Starting with PowerPivot and the Data Model25m 44s/
Introducing PowerPivot.mp4	13.2 MB
Creating a PowerPivot PivotTable.mp4	12.5 MB
Managing table columns .mp4	12.0 MB
Creating relationships between tables.mp4	11.9 MB
Filtering data using a timeline.mp4	11.9 MB
Importing PowerPivot data 3m .mp4	7.6 MB
Enabling PowerPivot in Office 2013 Professional.mp4	4.3 MB
Adding tables to the data model .mp4	3.4 MB
/10. Introducing Data Analysis Expressions/
Creating aggregate calculations .mp4	12.1 MB
Using DAX operators.mp4	11.6 MB
Adding calculated fields.mp4	9.1 MB
Surveying DAX functions .mp4	8.6 MB
Creating filtered calculations .mp4	8.0 MB
ntroducing the DAX language.mp4	7.8 MB
Adding calculated columns .mp4	7.0 MB
/7. Printing PivotTables/
Printing headers at the top of each printed page.mp4	11.3 MB
Printing each item on its own pages..mp4	10.5 MB
Printing a PivotTable.mp4	8.8 MB
Printing a PivotChart .mp4	3.0 MB
/8. Manipulating PivotTables Using Macros/
Running an Excel macro .mp4	10.7 MB
Recording and reviewing an Excel macro.mp4	9.8 MB
Creating a simple PivotTable presentation kit.mp4	8.4 MB
/6. Creating and Manipulating PivotCharts/
Formatting a PivotChart.mp4	10.6 MB
Changing a PivotChart's layout.mp4	9.9 MB
Creating a PivotChart .mp4	8.6 MB
Adding a trendline to a PivotChart.mp4	8.3 MB
Filtering a PivotChart .mp4	7.6 MB
Changing a PivotChart's chart type.mp4	6.9 MB
Pivoting a PivotChart .mp4	6.7 MB
/11. Visualizing Power View Data Using Matrices, Cards, and Tiles/
Creating a table or matrix .mp4	10.3 MB
Filtering Power View objects.mp4	8.4 MB
Creating a card.mp4	7.7 MB
Creating a tile .mp4	7.4 MB
Installing Microsoft Silverlight .mp4	7.0 MB
Formatting Power View objects.mp4	6.6 MB
Starting out with Power View.mp4	5.5 MB
/0. Introduction/
Welcome.mp4	9.8 MB
What you should know before watching this course.mp4	1.4 MB
Using the exercise files.mp4	1.1 MB
/12. Visualizing Power View Data Using Charts and Maps/
Creating a column or bar chart.mp4	9.2 MB
Creating a line chart.mp4	6.5 MB
Creating a map.mp4	6.4 MB
Creating chart multiples.mp4	6.4 MB
Creating maps with multivalue series.mp4	6.2 MB
Creating a pie chart.mp4	4.8 MB
/Conclusion/
Next steps.mp4	1.5 MB
/Exercise Files/Chapter09/
DataSource.accdb	450.6 KB
Timeline.xlsx	220.2 KB
Introducing.xlsx	211.8 KB
CreatePivot.xlsx	208.3 KB
CreateRelationship.xlsx	208.3 KB
ManageColumns.xlsx	162.0 KB
CustomerInfo.xlsx	19.5 KB
Sales.xlsx	13.7 KB
AddToModel.xlsx	13.7 KB
Import.xlsx	7.6 KB
/Exercise Files/Chapter11/
Filter.xlsx	182.9 KB
Format.xlsx	182.7 KB
Tiles.xlsx	180.5 KB
Card.xlsx	180.4 KB
Table.xlsx	131.3 KB
BaseData.xlsx	12.8 KB
Enable.xlsx	10.6 KB
BaseData.csv	2.7 KB
/Exercise Files/Chapter12/
Line.xlsx	182.6 KB
ColumnAndBar.xlsx	182.6 KB
Pie.xlsx	182.4 KB
Map.xlsx	151.8 KB
Multiples.xlsx	143.8 KB
MultiSeries.xlsx	143.3 KB
CalculatedColumn.xlsx	13.7 KB
Sales.xlsx	13.7 KB
BaseData.xlsx	12.9 KB
Import.xlsx	7.6 KB
BaseData.csv	2.7 KB
/Exercise Files/Chapter10/
CalculatedField.xlsx	175.8 KB
Introducing.xlsx	162.9 KB
Operators.xlsx	162.0 KB
Survey.xlsx	162.0 KB
CalculatedColumn.xlsx	161.9 KB
Aggregate.xlsx	130.7 KB
Filtered.xlsx	130.7 KB
DAX Operators.pptx	35.4 KB
/Exercise Files/Chapter08/
PresentationKit.xlsm	21.8 KB
RunMacro.xlsm	20.8 KB
RecordMacro.xlsx	16.5 KB
PresentationKit.xlsx	16.2 KB
/Exercise Files/Chapter07/
PrintEachItem.xlsx	20.8 KB
PrintHeaders.xlsx	20.7 KB
PrintChart.xlsx	19.5 KB
PrintPivot.xlsx	16.5 KB
/Exercise Files/Chapter06/
ChartType.xlsx	19.5 KB
Layout.xlsx	19.4 KB
Formatting.xlsx	19.4 KB
Pivoting.xlsx	19.4 KB
Filtering.xlsx	19.4 KB
Trendline.xlsx	19.0 KB
CreatePivot.xlsx	9.6 KB
/Exercise Files/Chapter02/
Grouping.xlsx	17.3 KB
Calculated.xlsx	15.4 KB
Formula.xlsx	15.2 KB
MoreThanOne.xlsx	15.1 KB
DrillDown.xlsx	15.1 KB
Totals.xlsx	14.7 KB
Summary.xlsx	14.6 KB
/Exercise Files/Chapter01/
ExternalData.xlsx	16.8 KB
Introducing.xlsx	15.1 KB
Clear.xlsx	14.7 KB
Managing.xlsx	14.6 KB
Configuring.xlsx	14.5 KB
Pivoting.xlsx	14.1 KB
Consolidating.xlsx	10.7 KB
Create.xlsx	9.6 KB
Recommended.xlsx	9.6 KB
FormatData.xlsx	8.7 KB
Connect.xlsx	7.6 KB
/Exercise Files/Chapter05/
Multiple.xlsx	16.5 KB
Delete.xlsx	16.5 KB
EditingRules.xlsx	16.5 KB
DataBars.xlsx	16.4 KB
FormatRule.xlsx	16.4 KB
TopValues.xlsx	16.4 KB
ColorScales.xlsx	16.4 KB
IconSets.xlsx	16.2 KB
/Exercise Files/Chapter04/
NumberFormat.xlsx	16.4 KB
DefineStyle.xlsx	15.0 KB
ApplyStyle.xlsx	15.0 KB
Layout.xlsx	14.6 KB
/Exercise Files/Chapter03/
Sorting.xlsx	16.0 KB
Custom.xlsx	15.8 KB
FilterSummary.xlsx	15.1 KB
Selection.xlsx	15.1 KB
Clear.xlsx	14.9 KB
SearchFilter.xlsx	14.8 KB
Slicer.xlsx	14.5 KB
Rule.xlsx	14.5 KB
FormatSlicer.xlsx	14.5 KB
ReportFilter.xlsx	14.2 KB
Total files 175