관리-도구

편집 파일: 1622657007.M138463P22520.server.saraya-global.com,S=111567,W=114451:2,

Envelope-to: jaisone@saraya.com.my
Delivery-date: Thu, 03 Jun 2021 02:03:27 +0800
Organization: OTC
Message-ID: <eb45cf334d942bcef0266faa003fa833@otcmarketing.com.my>
From: "jenny@otcmarketing.com.my" <jenny@otcmarketing.com.my>
To: "HI SIR/MADAM," <jenny@otcmarketing.com.my>
Date: Thu, 3 Jun 2021 01:31:53 +0800
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="c670d2d402abe7070e5f485a0016595a"
Subject: ***SPAM*** =?windows-1252?Q?LIVE_ONLINE_PROGRAM-DATA_ANALYSIS_AND_INTERACTIVE_DASHBOARD_REPORTING_IN_EXCEL_(16&17_August_2021)?=

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

LIVE ONLINE PROGRAM

DATA ANALYSIS AND INTERACTIVE

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=A0 =
(HRDF/SBLKHAS Claimable)

Date : =A0=A0=A0=A0=A016 August=A0 2021 (Mon) | 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

=A0=A0=A0=A0 =A017 August =A02021 (Tues) | 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/SBLKHAS Claimable)

=A0

EARLY BIRD Fee  =20

NORMAL FEE

Registration before

2 August 2021  =20

RM 1,200.00/pax

(Subject to 6% SST)  =20

Registration after

2 August 2021  =20

RM 1,250.00/pax

(Subject to 6% SST)

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

=A0PLEASE FEEL FREE TO CONTACT ME IF YOU ARE LOOKING FOR THE FULL BROCHURE =
FILE

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
2263

or email to james@otc.com.my

=A0

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

=A0

If you would like to unsubscribe from our email list at any time, please =
simply=20
reply to the e-mail and type Unsubscribe

in the subject area. We will remove your name from the list and you will =
not=20
receive any additional e-mail

=A0

Thanks

=A0

Regards

James

OTC Training Centre Sdn Bhd
Mobile No. : 012-5882263

Email address: james@otc.com.my

website:www.otc.com.my

Facebook: www.facebook.com/otcmalaysia

Linkedin =
:https://www.linkedin.com/in/otc-training-centre-sdn-bhd-5311a317a/

Instagram : otctrainingcentre_001

=93Be sure to follow my LinkedIn, Facebook and instagram page, where I =
share=20
breaking news and information=94

We Believe in connecting Knowledge...both for your People & Industry

=A0

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

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content=3D"text/html; charset=3D" http-equiv=3D"content-type">
</head>
<body style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma, Tahoma">
<span=20
style=3D'FONT-SIZE: 20pt; FONT-FAMILY: "Times New Roman",serif; COLOR: =
red'><a=20
href=3D"https://drive.google.com/file/d/1Y0G9zCR92vhm8O8nVB5G4cCz11o8ERy3/v=
iew?usp=3Dsharing"><font=20
size=3D3>CLICK HERE TO DOWNLOAD THE FULL BROCHURE=20
FILE</a>
<span=20
style=3D'FONT-SIZE: 20pt; FONT-FAMILY: "Times New Roman",serif; COLOR: =
red'>LIVE=20
ONLINE PROGRAM<o:p></o:p>
<span=20
style=3D'FONT-SIZE: 28pt; FONT-FAMILY: "Times New Roman",serif; COLOR: =
blue'>DATA=20
ANALYSIS AND INTERACTIVE<span=20
style=3D'FONT-SIZE: 28pt; FONT-FAMILY: "Times New =
Roman",serif'><o:p></o:p>
<span=20
style=3D'FONT-SIZE: 28pt; FONT-FAMILY: "Times New Roman",serif; COLOR: =
blue'>DASHBOARD=20
REPORTING IN EXCEL<o:p></o:p>
<span=20
style=3D'FONT-SIZE: 14pt; FONT-FAMILY: "Times New Roman",serif'>Venue : =
Online=20
Training (Via Zoom)&nbsp;&nbsp; <span=20
style=3D"COLOR: =
#0d0d0d">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; COLOR: =
red'>(HRDF/SBL<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'> <span=20
style=3D"COLOR: red">KHAS Claimable)<span=20
style=3D"FONT-SIZE: 14pt"><o:p></o:p>
<span=20
style=3D'FONT-SIZE: 14pt; FONT-FAMILY: "Times New Roman",serif'>Date :=20
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;16 August&nbsp; 2021 (Mon) | 9am - 5pm<span=20
style=3D"COLOR: =
#0d0d0d">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
By Shabenah<o:p></o:p>
<span=20
style=3D'FONT-SIZE: 14pt; FONT-FAMILY: "Times New =
Roman",serif'>&nbsp;&nbsp;&nbsp;&nbsp;=20
&nbsp;17 August &nbsp;2021 (Tues) | 9am - 5pm<span=20
style=3D"COLOR: #0d0d0d">&nbsp;&nbsp;&nbsp;&nbsp;=20
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;<span=20
style=3D"COLOR: white">&nbsp;.<o:p></o:p>
<span=20
style=3D'FONT-SIZE: 14pt; FONT-FAMILY: "Times New Roman",serif; COLOR: =
white'>.<o:p></o:p>
<o:p>&nbsp;</o:p>
INTRODUCTION<o:p></o:p>
Discover=20
how to tame your data and make it work for you!&nbsp; With the huge amount =
of=20
data available to us every day, a well-built and designed dashboard =
reports is=20
one of the best ways to interpret and communicate large quantities of=20
information. Learn how to synthesise information into a logical =
framework,=20
summarise it into a meaningful format, and then display the summary into=20
easy-to-read tables and graphs. <o:p></o:p>
<o:p>&nbsp;</o:p>
LEARNING=20
OBJECTIVE<o:p></o:p>
Many=20
of us struggle to make sense of all the data that is available in this=20
information age.&nbsp; 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=20
display the summary into easy-to-read tables and graphs.&nbsp; Covering=20
dashboard reporting, balanced scorecards, visual design of charts and =
tables, we=20
will also discuss the new charting and analysis features of Excel=20
2013.<o:p></o:p>
<o:p>&nbsp;</o:p>
This=20
course is very hands-on and practical. Each participant will be expected =
to=20
create their own reports, charts and models utilising the tools and =
techniques=20
covered during the course. By the end of the day, participants=20
will<o:p></o:p>
-Understand=20
the principles of data analysis and dashboard<o:p></o:p>
-Learn=20
to synthesise and summarise information into a logical framework.&nbsp;=20
<o:p></o:p>
-Consider=20
when to use a chart or a table<o:p></o:p>
-Know=20
how to use visual effects to improve their reports and=20
presentations<o:p></o:p>
-Explore=20
how to summarise, present and communicate data clearly and=20
concisely<o:p></o:p>
-Learn=20
the principles of good dashboard design and presenting data=20
graphically<o:p></o:p>
-Discover=20
the tools to analyse data &amp; build reports using your existing Excel =
tools=20
and skills (and perhaps a few you did not know you had!)&nbsp;=20
<o:p></o:p>
<o:p>&nbsp;</o:p>
PREREQUISITES<o:p></o:p>
The=20
course material includes extensive use of Excel and participants will gain =
the=20
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:<o:p></o:p>
-Navigate=20
confidently in Excel<o:p></o:p>
-Use=20
absolute cell references (e.g. =3D$A$1) <o:p></o:p>
-Create=20
and use advanced Excel tools and functions on a regular=20
basis.<o:p></o:p>
<o:p>&nbsp;</o:p>
WHO=20
SHOULD ATTEND THIS COURSE<o:p></o:p>
This=20
course is aimed at managers and other professionals who need to create=20
dashboards and other reports in order to analyse interpret and present=20
information.&nbsp; It is expected that students should have had some =
exposure to=20
business, finance and reporting principles. This course builds on =
students=20
existing knowledge of Excel tools and functions and incorporates these =
into=20
complex and dynamic reports and dashboards.<o:p></o:p>
<o:p>&nbsp;</o:p>
<font=20
size=3D3>OUTLINE OF=20
WORKSHOP<o:p></o:p>
<div align=3Dcenter>
<table class=3DMsoNormalTable=20
style=3D"BORDER-COLLAPSE: collapse; mso-yfti-tbllook: 1184; =
mso-padding-alt: 0cm 0cm 0cm 0cm"=20
cellSpacing=3D0 cellPadding=3D0 border=3D0>
 =20
 <tr=20
 style=3D"HEIGHT: 64.3pt; mso-yfti-irow: 0; mso-yfti-firstrow: yes; =
mso-yfti-lastrow: yes">
 <td=20
 style=3D"BORDER-TOP: windowtext 1pt solid; HEIGHT: 64.3pt; =
BORDER-RIGHT: windowtext 1pt solid; WIDTH: 299.1pt; BORDER-BOTTOM: =
windowtext 1pt solid; PADDING-BOTTOM: 0cm; PADDING-TOP: 0cm; PADDING-LEFT: =
5.4pt; BORDER-LEFT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; =
BACKGROUND-COLOR: transparent"=20
 vAlign=3Dtop width=3D399>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>Part =
1-Pivot=20
 table Fundamentals<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>Chapter=20
 1-Understanding Pivot tables And Charts<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Understanding=20
 How Pivot tables Work<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Working=20
 With Pivot tables<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Creating A=20
 Pivot table Report<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Creating A=20
 Pivot table With Multiple Columns<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Using The=20
 Pivot table And Pivot chart Wizard<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Creating A=20
 Pivot chart<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>&nbsp;<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>Chapter=20
 2-Understanding Data Sources For Pivot=20
tables<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Using Excel=20
 Data From The Same Workbook<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Using Excel=20
 Data From Another Workbook<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Using Data=20
 From Other Sources<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Using Data=20
 From An Existing Data Connection<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Creating=20
 Pivot table Report From Data In An Access =
Database<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Using Other=20
 External Data Sources<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Using=20
 Multiple Consolidation Ranges<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Letting=20
 Excel Create A Single-Page (Report Filter) =
Field<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Creating=20
 Your Own Page (Report Filter) Field<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Creating A=20
 Single-Page Field Pivot table Report From Multiple Consolidation=20
 Ranges<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Creating A=20
 Multiple Page-Field Pivot table Report From Multiple Consolidation=20
 Ranges<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Basing A=20
 Pivot table On Another Pivot table Report<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>&nbsp;<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>Chapter=20
 3-Using Pivot table Tools And =
Formatting<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Understanding=20
 The Pivot table Field List<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Using The=20
 Field List<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Setting=20
 Field List Options<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Using=20
 Classing Pivot table Layout<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Using The=20
 Pivot table Ribbons<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Setting=20
 Pivot table Options<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Formatting=20
 Pivot tables<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Applying=20
 Pivot table Styles<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Creating=20
 Custom Pivot table Styles<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Formatting=20
 Value Cells<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Setting=20
 Report Layout<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Changing=20
 Other Formatting<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Applying=20
 Formatting To A Pivot table Report<o:p></o:p>
 <span=20
 lang=3DEN-US=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
mso-ansi-language: EN-US'>&nbsp;<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>Part=20
 II-Pivot tables And Charts : Going Beyond The=20
 Basics<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>Chapter=20
 4-Working With Pivot table Components<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Using=20
 Report Areas<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>-The =
Field=20
 List<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Moving A=20
 Field To A Different Area<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Removing A=20
 Field<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Using The=20
 Row Labels Area<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Using=20
 Multiple Row Fields<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Moving=20
 Field Within An Area<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Using More=20
 Than Two Field In The Row Area<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Using The=20
 Column Labels Area<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Creating A=20
 Pivot table With Two Columns Fields And Two Row=20
 Fields<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Filtering=20
 And Sorting A Pivot table On Row And Column =
Fields<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Using The=20
 Value Area<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Using=20
 Multiple Value Fields<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Using The=20
 Report Filter Area<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Creating A=20
 Pivot table With Three Report Filter Fields<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Working=20
 With Field Settings<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Understanding=20
 The Settings For Value Fields<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Using=20
 Different Summary Functions<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Working=20
 With Settings For Row And Column Fields<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Subtotal=20
 And Filter Options<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Layout And=20
 Filter Options<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Working=20
 With Settings&nbsp; For Report Filter Fields<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Setting=20
 Advanced Value Field Options<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Using Value=20
 And Label Filters<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Using A=20
 Value Filter And Custom Sort<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'><o:p>&nbsp;</o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>Chapter=20
 5-More About Pivot table Components<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Working=20
 With Calculated Fields And Items<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Calculated=20
 Fields<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Creating=20
 And Using A Calculated Field<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Creating=20
 And Using A Calculated Items<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Showing And=20
 Hiding Detail<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Viewing=20
 Details For Value Items<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Viewing=20
 Details For Field Items<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Grouping=20
 Pivot table Items<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Grouping=20
 Numeric Items<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Grouping=20
 Dates<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Grouping=20
 Other Items<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Grouping=20
 Category Data<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'><o:p>&nbsp;</o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>Chapter=20
 6-Understanding And Using Pivotcharts<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Understanding=20
 Pivot charts<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Creating A=20
 Pivot chart<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Creating A=20
 Pivot chart From An Existing Pivot table<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Creating A=20
 Pivot chart From Scratch<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Creating A=20
 Pivot table And Pivot chart Together<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Understanding=20
 The Parts Of A Chart<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Working=20
 With The Pivot chart Ribbon<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Understanding=20
 And Changing Pivot chart=92s Structure <o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>-A =
Simple=20
 Pivot chart<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>-A =
Pivot=20
 chart With Two Row Fields<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>-A =
Pivot=20
 chart&nbsp; With Two-Column Fields<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Creating A=20
 3-D Pivot chart<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Using The=20
 Pivot chart Filter Pane<o:p></o:p>
 <span=20
 lang=3DEN-US=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
mso-ansi-language: EN-US'>&nbsp;<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>Part=20
 III-Getting The Most Out Of Pivottables And=20
 Charts<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>Chapter=20
 7-Using Pivot tables And Multidimensional=20
 Data<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Using=20
 Multidimensional Data<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Understanding=20
 Multidimensional Data<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Flat=20
 Data<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Relational=20
 Data<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Multidimensional=20
 Data<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Where Are=20
 Multidimensional Data Stored?<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Multidimensional=20
 Data Terminology<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Creating A=20
 Pivot table From An Online Cube<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'><o:p>&nbsp;</o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>Chapter 8 :=20
 Getting Hard Data From A Pivot table<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Understanding=20
 The Get pivot data Function<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>-Get =
pivot=20
 data Function Basics<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>-A =
Get pivot=20
 data Shortcut<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Referencing=20
 Pivot table Cells By Address<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Page Fields=20
 And The Get pivot data Function<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Using Get=20
 pivot data To Analyse Pivot table Data<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Copying And=20
 Moving Pivot tables<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>&nbsp;<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>Chapter 9=20
 :Pivot table Alternatives<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Working=20
 With Subtotals<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Nesting=20
 Subtotals<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Hiding And=20
 Showing Subtotals Details<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Working=20
 With Database Functions<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Defining=20
 Criteria <o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Working=20
 With Filter <o:p></o:p>
 <span=20
 lang=3DEN-US=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
mso-ansi-language: EN-US'>&nbsp;<o:p></o:p>
 <span=20
 lang=3DEN-US=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
mso-ansi-language: EN-US'><o:p>&nbsp;</o:p>
 <span=20
 lang=3DEN-US=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
mso-ansi-language: EN-US'><o:p>&nbsp;</o:p>
 <span=20
 lang=3DEN-US=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
mso-ansi-language: EN-US'><o:p>&nbsp;</o:p></td>
 <td=20
 style=3D"BORDER-TOP: windowtext 1pt solid; HEIGHT: 64.3pt; =
BORDER-RIGHT: windowtext 1pt solid; WIDTH: 299.15pt; BORDER-BOTTOM: =
windowtext 1pt solid; PADDING-BOTTOM: 0cm; PADDING-TOP: 0cm; PADDING-LEFT: =
5.4pt; BORDER-LEFT: #f0f0f0; PADDING-RIGHT: 5.4pt; BACKGROUND-COLOR: =
transparent"=20
 vAlign=3Dtop width=3D399>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>Part=20
 IV-Applying Data Analysis in Excel<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>Data=20
 Analysis Tools<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Tool=20
 selection<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Evaluation=20
 of Excel vs. other BI alternatives, including Power Pivot in terms =
of=20
 speed, usability and cost<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Whats new=20
 in Office 2013<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Technical=20
 differences between versions. Considerations when building data =
models for=20
 users of different versions.<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Shortcuts<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Speed up=20
 your data manipulation in Excel with the use of=20
 shortcuts<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Tables=20
 &amp; PivotTables <o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Analysing=20
 data more quickly and efficiently using structured reference table =
and=20
 summarise using PivotTables<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Power=20
 Pivot<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Demonstration=20
 of the Microsoft add-in to Excel, PowerPivot<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'><o:p>&nbsp;</o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>Using Excel=20
 as a Data Analysis Tool<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Essential=20
 Excel tools &amp; functions<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Overview of=20
 must-know tools and functions for data analysis such as LOOKUPS, =
logical=20
 and aggregation functions<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Specialist=20
 Functions and Formulas<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>-The =
OFFSET=20
 Function<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Nested IF=20
 Statements Using the AND and OR Operators<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-VLOOKUPs<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>-The =
MATCH=20
 Function<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Creating a=20
 robust formula<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Nest=20
 functions together to create succinct and robust=20
 formulas<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Working=20
 with text<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Using text=20
 and concatenation functions to string numbers and text together to =
show in=20
 a dashboard or chart.<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Cleaning=20
 your data<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Tools and=20
 tricks to clean data before using it to build a report or=20
 dashboard<o:p></o:p>
 <span=20
 lang=3DEN-US=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
mso-ansi-language: EN-US'>&nbsp;<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>Charting in=20
 Excel<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Working=20
 with charts in Excel 2013<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Overview of=20
 new charting features of Excel<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Creating a=20
 Combo or Bubble chart<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Show=20
 correlations by charting on different axes and chart types or =
bubble=20
 charts<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Waterfall=20
 charts<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Comparison=20
 of different methods of waterfall charts, create your own template =
for=20
 future use.<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Charting=20
 with dynamic ranges<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Explore=20
 various methods for dealing with varying data ranges in chart data=20
 sources<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>&nbsp;<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>Chart and=20
 Table Design<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Tables vs.=20
 Charts/Graphs<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Deciding=20
 the best method for visual display<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Visual=20
 Design<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Design=20
 principles for effective graphic data =
presentation<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Which=20
 chart?<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Choosing=20
 the correct chart to use to display different data and messages from =
your=20
 findings<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Charting=20
 dos and do nots<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Tips and=20
 tricks for a quicker chart build and was to making charts more =
robust and=20
 automated<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'><o:p>&nbsp;</o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>Part=20
 V-Creating Interactive Dashboard in =
Excel<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>Kick =
start=20
 with Dashboards<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Dashboard=20
 Do and Do not<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Data Layout=20
 Creating Dynamic Dashboards<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Merging and=20
 Consolidating Data Using Shapes to make Charts more=20
 attractive<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Using=20
 Alerts to draw attention to dashboards<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Models -=20
 More Dashboarding<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Creating=20
 KPI Dashboards<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Project=20
 Management<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Dashboards=20
 Publishing Excel Dashboards to the Web<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>&nbsp;<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>Working with=20
 your Data<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Understanding=20
 Data Quality issues<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Gathering=20
 data from different sources<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Linking=20
 Data<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Merging and=20
 Consolidating Data<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Excel Hints=20
 and Tips when working with data<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'><o:p>&nbsp;</o:p>
 <span=20
 lang=3DEN-US=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
mso-ansi-language: EN-US'>&nbsp;<span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>Analysing=20
 Data Effectively<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>&nbsp;<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>Dashboard=20
 Reporting<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-What is a=20
 dashboard?<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-History and=20
 definition of dashboard reports<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Purpose and=20
 benefits of Dashboards<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Why=20
 dashboards are so popular<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Common=20
 mistakes when building a Dashboard<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Critique of=20
 poorly built dashboards<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Creating a=20
 Dashboard in Excel<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Using=20
 provided data, create your own dashboard in =
Excel<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>&nbsp;<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>Dashboard=20
 Design<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Principles=20
 of dashboard design best practice<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Dashboard=20
 layout, colour choice and display principles<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Selecting=20
 the correct chart to display data<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Getting=20
 your message across most effectively by choosing the correct medium =
of=20
 display <o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Adding=20
 icons and images to dashboards<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Quick and=20
 easy ways to add automated colour and icons to your=20
 reports<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Effective=20
 use of colour and logos<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Ways to=20
 make an impact with colour<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Making=20
 dashboards dynamic<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Save time=20
 by using clever formulas which automatically update information on =
the=20
 dashboard<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Excel=20
 Dashboard Tips and Tricks including <o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Linking=20
 cells to a text box<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Linking=20
 cells to chart labels<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Forms and=20
 controls (for drop down lists to choose what you are=20
 comparing)<o:p></o:p>
 <span=20
 lang=3DEN-US=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
mso-ansi-language: EN-US'>&nbsp;<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>Part=20
 VI-Recording and Using Macros<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Recording=20
 Macros <o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Running=20
 Macros<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Editing=20
 Macros<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Adding=20
 Macros to the Quick Access Toolbar<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>&nbsp;<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>Practical=20
 exercise :<span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'> =
Using your=20
 own data, or examples provided, create a dynamic dashboard template=20
 incorporating the tools and techniques discussed during the=20
 course.<o:p></o:p>
 <span=20
 lang=3DEN-US=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
mso-ansi-language: =
EN-US'>&nbsp;<o:p></o:p></td></tr></table></div>
<o:p>&nbsp;</o:p>
ABOUT=20
THE FACILITATOR =96 SHABENAH (BEE, BIS, DIT, MOS, =
IELTS)<o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>SHABENAH =
is an=20
experienced trainer, facilitator and consultant, with deep knowledge in =
the=20
field of IT especially Managing Big Data Using Microsoft Excel, Working =
with=20
Large Documents in Ms Word, Designing Top Notch Presentation using =
Microsoft=20
PowerPoint. She also trains soft skills, leadership and communication=20
courses.&nbsp; She has great passion for training, learning and =
development, and=20
is able to work effectively with people at all levels.&nbsp; Shabenah is =
also an=20
active participant in local community and social activities. Shabenah has =
over=20
15 years of experience with specialization in IT and Communication. She =
gained=20
experience serving as a Corporate Trainer with New Horizons Computer =
Learning=20
Centre, Malaysia, as a Centre Manager at SEGi Johor Bahru, and as a Group=20
Account Manager at Cosmopoint College Sdn Bhd.&nbsp; Shabenah is a =
certified=20
corporate trainer registered with PSMB / HRDF (Human Resource Development =
Fund)=20
and IELTS Certified. Shabenah delivers both educational and highly =
entertaining=20
training sessions by incorporating experiential learning activities in all =
her=20
programs.<o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>&nbsp;<o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>Significant=20
Achievements<o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>Corporate =
Training=20
Industry<o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>Shabenah =
played an=20
important role in the research and development (R&amp;D) of training =
materials=20
for many colleges and universities. She was involved aggressively with =
the=20
Corporate Sales and Marketing for her previous Companies and assisted =
many=20
organizations by providing standard and customized training. In 2010, she =
was=20
awarded as the Best IT Trainer for Microsoft Office 2010 Applications by =
NEW=20
HORIZONS MALAYSIA. She has also been awarded a consolation award for =
Informatics=20
Nationwide Quest Project 2001 by Informatics Group of Colleges,=20
Singapore.<o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>&nbsp;<o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>Training =
and=20
Consultancy<o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>Shabenah =
has=20
conducted many training workshops, seminars and technical presentations in =
IT=20
and Soft skills for public and private sector executives in, Malaysia and=20
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=20
Langsat (TLP), Johor Port, TV3, CIDB Malaysia, International Islamic =
University=20
Malaysia (IIUM), PERKESO, GIANT, Kiswire Sdn Bhd, Genting Properties Sdn =
Bhd,=20
TKR Precision Sdn Bhd, MMHE, Eastern Plantation Agencies (EPA), Sime Darby =
,=20
Puteri Specialist Hospital (Johor), Sindora Berhad, Taisin Electric Cables =
Sdn=20
Bhd, SWM Environment Sdn Bhd, PCA Technology (M) Sdn Bhd, Panasonic =
System=20
Networks Malaysia Sdn Bhd, Senai Airport Terminal Service Sdn Bhd, CCM =
Chemicals=20
Sdn Bhd, Hydro Aluminium Malaysia Sdn Bhd, V.S. Industry Berhad, HANJIN =
Shipping=20
Line Malaysia SdnBhd, Tenaga Nasional Berhad, Public Utilities Board =
(Singapore)=20
and many more.<o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>&nbsp;<o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>Education<o:p></o:p>
-<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>Bachelor =
of=20
Information System (Universiti Tun Abdul Razak)<o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>-Diploma =
in=20
Information Technology (Universiti Kebangsaan =
Malaysia)<o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>-Microsoft =
Office=20
2016 Specialist <o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>-IELTS=20
(International English Language Test System)<o:p></o:p>
&nbsp;<span=20
lang=3DEN-US=20
style=3D'FONT-FAMILY: "Times New Roman",serif; mso-ansi-language: =
EN-US'><o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>Experience=20
<o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 110%'>Professional=20
Corporate Trainer (for IT and Soft skill courses) <span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 110%'><o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>With a =
reputation=20
for excellence and more than 10 years of experience, she designs, develops =
and=20
delivers professional workshops, courses and programs that help =
individuals to=20
advance in their careers and organizations to achieve their business =
goals.=20
Hundreds of private and public sector organizations rely on Corporate =
Training=20
Providers to help them develop high performing teams, to help them develop =
their=20
credentials and advance in their careers in the future. =
<o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 110%'>&nbsp;<o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>Group =
Account=20
Manager <span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'><o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>New =
Horizons=20
Computer Learning Centers <o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>2009 =96 =
2011 (2=20
years) Johor Bahru <o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 110%'>&nbsp;<o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>Marketing =
Manager=20
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'><o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>COSMOPOINT=20
INTERNATIONAL COLLEGE OF TECHNOLOGY <o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>2007 =96 =
2008 (1=20
year) <o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 110%'>&nbsp;<o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>Corporate =
Training=20
Manager <span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'><o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>Informatics=20
Singapore <o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 110%'>2002=20
=96 2007 (5 years)<o:p></o:p>
<o:p>&nbsp;</o:p>
<span=20
style=3D'FONT-SIZE: 20pt; FONT-FAMILY: "Times New Roman",serif; COLOR: =
blue'>(HRDF/SBL<span=20
style=3D'FONT-SIZE: 20pt; FONT-FAMILY: "Times New Roman",serif'> <span=20
style=3D"COLOR: blue">KHAS Claimable)<o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'><o:p>&nbsp;</o:p>
<div align=3Dcenter>
<table class=3DMsoNormalTable=20
style=3D"WIDTH: 502.75pt; BORDER-COLLAPSE: collapse; mso-yfti-tbllook: =
1184; mso-padding-alt: 0cm 0cm 0cm 0cm"=20
cellSpacing=3D0 cellPadding=3D0 width=3D670 border=3D0>
 =20
 <tr style=3D"HEIGHT: 19.3pt; mso-yfti-irow: 0; mso-yfti-firstrow: yes">
 <td=20
 style=3D"BORDER-TOP: #a6a6a6 1pt solid; HEIGHT: 19.3pt; BORDER-RIGHT: =
#bebebe 1pt solid; WIDTH: 266.35pt; BACKGROUND: #ceddea; BORDER-BOTTOM: =
#a6a6a6 1pt solid; PADDING-BOTTOM: 2.9pt; PADDING-TOP: 2.9pt; =
PADDING-LEFT: 2.9pt; BORDER-LEFT: #a6a6a6 1pt solid; PADDING-RIGHT: =
2.9pt"=20
 width=3D355 colSpan=3D2>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
TEXT-TRANSFORM: uppercase; COLOR: black'>EARLY=20
 BIRD Fee<span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'><o:p></o:p></td>
 <td=20
 style=3D"BORDER-TOP: #a6a6a6 1pt solid; HEIGHT: 19.3pt; BORDER-RIGHT: =
#a6a6a6 1pt solid; WIDTH: 236.4pt; BACKGROUND: #ceddea; BORDER-BOTTOM: =
#a6a6a6 1pt solid; PADDING-BOTTOM: 2.9pt; PADDING-TOP: 2.9pt; =
PADDING-LEFT: 2.9pt; BORDER-LEFT: #f0f0f0; PADDING-RIGHT: 2.9pt"=20
 width=3D315 colSpan=3D2>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
TEXT-TRANSFORM: uppercase; COLOR: black'>NORMAL=20
 FEE<span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'><o:p></o:p></td></tr>
 <tr style=3D"HEIGHT: 25.85pt; mso-yfti-irow: 1">
 <td=20
 style=3D"BORDER-TOP: #f0f0f0; HEIGHT: 25.85pt; BORDER-RIGHT: #a6a6a6 =
1pt solid; WIDTH: 148.55pt; BORDER-BOTTOM: #a6a6a6 1pt solid; =
PADDING-BOTTOM: 2.9pt; PADDING-TOP: 2.9pt; PADDING-LEFT: 2.9pt; =
BORDER-LEFT: #a6a6a6 1pt solid; PADDING-RIGHT: 2.9pt; BACKGROUND-COLOR: =
transparent"=20
 width=3D198>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
COLOR: black'>Registration=20
 before<span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'><o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>2 =
August=20
 2021<o:p></o:p></td>
 <td=20
 style=3D"BORDER-TOP: #f0f0f0; HEIGHT: 25.85pt; BORDER-RIGHT: #bebebe =
1pt solid; WIDTH: 117.8pt; BORDER-BOTTOM: #a6a6a6 1pt solid; =
PADDING-BOTTOM: 2.9pt; PADDING-TOP: 2.9pt; PADDING-LEFT: 2.9pt; =
BORDER-LEFT: #f0f0f0; PADDING-RIGHT: 2.9pt; BACKGROUND-COLOR: =
transparent"=20
 width=3D157>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
COLOR: red'>RM=20
 1,200.00/pax<span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
COLOR: #c00000'><o:p></o:p>
 (Subject to=20
 6% SST)<o:p></o:p></td>
 <td=20
 style=3D"BORDER-TOP: #f0f0f0; HEIGHT: 25.85pt; BORDER-RIGHT: #bebebe =
1pt solid; WIDTH: 131.1pt; BORDER-BOTTOM: #a6a6a6 1pt solid; =
PADDING-BOTTOM: 2.9pt; PADDING-TOP: 2.9pt; PADDING-LEFT: 2.9pt; =
BORDER-LEFT: #f0f0f0; PADDING-RIGHT: 2.9pt; BACKGROUND-COLOR: =
transparent"=20
 width=3D175>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
COLOR: black'>Registration=20
 after<span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'><o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>2=20
 August =
2021<o:p></o:p></td>
 <td=20
 style=3D"BORDER-TOP: #f0f0f0; HEIGHT: 25.85pt; BORDER-RIGHT: #a6a6a6 =
1pt solid; WIDTH: 105.3pt; BORDER-BOTTOM: #a6a6a6 1pt solid; =
PADDING-BOTTOM: 2.9pt; PADDING-TOP: 2.9pt; PADDING-LEFT: 2.9pt; =
BORDER-LEFT: #f0f0f0; PADDING-RIGHT: 2.9pt; BACKGROUND-COLOR: =
transparent"=20
 width=3D140>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
COLOR: black'>RM=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>1,25<span=20
 style=3D"COLOR: black">0.00/pax<o:p></o:p>
 (Subject to=20
 6% SST)<o:p></o:p></td></tr>
 <tr style=3D"HEIGHT: 30.55pt; mso-yfti-irow: 2">
 <td=20
 style=3D"BORDER-TOP: #f0f0f0; HEIGHT: 30.55pt; BORDER-RIGHT: #a6a6a6 =
1pt solid; WIDTH: 502.75pt; BORDER-BOTTOM: #a6a6a6 1pt solid; =
PADDING-BOTTOM: 2.9pt; PADDING-TOP: 2.9pt; PADDING-LEFT: 2.9pt; =
BORDER-LEFT: #a6a6a6 1pt solid; PADDING-RIGHT: 2.9pt; BACKGROUND-COLOR: =
transparent"=20
 width=3D670 colSpan=3D4>
 <span=20
 style=3D'FONT-FAMILY: "Times New Roman",serif; COLOR: =
#c00000'>Group=20
 Registration: <span=20
 style=3D'FONT-FAMILY: "Times New Roman",serif; COLOR: =
black'>Register 3=20
 participants from the same organization, the 4th participant is =
FREE.=20
 (Buy 3 Get 1 Free) if <span=20
 style=3D'FONT-FAMILY: "Times New Roman",serif; COLOR: red'>Register =
before=20
 30 June 2021.<span=20
 style=3D'FONT-FAMILY: "Times New Roman",serif; COLOR: red'> =
<span=20
 style=3D'FONT-FAMILY: "Times New Roman",serif; COLOR: black'>Please =
act fast=20
 to grab your favorite training program!<span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'><o:p></o:p></td></tr>
 <tr style=3D"mso-yfti-irow: 3; mso-yfti-lastrow: yes">
 <td=20
 style=3D"BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; WIDTH: 148.5pt; =
BORDER-BOTTOM: #f0f0f0; PADDING-BOTTOM: 0cm; PADDING-TOP: 0cm; =
PADDING-LEFT: 0cm; BORDER-LEFT: #f0f0f0; PADDING-RIGHT: 0cm; =
BACKGROUND-COLOR: transparent"=20
 width=3D198></td>
 <td=20
 style=3D"BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; WIDTH: 117.75pt; =
BORDER-BOTTOM: #f0f0f0; PADDING-BOTTOM: 0cm; PADDING-TOP: 0cm; =
PADDING-LEFT: 0cm; BORDER-LEFT: #f0f0f0; PADDING-RIGHT: 0cm; =
BACKGROUND-COLOR: transparent"=20
 width=3D157></td>
 <td=20
 style=3D"BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; WIDTH: 131.25pt; =
BORDER-BOTTOM: #f0f0f0; PADDING-BOTTOM: 0cm; PADDING-TOP: 0cm; =
PADDING-LEFT: 0cm; BORDER-LEFT: #f0f0f0; PADDING-RIGHT: 0cm; =
BACKGROUND-COLOR: transparent"=20
 width=3D175></td>
 <td=20
 style=3D"BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; WIDTH: 105pt; =
BORDER-BOTTOM: #f0f0f0; PADDING-BOTTOM: 0cm; PADDING-TOP: 0cm; =
PADDING-LEFT: 0cm; BORDER-LEFT: #f0f0f0; PADDING-RIGHT: 0cm; =
BACKGROUND-COLOR: transparent"=20
 width=3D140></td></tr></table></div>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; COLOR: =
white'><a=20
href=3D" =
https://drive.google.com/file/d/1Y0G9zCR92vhm8O8nVB5G4cCz11o8ERy3/view?usp=
=3Dsharing">CLICK=20
HERE TO DOWNLOAD THE FULL BROCHURE FILE</a>&nbsp;
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; COLOR: =
white'><span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>We hope =
you find=20
it informative and interesting and we look<span=20
style=3D'FONT-FAMILY: "Times New =
Roman",serif'><o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>forward to =
seeing=20
you soon.<span=20
style=3D'FONT-FAMILY: "Times New =
Roman",serif'><o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>Please act =
fast to=20
grab your favorite training program! Please call 012-588=20
2263<span=20
style=3D'FONT-FAMILY: "Times New Roman",serif'><o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>or email =
to=20
<a href=3D"mailto:jenny@otc.com.my">jenny@otc.com.my</a><span=20
style=3D'FONT-FAMILY: "Times New Roman",serif'><o:p></o:p>
<span=20
style=3D'FONT-FAMILY: "Times New Roman",serif'><o:p><font=20
size=3D3>&nbsp;</o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; COLOR: =
red'>Do=20
forward this email to all your friends and colleagues who might be =
interested to=20
attend these programs<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'><o:p></o:p>
<span=20
style=3D"BACKGROUND: white"><o:p>&nbsp;</o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
BACKGROUND: white; COLOR: #c00000'>If=20
you would like to unsubscribe from our email list at any time, please =
simply=20
reply to the e-mail and type Unsubscribe <span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
BACKGROUND: white'><o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
BACKGROUND: white; COLOR: #c00000'>in=20
the subject area. We will remove your name from the list and you will not=20
receive any additional e-mail<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
BACKGROUND: white'><o:p></o:p>
<o:p>&nbsp;</o:p>
<o:p>&nbsp;</o:p>
<font=20
face=3DCalibri>Thanks<o:p></o:p>
<o:p>&nbsp;</o:p>
<font=20
face=3DCalibri>Regards<o:p></o:p>
<font=20
face=3DCalibri><span lang=3DEN-US=20
style=3D'FONT-SIZE: 11pt; FONT-FAMILY: "Calibri",sans-serif; COLOR: black; =
mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; =
mso-fareast-font-family: DengXian; mso-fareast-theme-font: minor-fareast; =
mso-hansi-theme-font: minor-latin; mso-bidi-font-family: "Times New =
Roman"; mso-bidi-theme-font: minor-bidi; mso-fareast-language: ZH-CN; =
mso-bidi-language: AR-SA; mso-no-proof: yes'>OTC=20
Training Centre Sdn Bhd<o:p>&nbsp;</o:p>
<o:p>&nbsp;</o:p>
<span=20
style=3D'FONT-FAMILY: "Calibri Light",sans-serif; COLOR: =
#c00000'><o:p><font=20
size=3D3>&nbsp;</o:p>

</body>
</html>

--c670d2d402abe7070e5f485a0016595a--