Microsoft Excel - Dashboards for Business Intelligence

Microsoft Excel - Dashboards for Business Intelligence Certification Training 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.

 

Microsoft Excel - Dashboards for Business Intelligence (8 Hours) Download Course Contents

Live Virtual Classroom 650
Group Training
01 Nov GTR 09:00 AM - 05:00 PM CST
(8 Hours/Day)

06 Dec GTR 09:00 AM - 05:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR)
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here
Hire Our Trainers! Click here

Request More Information

Course Prerequisites
  •  A very good knowledge of Excel