• Advanced Data Transformation
  
• Advanced Pivot Table Management
  
• Introduction to Excel Form Control
  
• Building Advanced Chart
  
• Building Interactive Report & Dashboard
  
• Final Touches

Excel Dashboard is a page that allows managers and business leaders to track key KPIs or indicators and to decide appropriately. It includes diagrams/ tables / views supported by facts. Nevertheless, not all reports are dashboards. Dashboard reports provide administrators with a high-level company summary. Excel is an excellent tool for producing powerful dashboards which allow managers to evaluate, inspect and alert on time.

In this advanced level, the focus are the dynamic reports/charts and interaction with the data. The Dashboard that we build will be adaptable to changes and user friendly. While ensuring the accuracy of the reports and information displayed in the Dashboard, the aesthetic of the Dashboard is very important too.

1. Having the ability to use Power Query to massage and transform data to tabular format.
   
2. Making Dashboard complete by applying the analytic tools in Excel/PivotTable.
   
3. Making the chart dynamic and change according to report requirements.
   
4. Generating an interactive Dashboard by using Macro and Slicer.

• Guided Learning, group-paced, hands- on classroom training with real life examples for business applications.
  
• Challenging exercises are set based on practical applications for typical organizational functions such as HR, Admin, Production, Sales etc.