Full program description

Executive Reporting Using Dynamic And Interactive Excel Dashboard

What's In It For Me

Creating of Interactive Excel Dashboard is one of the essential skills that company that work with data for decision making are looking for. Have you wonder how to create an interactive dashboard using only formulas and functions, without Pivot Table. The class will bring you through a new insight and understanding of Microsoft Excel.

Course Overview

This course is scheduled for launch in Q2 2018 - Q3 2018. To express your interest in this course, please fill up our form at https://www.surveymonkey.com/r/6MBPSFV. We will contact you when we get closer to course launch date.

This course is designed for learners who will like to create interactive dashboard using only formulas and functions. Form controls will be used to filter for the information to be presented.

Who Should Attend

Candidates who work with Microsoft Excel to create business reports.

This includes but not limited to 

  • Administrative Support Executive
  • Managers

Course Duration

2 Days / 14 Hours

Course Outline

FORMULAS AND FUNCTIONS

  • Index
  • Vlookup
  • Lookup

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

DOS AND DON'TS

  • Design principles
  • Color scheme
  • Information load

CASE ANALYSIS

  • Dashboard presentation

Certification Obtained and Conferred by

Awarded NTUC LearningHub Certificate of Completion

Course Objectives

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

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

Pre-requisites

  • Learner should have some knowledge of creating reports using Microsoft Excel
  • Learner should have experience writing formulas using lookup functions

Medium of Instruction & Trainer

Medium of Instruction: English

Trainer: Trainee ratio is 1:20

Price