Excel Dashboards Beginner To Expert

RM320

What You Will Learn

Course Outline

  • About This Course
  • First Steps of Creating Excel Dashboard
  • Data Sources
  • Basic Design Principles
  • Layout of Report
  • Color Schemes
  • INDEX() and MATCH()
  • OFFSET()
  • VLOOKUP() and HLOOKUP()
  • MID(), LEN(), TEXT(), and TRIM()
  • Structure of Pivot Tables
  • Formatting Pivot Tables
  • Sparklines
  • Highlight Comparison
  • In-Cell Charts
  • Creating Pivot Charts
  • Formatting Pivot Charts
  • Active X and Form Controls
  • Combo Box
  • Checkbox
  • Spin Button
  • Option Button
  • List Box
  • Scroll Bar
  • Basic Preparations
  • Sorting Procedure
  • Visualization
  • Final Touches