Building Dashboard Using Microsoft Excel – Intermediate Level

16-23 Jun, 2023, Remote Online Training - Public

Register Now
PDF Brochure

IPA Training is Registered with

Learn from the Best

Kelvin Ng
Microsoft Office 2016 Master Specialist
Microsoft Certified Trainer

Kelvin Ng Choo Kent is a highly experienced digital arts instructor and master trainer with more than 17 years of experience in the office automation consultation, graphic design, animation and print production arena. He is a graduate of Malaysian Institute of Art (MIA) And holds the distinction of being certified as Adobe Certified Expert (ACE), Microsoft Office 2016 Master Specialist MCP & MCT, Certified practitioner of Neuro-Semantics, Certified practitioner of Neuro-Linguistic programming & Certified practitioner of Hypnosis & Time-Lines.

Microsoft Certification

  • MICROSOFT CERTIFIED TRAINER (MCT) SINCE 2012
  • MICROSOFT OFFICE 2016 MASTER SPECIALIST (MOS)
  • MICROSOFT OFFICE EXCEL 2016 SPECIALIST (MOS)
  • MICROSOFT OFFICE WORD 2016 SPECIALIST (MOS)
  • MICROSOFT OFFICE POWERPOINT 2016 SPECIALIST (MOS)
  • MICROSOFT OFFICE ACCESS 2016 SPECIALIST (MOS)

Professional Qualifications

  • PSMB APPROVED TRAINER
  • CERTIFIED ETHICAL HACKER (CEH)
  • ADOBE CERTIFIED EXPERT (ACE)
  • CERTIFIED PRACTITIONER OF NEURO-SEMANTICS
  • CERTIFIED PRACTITIONER OF NEURO-LINGUISTIC PROGRAMMING
  • CERTIFIED PRACTITIONER OF HYPNOSIS & TIME- LINES


AREA OF EXPERTISE
Office Tools
Microsoft Office Suite (2003, 2007, 2010, 2013, 2016), Adobe Acrobat, Microsoft Visio


Soft Skill
Effective Presentation, Train The Trainer, Microsoft Office Business Application Coaching, Effective Communication


Graphic Design
Adobe Photoshop, Adobe Illustrator, Adobe Indesign, Quarkxpress, Adobe Pagemaker, Corel Draw, Corel Photo Paint

His Clientele


Venue Details

Remote Online Training - Public

Contact us

Juliany,
03 2283 6109
juliany@ipa.com.my

Phoebe,
03 2283 6100
phoebe@ipa.com.my 

FOR CUSTOMISED IN-HOUSE TRAINING
Jane,
03 2283 6101
Jane@ipa.com.my

ADDRESS 
A-28-5, 28th Floor, Menara UOA Bangsar, 
No.5, Jalan Bangsar Utama 1, 
59000 Kuala Lumpur
www.ipa.com.my

FOCUSING ON
  • Advanced Cell Number Format
  • Introduction to Excel Functions
  • Explore & Apply Interactive Functions
  • Lookup and Calculation Functions
  • Introduction to Form Control Elements
  • Building Mini Dashboard – Typography
  • Final Touches 
COURSE OVERVIEW

Excel Dashboard is a page that allows managers and business leaders to track key KPIs or indicators and to decide appropriately. It includes diagrams/ tables / views supported by facts. Nevertheless, not all reports are dashboards. Dashboard reports provide administrators with a high-level company summary. Excel is an excellent tool for producing powerful dashboards which allow managers to evaluate, inspect and alert on time.

In this Intermediate level, the main focus is on building an Interactive Report using a few special Functions and names. Participants can choose the report requirements from the Form Elements such as Option Buttons, Drop Down List, or Buttons.

AFTER ATTENDING THIS COURSE YOU WILL RETURN TO YOUR JOB…
  1. Applying advanced formatting to present data accurately so that the report is easily interpreted by the Management.
  2. Applying the Functions that will change the report to an interactive report.
  3. Designing the Dashboard interface using the Form Elements in Microsoft Excel without any Programming knowledge.
WHO SHOULD ATTEND
Personnel who use Microsoft Excel to analyse and prepare management reports, especially Administrative, Operational and Middle Management Staff.
METHODOLOGY
Guided Learning, group-paced, hands- on classroom training with real life examples for business applications.
Challenging exercises are set based on practical applications for typical organizational functions such as HR, Admin, Production, Sales etc. 
Day 1
9:00

Advanced Cell Number Format 

  • Number Formatting
  • Round Value with Number Custom Format based on Cell Value
  • Display Icon base on Value
  • Introduction to Conditional Formatting


10.45

About Functions

  • About Excel References
  • Use Name Range as Absolute Reference 

 

1:00 Lunch
2:00

Interactive Functions

  • Indirect Function
  • Offset Function
  • Choose Function
  • Index Function
  • Match Function

 

5:00 End of Day 1
Day 2
9:00

Lookup and Calculation Functions

  • VLOOKUP Functions
  • Database Function
  • SUMIFS
  • SUMPRODUCT Function


10.45

Introduction to Form Controls

  • Build Option Buttons
  • Group Option
  • Use Combo Box
  • Spinner Button

 

1:00 Lunch
2:00

Building Infographics for Dashboard

  • Apply Typography
  • Connect Value to Graphic/Drawing

 

3:45

Final Touche

  • Arrange Dashboard elements
  • Building Interaction with Report 

 

5:00 End of Course