Create Dashboard in Microsoft Excel

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

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