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

 Original course fee $270 (before 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

UDSIT06