Resource Detail

Go Back Return to Home
Lynda - Excel 2016 - Pivot Tables in Depth
Size 568.05 MB
Files 58
Info Hash: 5801CFE214EE8C5BE1E76A977CF8CB63D3A8643A
Indexed 2025-12-20 16:25:47
Updated 2025-12-30 01:09:35
📂 File List (58)
🎬
01. Introduction/01_01-Welcome.mp4
6.85 MB
🎬
01. Introduction/01_02-Using the exercise files.mp4
996.47 KB
🎬
02. Creating and Pivoting PivotTables/02_01-Introducing PivotTables.mp4
10.01 MB
🎬
02. Creating and Pivoting PivotTables/02_02-Formatting data for use in a PivotTable.mp4
13.31 MB
🎬
02. Creating and Pivoting PivotTables/02_03-Creating a PivotTable.mp4
9.87 MB
🎬
02. Creating and Pivoting PivotTables/02_04-Creating a recommended PivotTable.mp4
6.37 MB
🎬
02. Creating and Pivoting PivotTables/02_05-Pivoting a PivotTable.mp4
9.41 MB
🎬
02. Creating and Pivoting PivotTables/02_06-Configuring a PivotTable.mp4
11.42 MB
🎬
02. Creating and Pivoting PivotTables/02_07-Connecting to an external data source.mp4
5.66 MB
🎬
02. Creating and Pivoting PivotTables/02_08-Consolidating data from multiple sources.mp4
11.01 MB
🎬
02. Creating and Pivoting PivotTables/02_09-Managing PivotTables.mp4
13.84 MB
🎬
03. Summarizing PivotTable Data/03_01-Managing subtotals and grand totals.mp4
11.36 MB
🎬
03. Summarizing PivotTable Data/03_02-Changing the data field summary operation.mp4
11.63 MB
🎬
03. Summarizing PivotTable Data/03_03-Summarizing more than one data field.mp4
10.36 MB
🎬
03. Summarizing PivotTable Data/03_04-Creating a calculated field.mp4
10.71 MB
🎬
03. Summarizing PivotTable Data/03_05-Using PivotTable data in a formula.mp4
9.86 MB
🎬
03. Summarizing PivotTable Data/03_06-Drilling down to the underlying data.mp4
9.69 MB
🎬
04. Sorting and Filtering PivotTable Data/04_01-Sorting PivotTable data.mp4
8.96 MB
🎬
04. Sorting and Filtering PivotTable Data/04_02-Creating a custom sort order.mp4
9.65 MB
🎬
04. Sorting and Filtering PivotTable Data/04_03-Filtering a PivotTable field by selection.mp4
9.82 MB
🎬
04. Sorting and Filtering PivotTable Data/04_04-Filtering a PivotTable by rule.mp4
11.57 MB
🎬
04. Sorting and Filtering PivotTable Data/04_05-Filtering a PivotTable using a search filter.mp4
6.89 MB
🎬
04. Sorting and Filtering PivotTable Data/04_06-Filtering a PivotTable using slicers.mp4
9.77 MB
🎬
04. Sorting and Filtering PivotTable Data/04_07-Formatting slicers.mp4
14.19 MB
🎬
04. Sorting and Filtering PivotTable Data/04_08-Filtering with report filter fields.mp4
10.57 MB
🎬
04. Sorting and Filtering PivotTable Data/04_09-Clearing and reapplying PivotTable filters.mp4
4.68 MB
🎬
05. Formatting PivotTables/05_01-Applying a PivotTable style.mp4
12.13 MB
🎬
05. Formatting PivotTables/05_02-Creating a PivotTable style.mp4
15.4 MB
🎬
05. Formatting PivotTables/05_03-Changing the PivotTable layout.mp4
13.71 MB
🎬
05. Formatting PivotTables/05_04-Changing the data field number format.mp4
8.98 MB
🎬
06. Applying Conditional Formats to PivotTables/06_01-Highlighting cells by applying a rule.mp4
15.22 MB
🎬
06. Applying Conditional Formats to PivotTables/06_02-Highlighting the top or bottom values in a PivotTable.mp4
14.04 MB
🎬
06. Applying Conditional Formats to PivotTables/06_03-Formatting cells using data bars.mp4
13.28 MB
🎬
06. Applying Conditional Formats to PivotTables/06_04-Formatting cells using color scales.mp4
15.06 MB
🎬
06. Applying Conditional Formats to PivotTables/06_05-Formatting cells using icon sets.mp4
15.35 MB
🎬
06. Applying Conditional Formats to PivotTables/06_06-Editing a conditional formatting rule.mp4
8.83 MB
🎬
06. Applying Conditional Formats to PivotTables/06_07-Controlling how multiple rules are applied.mp4
8.39 MB
🎬
06. Applying Conditional Formats to PivotTables/06_08-Deleting a conditional formatting rule.mp4
5.27 MB
🎬
07. Creating and Manipulating PivotCharts/07_01-Creating a PivotChart.mp4
9.37 MB
🎬
07. Creating and Manipulating PivotCharts/07_02-Pivoting a PivotChart.mp4
7.96 MB
🎬
07. Creating and Manipulating PivotCharts/07_03-Filtering a PivotChart.mp4
5.99 MB
🎬
07. Creating and Manipulating PivotCharts/07_04-Formatting a PivotChart.mp4
9.72 MB
🎬
07. Creating and Manipulating PivotCharts/07_05-Changing a PivotCharts layout.mp4
7.82 MB
🎬
07. Creating and Manipulating PivotCharts/07_06-Changing a PivotCharts chart type.mp4
4 MB
🎬
07. Creating and Manipulating PivotCharts/07_07-Adding a trendline to a PivotChart.mp4
9.41 MB
🎬
08. Printing PivotTables/08_01-Printing a PivotTable.mp4
5.04 MB
🎬
08. Printing PivotTables/08_02-Setting PivotTable print options.mp4
7.93 MB
🎬
08. Printing PivotTables/08_03-Printing each item on its own page.mp4
16.57 MB
🎬
08. Printing PivotTables/08_04-Printing a PivotChart.mp4
5.77 MB
🎬
09. Manipulating PivotTables/09_01-Recording and reviewing an Excel macro.mp4
11.75 MB
🎬
09. Manipulating PivotTables/09_02-Running an Excel macro.mp4
15.46 MB
🎬
09. Manipulating PivotTables/09_03-Creating a simple PivotTable presentation kit.mp4
15.62 MB
🎬
09. Manipulating PivotTables/09_04-Working with PivotTables using keyboard shortcuts.mp4
8.45 MB
🎬
10. Creating PivotTables Using the Data Model/10_01-Creating relationships between tables.mp4
12.04 MB
🎬
10. Creating PivotTables Using the Data Model/10_02-Creating a PivotTable using the data model.mp4
8.13 MB
🎬
10. Creating PivotTables Using the Data Model/10_03-Editing table relationships.mp4
9.5 MB
🎬
11. Conclusion/11_01-Next steps.mp4
2.44 MB
📦
Exercice Files/Ex_Files_Pivot_Tables_In_Depth.zip
988.76 KB
⬇️ Offline Download
🔗 Related Resources

Disclaimer

This website only provides DHT network resource indexing services and does not store any resource files. All resources come from the DHT network, and this site cannot control their content. Please comply with local laws and regulations and use network resources rationally. If there are copyright issues, please contact [email protected].

© 2026 DHT Search