Interactive Dashboard with Microsoft Excel, Power Pivot and VBA

We understand that most of business people so familiar with Microsoft Excel. But, we believe that, so many hidden functions in Excel you do not utilize yet. In this workshop, we focus on optimizing your Excel capability to handle the specific tasks in data analytics & visualization.

Courses Structure

• Determining objective of analytics
• Database management system/DBMS
• Knowing your data
• Design of dashboard system
• Analytical & visual features in Microsoft Excel
• Deploying dashboard system to users
  • Automating dashboard
  • Packaging dashboard
  • User management
• Applying interactive dashboard on the set of data & information
  • Accounting dashboard
  • Sales & marketing dashboard
  • Executive dashboard

Who should attend

Relevant persons to data analytics and visualization

Course Leader :

Muhamad Al Gamal, SE, MA, Ak

More...