Course Details

  • Course Code: OS-IT-XLDB-3D
  • Mode of Delivery: Onsite
  • Duration: 3 Days
  • Price: On Request

Microsoft Excel Dashboard

Course Overview

This course is intended for anyone who wants to take the data analysis technologies in Excel beyond formulas and add more advanced capabilities such as dashboards, hierarchies, and relationships.

Anyone whose role requires them to use existing Dashboards to consume the contents

  • Microsoft Excel Level 1 & L 2 & L3

Successful candidates will receive a certificate issued by National Training Institute LLC (NTI), attested by the Ministry of Higher Education

Other Details

Visualization Best Practices

  • Overview of Excel Dashboards and what can be done
  • Designing Dashboards – the considerations
  • Tips for Building Excel Dashboards

Excel Charting Principles and Advice

  • Overview of different chart types
  • Editing and formatting your charts

Advanced Charting

  • Creating and customizing Charts
  • Using specialist charts for your Excel
  • Dashboards
  • How to select the Right Charts for your Data

Excel Pivot Tables

  • Creating Pivot tables
  • Changing the Pivot table layout
  • Producing reports
  • Manipulating query headings
  • Grouping and ungrouping data fields

Creating your Excel Dashboards

  • Dashboard Do’s and Don’t’s
  • Data Layout Creating Dynamic Dashboards
  • Using Alerts to draw attention to dashboards

More Dashboarding

  • Creating KPI Dashboards
  • Project Management
  • Dashboards Publishing Excel Dashboards to the Web

Working with your Data

  • Understanding Data Quality issues
  • Gathering data from different sources
  • Linking Data
  • Merging and Consolidating Data

Analyzing Data

  • Using the dashboards with Excel Pivot Tables
  • Using external data sources such as The Web
  • Dashboarding with Microsoft Access information

By the end of the module the candidate will be able to Understand and explain the principles of:

  • The best practices to follow while creating a Dashboard
  • The features and tools you can use in Excel to create an interactiveDashboard
  • Create a quick and effective Excel Dashboard using Pivot Charts
  • Add Check Boxes, Option Buttons, Combo Boxes and Scroll Bars to Excel Dashboard
  • Create summary reference table usingIF, COUNTIF, SUMIF and AVERAGEIF functions
  • Use drop down list with functions such IF, MATCH and OFFSET to control a dynamic chart
Instructor-led training. Classroom Training