Excel Dashboard Reporting

Date: 29 – 30 April 2024
Virtual Instructor-Led Training (VILT).

Key Benefits of Attending
  • SET UP a robust model to cater for automatic updates
  • IMPORT and TRANSFORM data using Power Query
  • CREATE interactive pivot tables, pivot charts, slicers and timeline without formulas
  • DESIGN a visually attractive customized dashboard
  • ADD features such as conditional format and interactive form controls
  • USE dynamic array formulas to automatically update your visuals/charts
  • APPLY powerful functions that summarize and lookup data across variable date horizons
  • CREATE advanced charts such as Sparklines, maps, waterfall chart, histogram and combined chart
  • BUILD a fully interactive Dashboard