by Kathy Jones | Publisher: Total Training | Release Date: January 2017 | ISBN: 10000BBXLPIVT

Get Actionable Insight From Your Data With Excel's Popular Power Tool! Pivot Tables are the perfect tool to analyze large amounts of data in Excel, and in this Excel - Data Analysis with Pivot Tables course, Microsoft trainer Kathy Jones will show you how to effectively use the PivotTable tools in Excel 2013 and 2016. Are you ready to learn how to get more from Excel with the power of PivotTables? Being able to summarize, visualize, and tabulate your data makes PivotTables an important skill for anyone who uses Excel to store and report on data. Excel - Data Analysis with Pivot Tables will help intermediate and advanced users work more effectively with Excel PivotTables and PivotCharts in both the 2013 and 2016 versions of Excel.

1. 1. Excel - Data Analysis with Pivot Tables
   • Preparing Data 00:10:38
   • Create From Local Data Source 00:10:33
   • Create From Multiple Local Sources 00:12:27
   • Create From External Sources 00:07:13
   • Summarize Table Data 00:09:55
   • Organize Pivot Table Data 00:12:19
   • Filter Data Part 1 00:09:54
   • Filter Data Part 2 00:12:47
   • Format Pivot Table 00:14:19
   • Refresh And Change Data 00:10:53
   • Pivot Options Part 1 00:09:54
   • Pivot Options Part 2 00:07:59
   • Creating A Pivot Chart Data 00:02:57
   • Manipulate Pivot Chart Data 00:08:07
   • Formatting A Pivot Chart 00:07:37