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

Executive Reporting Using Dynamic And Interactive Excel Dashboards

Self-paced

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
  • Check box
  • 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, participants 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

Pre-requisites

  • 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

Price

Non-NTUC member: $270

NTUC member: $20

UDSIT02