Microsoft Excel Dashboard for Business Intelligence

Course Objectives

  • Creating dashboard
  • Pivottbales and PivotCharts
  • Useful functions
  • Conditional Formatting
  • Form Controls
  • Working with charts
  • Working with Sparklines

Target Audience

This course is best suited to anyone in Business Intelligence, data managers, data analysts, or Project Managers. This course would also suit anyone looking to extend their knowledge of Excel to understand some of the more advanced features and how they can be used to work together.

Methodology

This program will be conducted with interactive lectures, PowerPoint presentation, discussions and practical exercise

Course Modules

  • MODULE 1: WHAT IS A DASHBOARD?
  • MODULE 2: PIVOTTABLES AND PIVOTCHARTS
  • MODULE 3: USEFUL FUNCTIONS
  • MODULE 4: CONDITIONAL FORMATTING
  • MODULE 5: FORM CONTROLS
  • MODULE 6: WORKING WITH CHARTS
  • MODULE 7: WORKING WITH SPARKLINES
    APPENDIX A: SAMPLE DASHBOARD PROJECTS

Get To Know The Trainer

Trainer Sharon

 4.5

Sharon Lee has been a marketing & brand management executive for 20 years and is a successful business builder in the role of distributor, marketer, brand builder and product innovation leader. 

Chat with us LIVE to get a

FREE QUOTATION!

COURSE INCLUDES

COURSE BENEFITS

ALL IN FROM ONLY

RM1,070/DAY

RRP RM1,530/DAY   SAVE RM460

*T&C Applies

PARTICIPANT REVIEWS FOR THIS COURSE

No review yet.

MEMBERS ONLY FEATURE

Kindly sign-up or log-in to get access.

LOGIN

Login with your social account

or

Don’t have an account with us?

FREE FOR LIFE

Sign Up to Bookmark your Favourite Course
or Request for a Quotation instantly

Sign in with your social account

or

By signing up, you agree to our Terms of Use and Privacy Policy

Have an account with us already?