| Lynda - Excel 2016 - Pivot Tables in Depth/01. Introduction/01_01-Welcome.mp4 |
6.8 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/01. Introduction/01_02-Using the exercise files.mp4 |
996 KB |
| Lynda - Excel 2016 - Pivot Tables in Depth/02. Creating and Pivoting PivotTables/02_01-Introducing PivotTables.mp4 |
10 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/02. Creating and Pivoting PivotTables/02_02-Formatting data for use in a PivotTable.mp4 |
13.3 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/02. Creating and Pivoting PivotTables/02_03-Creating a PivotTable.mp4 |
9.9 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/02. Creating and Pivoting PivotTables/02_04-Creating a recommended PivotTable.mp4 |
6.4 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/02. Creating and Pivoting PivotTables/02_05-Pivoting a PivotTable.mp4 |
9.4 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/02. Creating and Pivoting PivotTables/02_06-Configuring a PivotTable.mp4 |
11.4 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/02. Creating and Pivoting PivotTables/02_07-Connecting to an external data source.mp4 |
5.7 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/02. Creating and Pivoting PivotTables/02_08-Consolidating data from multiple sources.mp4 |
11 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/02. Creating and Pivoting PivotTables/02_09-Managing PivotTables.mp4 |
13.8 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/03. Summarizing PivotTable Data/03_01-Managing subtotals and grand totals.mp4 |
11.4 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/03. Summarizing PivotTable Data/03_02-Changing the data field summary operation.mp4 |
11.6 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/03. Summarizing PivotTable Data/03_03-Summarizing more than one data field.mp4 |
10.4 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/03. Summarizing PivotTable Data/03_04-Creating a calculated field.mp4 |
10.7 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/03. Summarizing PivotTable Data/03_05-Using PivotTable data in a formula.mp4 |
9.9 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/03. Summarizing PivotTable Data/03_06-Drilling down to the underlying data.mp4 |
9.7 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/04. Sorting and Filtering PivotTable Data/04_01-Sorting PivotTable data.mp4 |
9 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/04. Sorting and Filtering PivotTable Data/04_02-Creating a custom sort order.mp4 |
9.7 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/04. Sorting and Filtering PivotTable Data/04_03-Filtering a PivotTable field by selection.mp4 |
9.8 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/04. Sorting and Filtering PivotTable Data/04_04-Filtering a PivotTable by rule.mp4 |
11.6 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/04. Sorting and Filtering PivotTable Data/04_05-Filtering a PivotTable using a search filter.mp4 |
6.9 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/04. Sorting and Filtering PivotTable Data/04_06-Filtering a PivotTable using slicers.mp4 |
9.8 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/04. Sorting and Filtering PivotTable Data/04_07-Formatting slicers.mp4 |
14.2 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/04. Sorting and Filtering PivotTable Data/04_08-Filtering with report filter fields.mp4 |
10.6 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/04. Sorting and Filtering PivotTable Data/04_09-Clearing and reapplying PivotTable filters.mp4 |
4.7 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/05. Formatting PivotTables/05_01-Applying a PivotTable style.mp4 |
12.1 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/05. Formatting PivotTables/05_02-Creating a PivotTable style.mp4 |
15.4 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/05. Formatting PivotTables/05_03-Changing the PivotTable layout.mp4 |
13.7 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/05. Formatting PivotTables/05_04-Changing the data field number format.mp4 |
9 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/06. Applying Conditional Formats to PivotTables/06_01-Highlighting cells by applying a rule.mp4 |
15.2 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/06. Applying Conditional Formats to PivotTables/06_02-Highlighting the top or bottom values in a PivotTable.mp4 |
14 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/06. Applying Conditional Formats to PivotTables/06_03-Formatting cells using data bars.mp4 |
13.3 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/06. Applying Conditional Formats to PivotTables/06_04-Formatting cells using color scales.mp4 |
15.1 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/06. Applying Conditional Formats to PivotTables/06_05-Formatting cells using icon sets.mp4 |
15.3 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/06. Applying Conditional Formats to PivotTables/06_06-Editing a conditional formatting rule.mp4 |
8.8 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/06. Applying Conditional Formats to PivotTables/06_07-Controlling how multiple rules are applied.mp4 |
8.4 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/06. Applying Conditional Formats to PivotTables/06_08-Deleting a conditional formatting rule.mp4 |
5.3 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/07. Creating and Manipulating PivotCharts/07_01-Creating a PivotChart.mp4 |
9.4 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/07. Creating and Manipulating PivotCharts/07_02-Pivoting a PivotChart.mp4 |
8 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/07. Creating and Manipulating PivotCharts/07_03-Filtering a PivotChart.mp4 |
6 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/07. Creating and Manipulating PivotCharts/07_04-Formatting a PivotChart.mp4 |
9.7 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/07. Creating and Manipulating PivotCharts/07_05-Changing a PivotCharts layout.mp4 |
7.8 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/07. Creating and Manipulating PivotCharts/07_06-Changing a PivotCharts chart type.mp4 |
4 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/07. Creating and Manipulating PivotCharts/07_07-Adding a trendline to a PivotChart.mp4 |
9.4 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/08. Printing PivotTables/08_01-Printing a PivotTable.mp4 |
5 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/08. Printing PivotTables/08_02-Setting PivotTable print options.mp4 |
7.9 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/08. Printing PivotTables/08_03-Printing each item on its own page.mp4 |
16.6 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/08. Printing PivotTables/08_04-Printing a PivotChart.mp4 |
5.8 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/09. Manipulating PivotTables/09_01-Recording and reviewing an Excel macro.mp4 |
11.8 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/09. Manipulating PivotTables/09_02-Running an Excel macro.mp4 |
15.5 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/09. Manipulating PivotTables/09_03-Creating a simple PivotTable presentation kit.mp4 |
15.6 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/09. Manipulating PivotTables/09_04-Working with PivotTables using keyboard shortcuts.mp4 |
8.5 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/10. Creating PivotTables Using the Data Model/10_01-Creating relationships between tables.mp4 |
12 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/10. Creating PivotTables Using the Data Model/10_02-Creating a PivotTable using the data model.mp4 |
8.1 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/10. Creating PivotTables Using the Data Model/10_03-Editing table relationships.mp4 |
9.5 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/11. Conclusion/11_01-Next steps.mp4 |
2.4 MB |
| Lynda - Excel 2016 - Pivot Tables in Depth/Exercice Files/Ex_Files_Pivot_Tables_In_Depth.zip |
989 KB |
Magnet link
