excel dashboards & reports

Course Objective

To enable learners create and manage dashboards which are a group of dynamic charts prepared in microsoft excel.

Learning Outcomes

The learner shall be able to own skills of using effective ways of visualization using excel charts and graphics.

Course Description

Download Brochure

All types of charts are discussed in detail along with multiple axis charts and dynamic or creative charts such as speedometer, Waterfall, Candle light etc. We also make you learn the chartless techniques to presenting data visually.


From Spreadsheets to Dashboards
  • Introducing dashboards
  • Developing your data model
  • Dashboard design principles
Excel Chart Basics
  • Introducing excel charts
  • Understanding chart types
  • Working with chart series
  • Formatting and customizing charts
Going Beyond Tables and Charts
  • Using Pivot Tables
  • Using Pivot Charts
  • Using Excel Sparklines
  • Chartless visualization techniques
Creating Advanced Dashboard Components
  • Components that show trending
  • Components that group data
  • Components that show performance v/s target
Automating Your Dashboards
  • Macro Charged Reporting
  • Adding Interactive Controls to your dashboards
Sharing your work with the outside world
  • Secure your dashboards and reports
  • Linking your dashboards to powerpoint
  • Distributing your dashboards via PDF
Creating Advanced Dashboard Components
  • Components that show trending
  • Components that group data
  • Components that show performance v/s target

Want to explore detailed syllabus? Click Here

Course Extract

  Level Beginner
    Methodology Online / Offline
    Duration 5Hours
    Price ₹ 3999 – Offline
₹ 2799 - Online
₹ 1599 - Self Learning
  Pre-requisites None
  Batch size 10-15 students
  Classes On Weekend / Sunday
  Certificate Yes
  Placement Assistance Yes

We're ready to listen...

* Indicates a required field

Complete the form below or call us on 784 008 4266.

What services are
you interested in?