Start Time

12:00 am

Tuesday, May 7, 2019

access_time
End Time

12:00 am

Thursday, May 9, 2019

access_time
Address

Birmingham, UK

location_on


Event Description

  • Learn How to Create Interactive Dashboard in Mircrosoft Excel in a Live Instructor Based Online Class
  • Duration – 16 Hrs
  • Training Prerequisite
  1. Good Understanding of Excel
  2. Good Understanding of Data Analysis
  3. Good Understanding of Data Types
  4. People who completed Advance Excel Training

Learning Objectives

Learning Objectives

 

Warm Up

 

  1. Revise of the Excel Basic Functions
  2. Get up to speed on Terminologies
  3. Understanding the Tabs and Ribbons
  4. 30 % Time Saving Tricks

 

Dashboarding Basics

  1. Creating Pivot Tables
    1. Understanding it in Details
    2. Advance Features of Pivot Table
    3. How to Slice and Dice It
  2. Creating Pivot Charts
    1. More than One Chart at a time
    2. Make Charts Interactive

Dashboard Advanced

  1. Filter Values based on Dropdowns
  2. Using Scroller
  3. Dynamic Charts
  4. Duplicate Value Lookups
  5. Dynamic Name Range

 

Charting It Correctly

  1. Intro to Charting
  2. Picking right charts
  3. Anatomy of Charts in Detail
  4. Formatting charts : Customize it
  5. New charts in Excel 2016
  6. Sparklines
  7. Interactive charts : How to make it?

Doing it Practically

 

  1. Steps for creating dashboards
  2. First dashboard #1 : Learn with Trainer
  3. Second dashboard #2 : Mentoring of Trainer
  4. Employee Dashboard : Make this happen
  5. Financial metrics dashboard : Lets Automate It

Detailed Course Content

For any further clarification on the Course Content or a Customized Course for your Specific Training need please reach out at info@instrovate.com