Microsoft Excel - Dashboards for Business Intelligence Certification Course

Download Course Contents

Microsoft Excel - Dashboards for Business Intelligence Course Overview

Enroll for our 1-day Microsoft Excel - Dashboards for Business Intelligence from Koenig Solutions. In this course you will learn data visualization skills need to design any dashboard in Excel and also create beautiful, functional and interactive Excel dashboards.

The course is designed for Excel 2016, 2019 and Microsoft 365 (Office 365), so you can choose the version that works best for you.

Target Audience:

The training is Intended for Business Intelligence, data managers, data analysts, or Project Managers and anyone who wants to extend their knowledge of Excel to understand some of the more advanced features and how they can be used to work together.

Learning Objectives:

After completing this course, you will be able to:

  • Understand the goals of data visualization.
  • Learn to use conditional formatting, from data bars to icon sets to add finesse to your dashboard.
  • Review the Excel logic functions which are key to adding dynamics to your dashboard.
  • Explore the rules of effective charting.
  • Build more complex charts like scatter plots, combination charts and more
  • Add interactivity to your dashboard with the MATCH () and INDEX () functions.
  • Leverage pivot tables within your dashboard to add even more interactivity.

 

  • 1. Do you have limited Window for training?
  • 2. Can you only spend 4-hours per day?
  • 3. Do you want to start training immediately?
  • If your answer is yes to any one of the above, you need 1-on-1- Training
The 1-on-1 Advantage
Methodology
Flexible Dates
4-Hour Sessions
  • View video
  • The course will be free if we are not able to start within 7 days of booking.
  • Only applicable for courses on which this logo appears.

Your will learn:

Module 1: Introduction to Dashboards
  • What is a Dashboard?
  • Common features of a dashboard
  • Creating PivotTables
  • Formatting a PivotTable
  • Refreshing a PivotTable
  • Grouping fields
  • PivotCharts
  • Slicers and Timelines
  • Nested IFs
  • COUNTIFS & SUMIFS
  • EDATE
  • INDEX & MATCH
  • OFFSET
  • CHOOSE
  • Formatting values
  • Colour Scales to show heatmaps
  • Icon Sets to show at a glance performance
  • Understanding the different controls
  • Using them on a dashboard
  • Creating charts
  • Formatting charts
  • Secondary Axes
  • Combination charts
  • Creating chart templates
  • Creating & modifying Sparklines
  • Customizing Sparklines
  • Gridlines & outlines
  • Lining up Excel objects
  • Theming a dashboard
Live Online Training (Duration : 8 Hours)
Group Training 550 Per Participant
06 Jun 09:00 AM - 05:00 PM CST
(8 Hours/Day)
04 Jul 09:00 AM - 05:00 PM CST
(8 Hours/Day)
1-on-1 Training 1100 650 + If you accept merging of other students.
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Classroom Training is available. Enquire for the fee Click
Comfort Track

If you think 8 hours is too fast, we can offer Comfort Track for 16 hours for only USD 1,300

Course Prerequisites
  •  A very good knowledge of Excel

 

Request More Information

Add Name and Email Address of participant (If different from you)

FAQ's


Yes, fee excludes local taxes.
The Fee includes:
  • Courseware
Yes, Koenig Solutions is a Microsoft Learning Partner