July 2022 Intake On-going. Learn more

Interactive Dashboards In Excel

Course Prerequisites

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

Requirements

  • Basic understanding of data management concepts and constructs such as relational database tables
  • Know how different pieces of data logically relate to one another.

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)