Pivot Tables for Excel 2016
Pluralsight
Course Summary
This course is aimed at intermediate-level users of Excel 2010 and 2013 as well as 2016 for Windows and Mac who are unfamiliar with Pivot Tables and who need to summarize and analyze list-based data and make better business decisions based on that data.
-
+
Course Description
Pivot Tables are one of the most powerful tools in Excel's data analysis armory. With just a few clicks of the mouse (and no complicated formulas!) you can quickly and easily summarize and analyze large amounts of raw data and get answers to those important questions on which you base your key business decisions.
-
+
Course Syllabus
Course Overview- 1m 35s
—Course Overview 1m 35sIntroduction to Pivot Tables- 33m 21s
—Introduction 0m 34s
—What Is a Pivot Table? 8m 23s
—Creating a Basic Pivot Table 8m 45s
—Using an Excel Table as a Data Source 6m 6s
—Using an SQL Server Database as a Data Source 4m 18s
—Creating a Pivot Table from Multiple Tables 4m 48s
—Summary 0m 24sCustomizations and Calculations- 30m 0sSorting, Grouping, and Filtering- 36m 1sPivot Charts and Data Visualizations- 17m 4sCreating a Basic Pivot Table Driven Dashboard- 25m 30s