Lynda Excel 2016 Pivot Tables in Depth | 5801CFE214EE8C5BE1E76A977CF8CB63D3A8643A

Lynda Excel 2016 Pivot Tables in Depth

Name	Lynda - Excel 2016 - Pivot Tables in Depth	DOWNLOAD Copy Link
Total Size	595.6 MB
Total Files	58
Hash	5801CFE214EE8C5BE1E76A977CF8CB63D3A8643A

/01. Introduction/
01_01-Welcome.mp4	7.2 MB
01_02-Using the exercise files.mp4	1.0 MB
/02. Creating and Pivoting PivotTables/
02_01-Introducing PivotTables.mp4	10.5 MB
02_02-Formatting data for use in a PivotTable.mp4	14.0 MB
02_03-Creating a PivotTable.mp4	10.4 MB
02_04-Creating a recommended PivotTable.mp4	6.7 MB
02_05-Pivoting a PivotTable.mp4	9.9 MB
02_06-Configuring a PivotTable.mp4	12.0 MB
02_07-Connecting to an external data source.mp4	5.9 MB
02_08-Consolidating data from multiple sources.mp4	11.5 MB
02_09-Managing PivotTables.mp4	14.5 MB
/03. Summarizing PivotTable Data/
03_01-Managing subtotals and grand totals.mp4	11.9 MB
03_02-Changing the data field summary operation.mp4	12.2 MB
03_03-Summarizing more than one data field.mp4	10.9 MB
03_04-Creating a calculated field.mp4	11.2 MB
03_05-Using PivotTable data in a formula.mp4	10.3 MB
03_06-Drilling down to the underlying data.mp4	10.2 MB
/04. Sorting and Filtering PivotTable Data/
04_01-Sorting PivotTable data.mp4	9.4 MB
04_02-Creating a custom sort order.mp4	10.1 MB
04_03-Filtering a PivotTable field by selection.mp4	10.3 MB
04_04-Filtering a PivotTable by rule.mp4	12.1 MB
04_05-Filtering a PivotTable using a search filter.mp4	7.2 MB
04_06-Filtering a PivotTable using slicers.mp4	10.2 MB
04_07-Formatting slicers.mp4	14.9 MB
04_08-Filtering with report filter fields.mp4	11.1 MB
04_09-Clearing and reapplying PivotTable filters.mp4	4.9 MB
/05. Formatting PivotTables/
05_01-Applying a PivotTable style.mp4	12.7 MB
05_02-Creating a PivotTable style.mp4	16.2 MB
05_03-Changing the PivotTable layout.mp4	14.4 MB
05_04-Changing the data field number format.mp4	9.4 MB
/06. Applying Conditional Formats to PivotTables/
06_01-Highlighting cells by applying a rule.mp4	16.0 MB
06_02-Highlighting the top or bottom values in a PivotTable.mp4	14.7 MB
06_03-Formatting cells using data bars.mp4	13.9 MB
06_04-Formatting cells using color scales.mp4	15.8 MB
06_05-Formatting cells using icon sets.mp4	16.1 MB
06_06-Editing a conditional formatting rule.mp4	9.3 MB
06_07-Controlling how multiple rules are applied.mp4	8.8 MB
06_08-Deleting a conditional formatting rule.mp4	5.5 MB
/07. Creating and Manipulating PivotCharts/
07_01-Creating a PivotChart.mp4	9.8 MB
07_02-Pivoting a PivotChart.mp4	8.4 MB
07_03-Filtering a PivotChart.mp4	6.3 MB
07_04-Formatting a PivotChart.mp4	10.2 MB
07_05-Changing a PivotCharts layout.mp4	8.2 MB
07_06-Changing a PivotCharts chart type.mp4	4.2 MB
07_07-Adding a trendline to a PivotChart.mp4	9.9 MB
/08. Printing PivotTables/
08_01-Printing a PivotTable.mp4	5.3 MB
08_02-Setting PivotTable print options.mp4	8.3 MB
08_03-Printing each item on its own page.mp4	17.4 MB
08_04-Printing a PivotChart.mp4	6.0 MB
/09. Manipulating PivotTables/
09_01-Recording and reviewing an Excel macro.mp4	12.3 MB
09_02-Running an Excel macro.mp4	16.2 MB
09_03-Creating a simple PivotTable presentation kit.mp4	16.4 MB
09_04-Working with PivotTables using keyboard shortcuts.mp4	8.9 MB
/10. Creating PivotTables Using the Data Model/
10_01-Creating relationships between tables.mp4	12.6 MB
10_02-Creating a PivotTable using the data model.mp4	8.5 MB
10_03-Editing table relationships.mp4	10.0 MB
/11. Conclusion/
11_01-Next steps.mp4	2.6 MB
/Exercice Files/
Ex_Files_Pivot_Tables_In_Depth.zip	1.0 MB
Total files 58