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