Excel Dashboards

This course is designed for executives who possess intermediate or advanced level Excel skills. Business executives need access to accurate data – presented in a clear and understandable way. This training program will teach the participants skills needed to use this data to build powerful reports on any aspect of their business using Excel.

Carefully built dashboard report help you clearly see insights into any aspect of the business. The training program will cover advanced features of Excel Dashboards, such as display and visualization principles for clear dashboard creation, using interactive controls to keep information informative and relevant, analyzing and automating information for a fully functional and complete dashboard.

Contents

Chart and Dashboard Introduction

Dashboard Tools and Techniques

Interactive Dashboards, Functions and Conditional Formatting

Reporting Using Pivot Table

Working with Databases and Using Pivot Charts

Advance Dashboard Tools and Techniques

Dynamic Graphs Using Macros and VBA

Using VBA Advance Examples