Impressive Excel Dashboard

Impressive Excel Dashboard

Kategori: Microsoft Excel Tersedia
Untuk maklumat lanjut, lawati laman web rasmi kami di iconictraining.com.my

Penerangan

IMPRESSIVE EXCEL DASHBOARD
DURATION: 2 DAYS
 
WHO IS THIS COURSE FOR?

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.
 
WHY YOU SHOULD ATTEND?

Like a car dashboard, the objective of dashboard reporting is to provide clear and concise information of the key drivers of business performance. Dashboards are a synopsis of business operations and they provide information in visual format that is easy to read, remembered and understood by key decision makers in a business. This should in turn, improve decision making.
Dashboard reports allow managers to get high-level overview of the business and help them make quick decisions. Excel is an excellent tool to make powerful dashboards that can provide analysis, insight, and alert managers in timely manner.
 
COURSE BENEFITS

At the end of this course you will understand what makes a dashboard.

PRE-REQUISITES
 
Must be able to perform or have working experience with the following functions:
KEY CONTENT
 

UNIT 1: WHAT IS A DASHBOARD?

UNIT 2A: PIVOTTABLES (PART 1)

UNIT 2B: PIVOTCHARTS (PART 2)

UNIT 3: WORKING WITH CHARTS

UNIT 4: WORKING WITH SPARKLINES (EXCEL 2010 ONWARDS)

UNIT 5: DESIGN & LAYOUT

UNIT 6: USEFUL FUNCTIONS

UNIT 7: CONDITIONAL FORMATTING

UNIT 8: FORM CONTROLS

METHODOLOGY

Informative presentation, Group Discussion & Presentations, Hands on Session Practical Session

Lebih maklumat tentang Iconic Training Solutions Sdn Bhd
Iconic Training Solutions Sdn Bhd
Iconic Training Solutions Sdn Bhd Experiential Learning & Soft Skills Training Courses Malaysia, Best Software Provider Kuala Lumpur (KL), Leadership Enhancement Program Selangor ~ Iconic Training Solutions Sdn Bhd