Section outline

• Select section Day 1: Advanced Pivot Table Techniques

  Day 1: Advanced Pivot Table Techniques

  Collapse all Expand all

  • 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.
• Select section Day 2: Data Visualization and Dashboard Design

  Day 2: Data Visualization and Dashboard Design

  • 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.).