Excel Dashboarding PLUS

Dashboarding Course is aimed to empower analysts with better reporting skills.This not only reduces the work of the managers but also makes the reporting easy and robust. This improves visibility about the employee in the organization.

The dashboarding course helps you leverage you Excel skills to gain better visibility across the organization with the help of :

1. Better Automation Skills that improve productivity
2. Better visual representation of results
3. Smarter and more effective MIS and reporting

To understand how Excel can be made fun and useful, download one of the dashboards created by our students below:

Sample Dashboard*

*Please right click on the link and click on Save Link AS

Course Duration: 16 Hrs

Excel Dashboarding Plus Course Contents

• Macros
• Overview
• Record/Edit Macros
• Write your own macro
• Form Controls
• Overview
• Advanced Data Preparation - Loops, Array's
• Create a simple dashboard with dynamic charts
• Create a simple dashboard with scroll bars, sort et al
• VBA Programming
• Write a simple VBA Program
• Syntax of VBA
• Declaration of VBA Program
• ActiveX Controls
• Usage of Chart Objects

• VBA Programming
• Recap - PowerPoint to Excel Connectivity
• Outlook connectivity
• Exam (Open Book)