Skip To Content
Executive Reporting Using Dynamic And Interactive Excel Dashboards is a Program

Executive Reporting Using Dynamic And Interactive Excel Dashboards


Sorry! The enrollment period is currently closed. Please check back soon.

Full program description

Executive Reporting Using Dynamic And Interactive Excel Dashboards

Course Duration

1 Day / 7 Hours

Course Outline

Essential Built-in Functions

  • Index
  • Match
  • Named ranges

Developers Form Control Tools

  • Combo box
  • Scrolling bar
  • Spin button
  • Checkbox
  • Option button

Additional Excel Tools

  • Multiple-dependent drop-down lists (data validation)
  • Protect worksheet with specified unlocked cells
  • Show/hide gridlines, formula bar, headings
  • Create a hyperlink to a location in the current document
  • Nested if functions
  • Conditional formatting

Charting Management

  • Locking aspect ratio
  • Prevent chart resizing with cells
  • Categories in reverse order

Course Objectives

At the end of the course, you will be able to:

  • Understand the structure of a dashboard
  • Identify the excel functions and developer form-control tools needed for dashboard creation
  • Apply learnt functions and developer tools to create a dashboard for analysis


  • Simple typing using the keyboard
  • Navigating using the mouse
  • Managing files and creating folders
  • Have experience in writing Excel formulas for calculation. E.g.: Index and Match, and Named Ranges
  • Attended Microsoft Excel Intermediate level course


 Original course fee $270 (with GST)
 After funding for NTUC Union Member $20 (with GST)

Terms and conditions apply. NTUC LearningHub reserve the right to make changes or improvements to any of the products described in this document without prior notice.

Prices are subject to other LHUB miscellaneous fees