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

This course is for all Excel users who wish to learn how to create powerful interactive dashboards using Pivot Charts and Pivot Tables. This course will teach you to turn your Excel data into powerful tables, graphs and dashboards. In this course you will learn to create three different dashboards. The first dashboard will focus on Sales information creating key metrics, trends, top 10 analysis and a percentage contribution. The second dashboard will focus on Human Resource data and display key metrics, number of employees by age, number of employees by years of service and gender profile. The third dashboard focuses on financial information and allows the user to understand the variance of the Profit from previous months and how much it has changed from month to month. In addition techniques and tools such as sparklines, data bars, trendlines and slicers are also included. This course is very important for all Excel users who are required to develop management reporting or to perform data analysis and wish to gain insight and intelligence from their data. The course is designed to take you through step by step to create the interactive dashboards using simple drag and drop techniques. This course does not include any custom programming or macros. All the dashboards and techniques can be followed by any Excel user who understands the basic principles of Excel. An introductory knowledge of Pivot Tables and Pivot Charts will assist you in the course. However you can follow the step by step instructions if you do not have an in-depth knowledge of Pivot Tables and Pivot Charts. Please note that you will require Excel 2010 or 2013 for this course. The course is presented using Excel 2013.

1. Introduction
   • Introduction to Interactive Dashboards 00:02:33
2. Interactive Sales Dashboard
   • Creating the Sales Dashboard 00:03:19
   • Creating the Key Metrics 00:03:59
   • Year and Qtr Trend 00:05:07
   • Top 10 Customers by Profit 00:03:29
   • Percentage Profit by Region 00:03:59
   • Adding Interactive Slicers 00:05:03
   • Interactive Timeline Slicers 00:02:07
3. Human Resource Interactive Dashboard
   • Overview of the Human Resource Dashboard 00:01:58
   • Key Metrics 00:06:56
   • Employees by Dept Column Chart 00:04:25
   • Age Analysis by Gender 00:04:01
   • Percentage by Gender 00:04:39
   • Analysis by Length of Service 00:04:13
   • Adding Slicers 00:06:52
4. Finance Dashboard
   • Overview of the Dashboard 00:02:58
   • Creating the Difference From Prev Month Calculation 00:04:52
   • Adding Data Bars 00:10:49
   • Adding Sparklines 00:04:21
   • Adding Slicers 00:02:53