Excel Dashboard Masterclass

Come and learn Excel dashboard tricks from the Masters

Do your Excel reports take a long time to update each month/week?

Do you spend hours collating data, updating formulas and charts, and then feel like no one reads them anyway?

It doesn’t have to be that way. Come learn Excel Dashboard from the Masters.

Training Goal

The goal of creating a DASHBOARD is to consolidate a lot of key information in a visual way, so you can quickly make data analysis for decision making. Each DASHBOARD is only being created from clear objectives that facilitate decision-making from the view of the indicators in a clear and concise manner.

This course aims to teach using Excel to create dashboards using graphs, charts, and other Excel tools. The created dashboards are fully dynamic mode can easily view the information in different ways.

Course Outline

Module I – Introduction to Excel Dashboard

  • Knowing DASHBOARD
  • Basic Principles of Design
  • Defining the objectives of the DASHBOARD and data needed

Module II – Functions and Basic Tools

  • Conditional formatting
  • Figures Dynamics
  • Review Features and
  • New Functions
  • Nested functions
  • Data Validation
  • Sheets of protection

Module Ill – Graphics

  • Introduction to Graphics
  • Charting with Multiple Axes
  • PivotCharts
  • Dynamic texts
  • Using NAODISP function ( )
  • Using Picture in graphics
  • Using together two types of graphics
  • Highlighting the important information in the chart

Module IV – Interactive Interface

  • Using the Developer tab
  • Control buttons: Combo boxes, Check Boxes, and Scroll Bar.

Module V – Creating a DASHBOARD using what has been learned in the course

Subscribe to our newsletter

Sign up to receive latest news, updates, promotions, and special offers delivered directly to your inbox.
No, thanks