您已经添加该商品到您的收藏列表
从您收藏列表中删除此商品。
这家公司已成功添加。 查看我的收藏.
这家公司已从你的收藏夹列表中删除。
这家公司已被添加到您的询问车。
这家公司已从询价车中删除。
该商品已被添加到您的询问车。
该商品已经从您的询价车中删除。
商品/公司已达到添加至询价车的数量。
登入NEWPAGES
保持登入状态
每日登录奖励

恭喜! 你获得了今天的每日登录奖励!

5 NP Point这是您获得的奖励!
查看您的每日登录奖励

确保每天回来登入以获更多的奖励!
谢谢!

Back
Iconic Training Solutions Sdn Bhd
Iconic Training Solutions Sdn Bhd (1217801-A)
访客

Impressive Excel Dashboard

18-Sep-2019
Impressive Excel Dashboard
产品已浏览 42
WhatsApp me if you're interested

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
发信息至 Iconic Training Solutions Sdn Bhd

谢谢您的询问!
我们的客服会尽快联络您。

获取最新的 Iconic Training Solutions Sdn Bhd 应用程序 iOSAndroid
如需咨询或问题,联系我们
总办事处

Iconic Training Solutions Sdn Bhd (1217801-A)
S1-30-12, D’sara Sentral, Jalan Welfare, Sungai Buloh, 40160, Shah Alam, Selangor, Malaysia.
Google Maps Waze

电话: +603-5031 9631

邮件: findus@iconictraining.com.my, jason.yeah@iconictraining.com.my
网址: http://www.iconictraining.com.my
网址: https://iconictraining.newpages.com.my/
网址: http://iconictraining.n.my/

社交媒体链接
  • facebook
  • wordpress

Powered by NEWPAGES