Impressive Excel Dashboard

Impressive Excel Dashboard

Kategorya: Microsoft Excel Magagamit
Para sa karagdagang impormasyon, bisitahin ang aming opisyal na website sa iconictraining.com.my

Deskripsyon

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

Tingnan ang karagdagang mga detalye tungkol sa 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