01. Introduction
01_01-Welcome.mp4
6.85 MB 01_02-Using the exercise files.mp4
996.47 KB 02. Creating and Pivoting PivotTables
02_01-Introducing PivotTables.mp4
10.01 MB 02_02-Formatting data for use in a PivotTable.mp4
13.31 MB 02_03-Creating a PivotTable.mp4
9.87 MB 02_04-Creating a recommended PivotTable.mp4
6.37 MB 02_05-Pivoting a PivotTable.mp4
9.41 MB 02_06-Configuring a PivotTable.mp4
11.42 MB 02_07-Connecting to an external data source.mp4
5.66 MB 02_08-Consolidating data from multiple sources.mp4
11.01 MB 02_09-Managing PivotTables.mp4
13.84 MB 03. Summarizing PivotTable Data
03_01-Managing subtotals and grand totals.mp4
11.36 MB 03_02-Changing the data field summary operation.mp4
11.63 MB 03_03-Summarizing more than one data field.mp4
10.36 MB 03_04-Creating a calculated field.mp4
10.71 MB 03_05-Using PivotTable data in a formula.mp4
9.86 MB 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_02-Creating a custom sort order.mp4
9.65 MB 04_03-Filtering a PivotTable field by selection.mp4
9.82 MB 04_04-Filtering a PivotTable by rule.mp4
11.57 MB 04_05-Filtering a PivotTable using a search filter.mp4
6.89 MB 04_06-Filtering a PivotTable using slicers.mp4
9.77 MB 04_07-Formatting slicers.mp4
14.19 MB 04_08-Filtering with report filter fields.mp4
10.57 MB 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_02-Creating a PivotTable style.mp4
15.40 MB 05_03-Changing the PivotTable layout.mp4
13.71 MB 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_02-Highlighting the top or bottom values in a PivotTable.mp4
14.04 MB 06_03-Formatting cells using data bars.mp4
13.28 MB 06_04-Formatting cells using color scales.mp4
15.06 MB 06_05-Formatting cells using icon sets.mp4
15.35 MB 06_06-Editing a conditional formatting rule.mp4
8.83 MB 06_07-Controlling how multiple rules are applied.mp4
8.39 MB 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_02-Pivoting a PivotChart.mp4
7.96 MB 07_03-Filtering a PivotChart.mp4
5.99 MB 07_04-Formatting a PivotChart.mp4
9.72 MB 07_05-Changing a PivotCharts layout.mp4
7.82 MB 07_06-Changing a PivotCharts chart type.mp4
4.00 MB 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_02-Setting PivotTable print options.mp4
7.93 MB 08_03-Printing each item on its own page.mp4
16.57 MB 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_02-Running an Excel macro.mp4
15.46 MB 09_03-Creating a simple PivotTable presentation kit.mp4
15.62 MB 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_02-Creating a PivotTable using the data model.mp4
8.13 MB 10_03-Editing table relationships.mp4
9.50 MB 11. Conclusion
11_01-Next steps.mp4
2.44 MB Exercice Files
Ex_Files_Pivot_Tables_In_Depth.zip
988.76 KB
Feel free to post any comments about this torrent, including links to Subtitle, samples, screenshots, or any other relevant information, Watch Lynda - Excel 2016 - Pivot Tables in Depth Online Free Full Movies Like 123Movies, Putlockers, Fmovies, Netflix or Download Direct via Magnet Link in Torrent Details.