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
