Microsoft Excel Dashboard and Reports (Half Day)

  • Introduce Excel Dashboard and Report
    • What are Dashboards and Reports?
    • Dashboard Design Principles at a Glance
  • Tabular Report Techniques
    • Table Design Best Practices
    • Enhance Report with Custom Number and Conditional Formatting
    • Use Symbols to Enhance Report
    • Build Dashboard with Camera Tool
    • Introduce Sparkline
    • Customize Sparkline
  • Chart on the Dashboard
    • Chart for Trending Techniques
    • Top and Bottom Ranking and Emphasizing
    • Relationship and Frequency Tracking Histograms
    • Variance or Performance Chart
    • Bullet Graphs
    • Dynamic Labels and Text Formulas
  • Interactive Controls
    • Introduce Form Controls
    • Check Boxes for Toggling Chart Series On/ Off
    • List Boxes for Controlling Multiple Charts
    • Option Buttons for Showing Views in on Chart
    • Buttons