Interactive Dashboards In Excel

About This Course

This intensive hands-on course covers a number of key areas relating to the visualization of data to produce high level management reports. Dashboards often have user interactivity (you choose what data to view) to convey the most important information at a glance.

Learning Objectives

By the end of the course, learner will be able to

  • manipulate tables of data & use relevant functions
  • structure data efficiently in order to create dashboard
  • use advanced charting techniques to visualize data
  • create interactive dashboard

Prerequisites

Learners must have advance knowledge & skill in Microsoft Excel.

 

Target Audience

Learners who need to interpret and communicate large quantities of information clearly by summarizing it into easy-to-read tables and charts.

 

Training Outline

  1. Introduction to Dashboards
  2. Essentials Techniques for Creating Interactive Dashboards
  3. Building a Dashboard (at least build one complete Dashboard in practical training)