Dashboard Reporting Using Advanced Excel 2013

Dashboards are made up of tables, charts, gauges, and numbers. They are dynamic and interactive. They helps managers and business leaders in tracking key KPIs or metrics and take a decision based on it. They can be used in any industry, for almost any purpose. For example, you could make a financial dashboard, marketing dashboard, HR dashboard, production / Operations dashboard, project dashboard, and more. Dashboard provides at-a-glance views into key measures relevant to a particular objective or business process. Dashboards have three main attributes:

  • Dashboards are typically graphical in nature, providing visualizations that help focus attention on key trends, comparisons, and exceptions.
  • Dashboards often display only data that are relevant to the goal of the dashboard.
  • Because dashboards are designed with a specific purpose or goal, they inherently contain predefined conclusions that relieve the end user from performing his own analysis.

Dashboard Introduction
  • What are Dashboards
  • Component of Dashboards and Best Practices
  • Interactive Controls
  • Data Validation, Form Controls
  • Button Controls, Check Box Control
  • Option Button, Combo Box, List Box, Spin Button, Scroll Bar
  • Spin Button and Scroll Bar and Percentage
  • Scrolling Table
Using Pivot Tables and Pivot Charts for Dashboard
  • Create a Pivot Table, Pivot Table Tool Bar
  • Sort Group and Ungroup Data
  • Consolidating Data Advanced
  • Using Calculated Item and Calculated Field
  • Pivot Charts and Working with Slicer
  • Using Conditional formatting
Interactive Dashboard Functions and Using Conditional Formatting, Power Map
  • Interactive Dashboard Examples
  • Key Function of Dashboard and Reporting
  • Using Dynamic Range Name as Chart Source Data
  • Advanced conditional Formatting
  • Listing Top and Bottom values
  • Emphasizing Top Values
  • Power Map
Using Power View to Design Dashboards
  • Introduction to Power View
  • Creating a Power View Report
  • Graphs and Visualizations
  • Data Relationships
  • Interactive Dashboards Examples
Using Infographics for Dashboards
  • What are infographics
  • Examples of infographics
  • Designing info graphics
  • Dashboard example using infographic
Introduction to Macro Recorder and VBA
  • Introduction to VBA
  • Recording and Navigating Macros
  • Designing Custom Functions
  • Excel Add-Ins, Designing and using Add-In
  • Tools and Tricks
Dashboards- Advanced Charts
  • Advance Charting and Dashboards
  • Gantt Chart, Water Fall Graph, Speedo Meter
  • Comparison and Projection Graphs
  • Dashboard Using VBA
  • 10 Examples of Advance Charts
Publishing Your Dashboard
  • Checking and Publishing
  • Excel Web App Introduction
  • Preparing your file for Excel Web App
  • Publishing with Excel Web App
  • Password Protection

About Us

We are a training company that has expertise in providing trainings services:

   Online

   In-house

   One to One

We strongly believe in excellence.

Get in touch



Ali Asjad Trainings
86-C PCSIR Staff Cooperative Housing Society,
College Road, Lahore