Microsoft Excel - Dashboards for Business Intelligence

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.