by Ian Littlejohn | Publisher: Stone River eLearning | Release Date: January 2018 | ISBN: 200000006A0426

Create amazing reports and analyze data in minutes with Excel Pivot Tables. This course focuses on creating and understanding how to use Excel Pivot Tables to quickly analyze and understand your business data. Pivot Tables make it easy to compile management reports and generate new insight and intelligence from your data in minutes. This Excel Business Intelligence training course is for all business users who are required to develop management reports, analyze data or ask ad-hoc questions of their data. McKinsey Consulting in a recent report entitled 'Big data: The next frontier for innovation, competition, and productivity' emphasizes that data skills will become the basis for competition, innovation, growth and productivity. The report also highlights the need for around 1.5 million managers in United States with data skills. This course has over 25 video lectures that take you step by step through creating management reports and analyzing data with a couple of clicks of the mouse. The course is structured into 9 sections which takes you from creating simple management reports to sophisticated data analysis. Learn techniques to easily aggregate your data, produce reports, understand trends, filter your data, create interactive reports and use sophisticated calculations. So begin your journey today with Excel Business Intelligence.

1. Introduction
   • Introduction to Pivot Tables 00:03:11
   • Correctly Structure Data 00:08:18
   • Using Tables as a Data Source 00:03:25
2. Creating Excel Pivot Tables
   • Create a Pivot Table 00:06:15
   • Create PivotTable with More Than One Dimension 00:04:17
   • More than One Measure 00:05:23
   • Change Number Formats 00:07:35
   • Change Region and Language 00:03:07
3. Pivot Table Menu Options
   • Pivot Table Menu Options 00:10:19
   • Pivot Table Design 00:04:55
4. Changing the Method of Aggregation
   • Method of Aggregation 00:08:17
   • Sorting Data in a Pivot Table 00:04:48
5. Trend - Time Analysis with Pivot Tables
   • Time Analysis with Pivot Tables 00:09:11
   • Create Management Reports 00:03:36
   • Custom Time Formulas 00:08:09
   • Using Sparklines to Analyse trends 00:03:54
6. Filtering Pivot Tables
   • Filter Text Fields 00:09:21
   • Top 10 Analysis 00:04:11
   • Using the Report Filter 00:03:26
   • Using Slicers to Filter Data 00:05:19
   • Using Slicers to Filter Multiple Pivot Tables 00:04:45
7. Show Value As Calculations
   • Percentage Calculation 00:05:32
   • Show Value As Percentage of Parent Row Total 00:02:24
   • Difference From and Ranking 00:06:33
   • Pareto Analysis 00:07:29
   • Percentatge of Calculation 00:02:21
8. Frequency Analysis
   • Frequency Analysis 00:06:05
9. Custom Calculations
   • Create a Custom Calculation 00:03:34