관리-도구

편집 파일: 1606790476.M109483P12395.server.saraya-global.com,S=182470,W=187015:2,

Envelope-to: jaisone@saraya.com.my
Delivery-date: Tue, 01 Dec 2020 10:41:16 +0800
Organization: OTC
Message-ID: <05c9e79a72469f895199e7a500337262@powerlearnings.com.my>
From: "linkallp@powerlearnings.com.my" <linkallp@powerlearnings.com.my>
To: "Sir/Madam," <linkallp@powerlearnings.com.my>
Date: Tue, 1 Dec 2020 10:10:46 +0800
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="b88a77dec1d3000f18adad88001e5d07"
Subject: ***SPAM*** =?windows-1252?Q?LIVE_ONLINE_PROGRAM-DATA_ANALYSIS_AND_INTERACTIVE_DASHBOARD_REPORTING_IN_EXCEL_(16&17_Dec_2020)?=

--b88a77dec1d3000f18adad88001e5d07
Content-Type: text/plain;
	charset="windows-1252"
Content-Transfer-Encoding: quoted-printable

Kindly contact 012-588 2175 for more inquiry

LIVE ONLINE PROGRAM

DATA ANALYSIS AND INTERACTIVE=20

DASHBOARD REPORTING IN EXCEL

Venue : Online Training (Via Zoom)=A0=A0 =
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0(HRDF/SBL =
Claimable)

Date : 16 Dec2020 (Wed)=A0 |=A0 9am - =
5pm=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 By =
Shabenah

17 Dec2020 (Thu)=A0 |=A0 9am - 5pm=A0=A0=A0=A0 =
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=2E

=2E

=A0

INTRODUCTION

Discover how to tame your data and make it work for you!=A0 With the huge =
amount=20
of data available to us every day, a well-built and designed dashboard =
reports=20
is one of the best ways to interpret and communicate large quantities of =
information.=20
Learn how to synthesise information into a logical framework, summarise =
it=20
into a meaningful format, and then display the summary into easy-to-read =
tables=20
and graphs.=20

=A0

LEARNING OBJECTIVE

Many of us struggle to make sense of all the data that is available in =
this=20
information age.=A0 With such a deluge of reports and statistics which do =
not=20
mean anything or can not be made sense of, it is no wonder that data is =
often=20
misinterpreted or not communicated at all. Learn how to synthesise =
information=20
into a logical framework, summarise it into a meaningful format, and then =
display=20
the summary into easy-to-read tables and graphs.=A0 Covering dashboard =
reporting,=20
balanced scorecards, visual design of charts and tables, we will also =
discuss=20
the new charting and analysis features of Excel 2013=2E

=A0

This course is very hands-on and practical. Each participant will be =
expected=20
to create their own reports, charts and models utilising the tools and =
techniques=20
covered during the course. By the end of the day, participants will

-Understand the principles of data analysis and dashboard

-Learn to synthesise and summarise information into a logical =
framework.=A0=20

-Consider when to use a chart or a table

-Know how to use visual effects to improve their reports and presentations

-Explore how to summarise, present and communicate data clearly and =
concisely

-Learn the principles of good dashboard design and presenting data =
graphically

-Discover the tools to analyse data & build reports using your existing =
Excel=20
tools and skills (and perhaps a few you did not know you had!)=A0=20

=A0

PREREQUISITES

The course material includes extensive use of Excel and participants will =
gain=20
the maximum benefit from this course if they are already competent spread =
sheet=20
users. It is designed for users who do use Excel on a regular basis, and =
are=20
comfortable with using its tools and functions. At minimum, it is assumed =
that=20
participants will know how to:

-Navigate confidently in Excel

-Use absolute cell references (e.g. =3D$A$1)=20

-Create and use advanced Excel tools and functions on a regular basis=2E

=A0

WHO SHOULD ATTEND THIS COURSE

This course is aimed at managers and other professionals who need to =
create=20
dashboards and other reports in order to analyse interpret and present =
information.=A0=20
It is expected that students should have had some exposure to business, =
finance=20
and reporting principles. This course builds on students existing =
knowledge=20
of Excel tools and functions and incorporates these into complex and =
dynamic=20
reports and dashboards=2E

=A0

OUTLINE OF WORKSHOP

Part 1-Pivot table Fundamentals

Chapter 1-Understanding Pivot tables And Charts

-Understanding How Pivot tables Work

-Working With Pivot tables

-Creating A Pivot table Report

-Creating A Pivot table With Multiple Columns

-Using The Pivot table And Pivot chart Wizard

-Creating A Pivot chart

=A0

Chapter 2-Understanding Data Sources For Pivot tables

-Using Excel Data From The Same Workbook

-Using Excel Data From Another Workbook

-Using Data From Other Sources

-Using Data From An Existing Data Connection

-Creating Pivot table Report From Data In An Access Database

-Using Other External Data Sources

-Using Multiple Consolidation Ranges

-Letting Excel Create A Single-Page (Report Filter) Field

-Creating Your Own Page (Report Filter) Field

-Creating A Single-Page Field Pivot table Report From Multiple =
Consolidation=20
Ranges

-Creating A Multiple Page-Field Pivot table Report From Multiple =
Consolidation=20
Ranges

-Basing A Pivot table On Another Pivot table Report

=A0

Chapter 3-Using Pivot table Tools And Formatting

-Understanding The Pivot table Field List

-Using The Field List

-Setting Field List Options

-Using Classing Pivot table Layout

-Using The Pivot table Ribbons

-Setting Pivot table Options

-Formatting Pivot tables

-Applying Pivot table Styles

-Creating Custom Pivot table Styles

-Formatting Value Cells

-Setting Report Layout

-Changing Other Formatting

-Applying Formatting To A Pivot table Report

=A0

Part II-Pivot tables And Charts : Going Beyond The Basics

Chapter 4-Working With Pivot table Components

-Using Report Areas

-The Field List

-Moving A Field To A Different Area

-Removing A Field

-Using The Row Labels Area

-Using Multiple Row Fields

-Moving Field Within An Area

-Using More Than Two Field In The Row Area

-Using The Column Labels Area

-Creating A Pivot table With Two Columns Fields And Two Row Fields

-Filtering And Sorting A Pivot table On Row And Column Fields

-Using The Value Area

-Using Multiple Value Fields

-Using The Report Filter Area

-Creating A Pivot table With Three Report Filter Fields

-Working With Field Settings

-Understanding The Settings For Value Fields

-Using Different Summary Functions

-Working With Settings For Row And Column Fields

-Subtotal And Filter Options

-Layout And Filter Options

-Working With Settings=A0 For Report Filter Fields

-Setting Advanced Value Field Options

-Using Value And Label Filters

-Using A Value Filter And Custom Sort

=A0

Chapter 5-More About Pivot table Components

-Working With Calculated Fields And Items

-Calculated Fields

-Creating And Using A Calculated Field

-Creating And Using A Calculated Items

-Showing And Hiding Detail

-Viewing Details For Value Items

-Viewing Details For Field Items

-Grouping Pivot table Items

-Grouping Numeric Items

-Grouping Dates

-Grouping Other Items

-Grouping Category Data

=A0

Chapter 6-Understanding And Using Pivotcharts

-Understanding Pivot charts

-Creating A Pivot chart

-Creating A Pivot chart From An Existing Pivot table

-Creating A Pivot chart From Scratch

-Creating A Pivot table And Pivot chart Together

-Understanding The Parts Of A Chart

-Working With The Pivot chart Ribbon

-Understanding And Changing Pivot chart=92s Structure=20

-A Simple Pivot chart

-A Pivot chart With Two Row Fields

-A Pivot chart=A0 With Two-Column Fields

-Creating A 3-D Pivot chart

-Using The Pivot chart Filter Pane

=A0

Part III-Getting The Most Out Of Pivottables And Charts

Chapter 7-Using Pivot tables And Multidimensional Data

-Using Multidimensional Data

-Understanding Multidimensional Data

-Flat Data

-Relational Data

-Multidimensional Data

-Where Are Multidimensional Data Stored?

-Multidimensional Data Terminology

-Creating A Pivot table From An Online Cube

=A0

Chapter 8 : Getting Hard Data From A Pivot table

-Understanding The Get pivot data Function

-Get pivot data Function Basics

-A Get pivot data Shortcut

-Referencing Pivot table Cells By Address

-Page Fields And The Get pivot data Function

-Using Get pivot data To Analyse Pivot table Data

-Copying And Moving Pivot tables

=A0

Chapter 9 :Pivot table Alternatives

-Working With Subtotals

-Nesting Subtotals

-Hiding And Showing Subtotals Details

-Working With Database Functions

-Defining Criteria=20

-Working With Filter=20

=A0

Part IV-Applying Data Analysis in Excel

Data Analysis Tools

-Tool selection

-Evaluation of Excel vs. other BI alternatives, including Power Pivot in =
terms=20
of speed, usability and cost

-Whats new in Office 2013

-Technical differences between versions. Considerations when building =
data=20
models for users of different versions=2E

-Shortcuts

-Speed up your data manipulation in Excel with the use of shortcuts

-Tables & PivotTables=20

-Analysing data more quickly and efficiently using structured reference =
table=20
and summarise using PivotTables

-Power Pivot

-Demonstration of the Microsoft add-in to Excel, PowerPivot

=A0

Using Excel as a Data Analysis Tool

-Essential Excel tools & functions

-Overview of must-know tools and functions for data analysis such as =
LOOKUPS,=20
logical and aggregation functions

-Specialist Functions and Formulas

-The OFFSET Function

-Nested IF Statements Using the AND and OR Operators

-VLOOKUPs

-The MATCH Function

-Creating a robust formula

-Nest functions together to create succinct and robust formulas

-Working with text

-Using text and concatenation functions to string numbers and text =
together=20
to show in a dashboard or chart=2E

-Cleaning your data

-Tools and tricks to clean data before using it to build a report or =
dashboard

=A0

Charting in Excel

-Working with charts in Excel 2013

-Overview of new charting features of Excel

-Creating a Combo or Bubble chart

-Show correlations by charting on different axes and chart types or =
bubble=20
charts

-Waterfall charts

-Comparison of different methods of waterfall charts, create your own =
template=20
for future use=2E

-Charting with dynamic ranges

-Explore various methods for dealing with varying data ranges in chart =
data=20
sources

=A0

Chart and Table Design

-Tables vs. Charts/Graphs

-Deciding the best method for visual display

-Visual Design

-Design principles for effective graphic data presentation

-Which chart?

-Choosing the correct chart to use to display different data and messages =
from=20
your findings

-Charting dos and do nots

-Tips and tricks for a quicker chart build and was to making charts more =
robust=20
and automated

=A0

Part V-Creating Interactive Dashboard in Excel

Kick start with Dashboards

-Dashboard Do and Do not

-Data Layout Creating Dynamic Dashboards

-Merging and Consolidating Data Using Shapes to make Charts more attractive

-Using Alerts to draw attention to dashboards

-Models - More Dashboarding

-Creating KPI Dashboards

-Project Management

-Dashboards Publishing Excel Dashboards to the Web

=A0

Working with your Data

-Understanding Data Quality issues

-Gathering data from different sources

-Linking Data

-Merging and Consolidating Data

-Excel Hints and Tips when working with data

=A0

=A0Analysing Data Effectively

=A0

Dashboard Reporting

-What is a dashboard?

-History and definition of dashboard reports

-Purpose and benefits of Dashboards

-Why dashboards are so popular

-Common mistakes when building a Dashboard

-Critique of poorly built dashboards

-Creating a Dashboard in Excel

-Using provided data, create your own dashboard in Excel

=A0

Dashboard Design

-Principles of dashboard design best practice

-Dashboard layout, colour choice and display principles

-Selecting the correct chart to display data

-Getting your message across most effectively by choosing the correct =
medium=20
of display=20

-Adding icons and images to dashboards

-Quick and easy ways to add automated colour and icons to your reports

-Effective use of colour and logos

-Ways to make an impact with colour

-Making dashboards dynamic

-Save time by using clever formulas which automatically update =
information=20
on the dashboard

-Excel Dashboard Tips and Tricks including=20

-Linking cells to a text box

-Linking cells to chart labels

-Forms and controls (for drop down lists to choose what you are comparing)

=A0

Part VI-Recording and Using Macros

-Recording Macros=20

-Running Macros

-Editing Macros

-Adding Macros to the Quick Access Toolbar

=A0

Practical exercise : Using your own data, or examples provided, create a =
dynamic=20
dashboard template incorporating the tools and techniques discussed =
during=20
the course=2E

=A0

ABOUT THE FACILITATOR =96 SHABENAH (BEE, BIS, DIT, MOS, IELTS)

SHABENAH is an experienced trainer, facilitator and consultant, with deep =
knowledge=20
in the field of IT especially Managing Big Data Using Microsoft Excel, =
Working=20
with Large Documents in Ms Word, Designing Top Notch Presentation using =
Microsoft=20
PowerPoint. She also trains soft skills, leadership and communication =
courses.=A0=20
She has great passion for training, learning and development, and is able =
to=20
work effectively with people at all levels.=A0 Shabenah is also an active =
participant=20
in local community and social activities. Shabenah has over 15 years of =
experience=20
with specialization in IT and Communication. She gained experience =
serving=20
as a Corporate Trainer with New Horizons Computer Learning Centre, =
Malaysia,=20
as a Centre Manager at SEGi Johor Bahru, and as a Group Account Manager =
at=20
Cosmopoint College Sdn Bhd.=A0 Shabenah is a certified corporate trainer =
registered=20
with PSMB / HRDF (Human Resource Development Fund) and IELTS Certified. =
Shabenah=20
delivers both educational and highly entertaining training sessions by =
incorporating=20
experiential learning activities in all her programs=2E

=A0

Significant Achievements

Corporate Training Industry

Shabenah played an important role in the research and development (R&D) =
of=20
training materials for many colleges and universities. She was involved =
aggressively=20
with the Corporate Sales and Marketing for her previous Companies and =
assisted=20
many organizations by providing standard and customized training. In =
2010,=20
she was awarded as the Best IT Trainer for Microsoft Office 2010 =
Applications=20
by NEW HORIZONS MALAYSIA. She has also been awarded a consolation award =
for=20
Informatics Nationwide Quest Project 2001 by Informatics Group of =
Colleges,=20
Singapore=2E

=A0

Training and Consultancy

Shabenah has conducted many training workshops, seminars and technical =
presentations=20
in IT and Soft skills for public and private sector executives in, =
Malaysia=20
and Singapore. They included Ministry of Finance (Malaysia), Polis Diraja =
Malaysia,=20
Jabatan Pendidikan Negeri Johor, Iskandar Regional Development =
Authorities=20
(IRDA), Pinewood Malaysia, Port of Tanjung Pelepas (PTP), Port of Tanjung =
Langsat=20
(TLP), Johor Port, TV3, CIDB Malaysia, International Islamic University =
Malaysia=20
(IIUM), PERKESO, GIANT, Kiswire Sdn Bhd, Genting Properties Sdn Bhd, TKR =
Precision=20
Sdn Bhd, MMHE, Eastern Plantation Agencies (EPA), Sime Darby , Puteri =
Specialist=20
Hospital (Johor), Sindora Berhad, Taisin Electric Cables Sdn Bhd, SWM =
Environment=20
Sdn Bhd, PCA Technology (M) Sdn Bhd, Panasonic System Networks Malaysia =
Sdn=20
Bhd, Senai Airport Terminal Service Sdn Bhd, CCM Chemicals Sdn Bhd, Hydro =
Aluminium=20
Malaysia Sdn Bhd, V.S. Industry Berhad, HANJIN Shipping Line Malaysia =
SdnBhd,=20
Tenaga Nasional Berhad, Public Utilities Board (Singapore) and many more=2E

=A0

Education

-Bachelor of Information System (Universiti Tun Abdul Razak)

-Diploma in Information Technology (Universiti Kebangsaan Malaysia)

-Microsoft Office 2016 Specialist=20

-IELTS (International English Language Test System)

=A0

Experience=20

Professional Corporate Trainer (for IT and Soft skill courses)=20

With a reputation for excellence and more than 10 years of experience, =
she=20
designs, develops and delivers professional workshops, courses and =
programs=20
that help individuals to advance in their careers and organizations to =
achieve=20
their business goals. Hundreds of private and public sector organizations =
rely=20
on Corporate Training Providers to help them develop high performing =
teams,=20
to help them develop their credentials and advance in their careers in =
the=20
future.=20

=A0

Group Account Manager=20

New Horizons Computer Learning Centers=20

2009 =96 2011 (2 years) Johor Bahru=20

=A0

Marketing Manager=20

COSMOPOINT INTERNATIONAL COLLEGE OF TECHNOLOGY=20

2007 =96 2008 (1 year)=20

=A0

Corporate Training Manager=20

Informatics Singapore=20

2002 =96 2007 (5 years)

=A0

(HRDF/SBL Claimable)

=A0

EARLY BIRD Fee  =20

NORMAL FEE

Registration before

8 Dec 2020  =20

RM 890.00/pax  =20

Registration after

8 Dec 2020  =20

RM 940.00/pax

Group Registration: Register 3 participants from the same organization, =
the=20
4th participant is FREE.=20
(Buy 3 Get 1 Free) if Register before 8 Dec 2020. Please act fast to grab =
your=20
favorite training program!
        =20

We hope you find it informative and interesting and we look

forward to seeing you soon=2E

Please act fast to grab your favorite training program! Pleasecall =
012-588=20
2175

=A0

Do forward this email to all your friends and colleagues who might be =
interested=20
to attend these programs

=A0

OTC Upcoming Public Training Programs 2020 & 2021

DECEMBER 2020 & JANUARY 2021

=A0

LIVE ONLINE TRAINING via ZOOM ONLINE=20

=A0

No.  =20

Date  =20

Program  =20

Trainer

1.  =20

1, 2, 3, 4

December 2020  =20

Digital Social Selling Masterclass 2020  =20

Angeline