Please login to use this feature. You can use this feature to add the product to your favourite list.
Close
You have added this product to your favorite list. Check My Favourite
Close
You have removed this product from your favourite list.
Close
Please login to use this feature. You can use this feature to add the company to your favourites list.
Close
This company has been added successfully. Check My Favourite
Close
This company has been removed from your favourite list.
Close
Please login to use this feature. You can use this feature to add the company to your inquiry cart.
Close
This company has been added to your inquiry cart.
Close
This company has been removed from your inquiry cart.
Close
This product has been added to your inquiry cart.
Close
This product has been removed from your inquiry cart.
Close
Maximum number of Product/Company has been reached in inquiry cart.
Close
Iconic Training Solutions Sdn Bhd
Iconic Training Solutions Sdn Bhd 1217801-A
Business
Hours
Monday - Friday 8:30 AM - 6:00 PM
Saturday - Sunday Closed
We′re closed on Public Holiday
Get the latest
Iconic Training Solutions Sdn Bhd
App for iOS and Android
Open Closed
Featured Merchant
+60123980802
Social Media Link
  • facebook
  • wordpress

18-Sep-2019

Impressive Excel Dashboard

Duration: 2 Days
Date: 16-17 December 2019
Time: 9am-5pm
Venue: SVOFO, Sunway Nexis, Kota Damansara

Introduction: 

  • Have you ever been swarmed by a table of data of an excel business report?
  • Does the spreadsheet able to assist you to make effective and quick business decision?
  • Does the function of Pivot Table provide enough assistance to you to dissect the information you need? 

If you are still doubtful with the answers in your mind, Impressive Excel Dashboard is the course just for you!

Dashboard give you an unprecedented visibility into your work. You can get a quick, visual status update on your project or drill down into important details, all in one place, easily. Dashboard can boost you and your organization's speed by allowing you and your team to see more, manage more, communicate more and do more. Dashboard tracks KPIs, metrics and other data point in one visual, central place, giving you a high level view of work, helping you to make effective decisions. It also simplifies complex data and provide an at one glance view of current status or performance in real time.
 

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.

Prerequisites

Basic knowledge of Windows is essential with the following pre-requisites:
  • Create basic formulas - Addition, Subraction, Multiplication and Division
  • Use basic functions - AutoSum, Count, Max, Min and Average functions
  • Print a spreadsheet with headers and footers added
  • Create a basic chart
  • Create a spreadsheet with simple formatting
  • Clean duplicate records
  • Use data validation command
  • Use basic conditional formatting
  • Create basic PivotTable and PivotCharts
  • Must possess formulas knowledge - basic COUNTIF, SUMIF, IF and VLOOKUP

Course Objectives

Upon completion of this program, participants should be able to know:
  • Creating an impressive dashboard
  • PivotTable and PivotCharts
  • useful formulas
  • Conditional Formatting
  • Form Controls
  • Working with Charts
  • Working with Sparklines
  • Design and Layout of Dashboard

Course Outlines

Module 1: What is a Dashboard?

  • Why Use a Dashboard?
  • Common Features of a Dashboard
  • Why use Excel?
  • Preparing to Build a Dashboard

Module 2: PivotTables and PivotCharts

  • What is a PivotTable?
  • Creating a PivotTable
  • Formatting a PivotTable
  • Refreshing a PivotTable
  • Grouping
  • Using Slicers to Manipulate PivotTables
  • Using Timelines to Filter Dates (Excel 2013 Only)
  • Creating PivotCharts
  • PivotTables, PivotCharts and Slicers in Dashboard

Module 3: Useful Functions

  • Using NESTED IF Statements
  • Use COUNTIF & SUMIFS
  • Using EDATE Function
  • Use the INDEX function to retrieve information by location
  • The INDE Array form
  • Use the MATCH Function to Locate Data Position

Module 4: Conditional Formatting

  • Conditional Formatting
  • Conditional Formatting on PivotTables
  • Conditional Formatting with Dashboards

Module 5: Forms Controls

  • Adding Controls
  • Understanding Controls and How They Work
  • Using Form Controls on Dashboard

Module 6: Working with Charts

  • Creating Charts
  • Formatting Charts
  • Secondary Axes
  • Combination Charts
  • Creating Chart Templates

Module 7: Working with Sparklines

  • What are Sparklines
  • Creating a Sparklines
  • Modifying a Sparklines
  • Customizing a Sparklines

Module 8: Design & Layout

  • Gridlines & Outlines
  • Lining Up Excel Objects
  • Theming a Dashboard
Send your message to Iconic Training Solutions Sdn Bhd
Thank you for your inquiry!
Our Customer Support will be in touch with you shortly.
Your Name *
Your Company Name
Your Email *
Your Contact Number *
Subject *
Message *
Captcha *
Main Office

Iconic Training Solutions Sdn Bhd (1217801-A)
S1-30-12, Dsara Sentral, Jalan Welfare, Sungai Buloh, 40160, Shah Alam, Selangor, Malaysia.

Tel:

Email:
Website: http://www.iconictraining.com.my
Website: https://iconictraining.newpages.com.my/
Website: http://iconictraining.n.my/

1
Hello! Thanks for visiting my site. Please press Start button to Contact with Admin :)

Start

Browse by : Home - Classifieds - Companies - Location - Tags - Products - News & Promotion - Job Vacancy - Mobile Website - Google - SEO Results

All Shop List from NEWSTORE in Malaysia

  • MY 649
  • US 198
  • FR 124
  • CN 82
  • IE 48
  • RU 42
  • SG 13
  • GB 5
People Online
Brochure
Download
Our PackageContact Us