Excel Dashboards

Program Details

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.

Duration:

3 days

For Whom:

Management and finance professionals, accountants and analysts.

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

Related Programs