Course Outline
- Introduction to Dashboards
- Pre-requisites of Dashboards
- Data cleaning and preprocessing for making meaningful dashboards
- Formula based Conditional formatting
- Key logics to design Excel Charts
- Pareto Analysis, Histograms, Frequency distribution, Time series Analysis in Dashboards
- Logical functions in data visualization
- Advanced Picture properties
- Design principles of Dashboards
- Data Analyze using Pivot tables
- Design dashboards in Pivot tables
- Apply slicers and timelines for dynamic dashboards
- Apply custom number formatting for variations in data
- Inserting Statistical analysis in Dashboards
- Dashboards designing for different professionals