Skip to main content

Section outline

    • Dashboard Design Principles
      • Purpose, benefits, and best practices for dashboard design.
    • Creating a Pivot Table
      • Preparing data and creating pivot tables with slicers.
    • Grouping, Sorting, and Filtering Pivot Data
      • Using filters and grouping for refined analysis.
    • Performing Calculations in Pivot Tables
      • Creating calculated fields and items for advanced calculations.
    • Data Visualization – Picking the Right Display
      • Effective use of charts, secondary axes, and icons.
    • Using Sparklines & Conditional Formatting
      • Creating sparklines and applying advanced formatting techniques.
    • Advanced Charting Techniques
      • Step charts, waterfall charts, and frequency distribution.
    • Named Ranges and Excel Tables
      • Using named ranges and structured references for dynamic data.
    • Building Interactive Charts and Dashboards Controls
      • Dynamic named ranges and form controls (buttons, combo boxes, etc.).