관리-도구

편집 파일: 1601441168.M510869P25639.server.saraya-global.com,S=109147,W=111949:2,

Envelope-to: ryandass@saraya.com.my
Delivery-date: Wed, 30 Sep 2020 12:46:08 +0800
Organization: OTC
Message-ID: <abe088fa0f48973b8256fdfb003961ba@otcmarketing.com.my>
From: "paris3@otcmarketing.com.my" <paris3@otcmarketing.com.my>
To: "Sir/Madam," <paris3@otcmarketing.com.my>
Date: Wed, 30 Sep 2020 11:26:35 +0800
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="1c64e923d14cde405914cc5b001b6fcc"
Subject: ***SPAM*** =?windows-1252?Q?DATA_ANALYSIS_AND_INTERACTIVE_DASHBOARD_REPORTING_IN_EXCEL-18_&_19_Nov_2020-Petaling_Jaya?=

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

Kindly contact 012-588 2175 for more inquiry

DATA ANALYSIS AND INTERACTIVE=20

DASHBOARD REPORTING IN EXCEL

Venue: Hilton Petaling Jaya Hotel, Petaling Jaya

(HRDF/SBL Claimable)

Date: 18=A0& 19 Nov 2020 =
=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 =A0By Shabenah

Kindly click here for Full Brochure

=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

=A0IN-HOUSE TRAINING

This program can be specially tailored & customized for in house =
training.=A0

=A0

Training Fees

Group Registration

=A0(Buy 3 Get 1 Free).Only for early bird registration

=A0

Early Bird Fee

Registration before 5=A0 Nov=A02020=A0=A0=A0=A0RM 1,400.00/pax

=A0

Normal Fee

Registration after 5 =A0Nov=A02020 =A0=A0=A0=A0=A0 RM 1,450.00/pax

Kindly find above attached link=A0for the full brochure for this programs=2E

We hope you find it informative and interesting=A0 and we look

forward to seeing you soon=2E

=A0

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

or email to paris@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=20

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

Thanks

Regards

Paris Oo

OTC Training Centre Sdn Bhd
Mobile No. : 6012-5882175

Email address: paris@otc.com.my

Web site: www.otc.com.my

Facebook: www.facebook.com/otcmalaysia

=A0

--1c64e923d14cde405914cc5b001b6fcc
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">
<font=20
face=3DCalibri>Kindly contact 012-588 2175 for more inquiry<?xml:namespace =
prefix=20
=3D "o" ns =3D "urn:schemas-microsoft-com:office:office"=20
/><o:p></o:p>
<span=20
style=3D'FONT-SIZE: 18pt; FONT-FAMILY: "Times New Roman",serif; COLOR: =
#0070c0'>DATA=20
ANALYSIS AND INTERACTIVE <o:p></o:p>
<span=20
style=3D'FONT-SIZE: 18pt; FONT-FAMILY: "Times New Roman",serif; COLOR: =
#0070c0'>DASHBOARD=20
REPORTING IN EXCEL<o:p></o:p>
Venue:=20
Hilton Petaling Jaya Hotel, Petaling Jaya<o:p></o:p>
(HRDF/SBL=20
Claimable)<o:p></o:p>
Date:=20
18&nbsp;&amp; 19 Nov 2020=20
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;=20
&nbsp;By Shabenah
<o:p><a=20
href=3D"https://drive.google.com/file/d/1T_oSNT8S8hdahhke-JiPnXDfryWLNrje/v=
iew?usp=3Dsharing">Kindly=20
click here for Full Brochure</a></o:p>
<o:p>&nbsp;</o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>INTRODUCTION<o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>Discover =
how to=20
tame your data and make it work for you!&nbsp; With the huge amount of =
data=20
available to us every day, a well-built and designed dashboard reports is =
one of=20
the best ways to interpret and communicate large quantities of =
information.=20
Learn how to synthesise information into a logical framework, summarise it =
into=20
a meaningful format, and then display the summary into easy-to-read tables =
and=20
graphs. <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'>LEARNING=20
OBJECTIVE<o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>Many of =
us=20
struggle to make sense of all the data that is available in this =
information=20
age.&nbsp; With such a deluge of reports and statistics which do not mean=20
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>
<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'>This =
course is=20
very hands-on and practical. Each participant will be expected to create =
their=20
own reports, charts and models utilising the tools and techniques covered =
during=20
the course. By the end of the day, participants will<o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-Understand the=20
principles of data analysis and dashboard<o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>-Learn to=20
synthesise and summarise information into a logical framework.&nbsp;=20
<o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>-Consider =
when to=20
use a chart or a table<o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>-Know how =
to use=20
visual effects to improve their reports and =
presentations<o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>-Explore =
how to=20
summarise, present and communicate data clearly and=20
concisely<o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>-Learn =
the=20
principles of good dashboard design and presenting data=20
graphically<o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>-Discover =
the=20
tools to analyse data &amp; build reports using your existing Excel tools =
and=20
skills (and perhaps a few you did not know you had!)&nbsp;=20
<o:p></o:p>
<o:p>&nbsp;</o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>PREREQUISITES<o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>The =
course=20
material includes extensive use of Excel and participants will gain the =
maximum=20
benefit from this course if they are already competent spread sheet users. =
It is=20
designed for users who do use Excel on a regular basis, and are =
comfortable with=20
using its tools and functions. At minimum, it is assumed that participants =
will=20
know how to:<o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>-Navigate=20
confidently in Excel<o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>-Use =
absolute cell=20
references (e.g. =3D$A$1) <o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>-Create =
and use=20
advanced Excel tools and functions on a regular =
basis.<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'>WHO SHOULD =
ATTEND=20
THIS COURSE<o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>This =
course is=20
aimed at managers and other professionals who need to create dashboards =
and=20
other reports in order to analyse interpret and present information.&nbsp; =
It is=20
expected that students should have had some exposure to business, finance =
and=20
reporting principles. This course builds on students existing knowledge of =
Excel=20
tools and functions and incorporates these into complex and dynamic =
reports and=20
dashboards.<o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'><o:p>&nbsp;</o:p>
<font=20
size=3D3>OUTLINE OF=20
WORKSHOP<o:p></o:p>

<table class=3DMsoNormalTable=20
style=3D"BORDER-COLLAPSE: collapse; mso-yfti-tbllook: 1184; =
mso-padding-alt: 0in 0in 0in 0in"=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: 0in; PADDING-TOP: 0in; 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
 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'>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
 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'>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
 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'><o:p>&nbsp;</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'><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: 0in; PADDING-TOP: 0in; 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
 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'>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
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>&nbsp;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
 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'>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
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>&nbsp;<o:p></o:p></td></tr></table>
<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'>ABOUT THE=20
FACILITATOR =96 SHABENAH (BEE, BIS, DIT, MOS =
,IELTS)<o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
mso-ansi-language: EN-MY'>SHABENAH=20
is an experienced trainer, facilitator and consultant, with deep knowledge =
in=20
the 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
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
mso-ansi-language: EN-MY'>&nbsp;<o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
mso-ansi-language: EN-MY'>Significant=20
Achievements<o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
mso-ansi-language: EN-MY'>Corporate=20
Training Industry<o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
mso-ansi-language: EN-MY'>Shabenah=20
played an important role in the research and development (R&amp;D) of =
training=20
materials for many colleges and universities. She was involved =
aggressively with=20
the 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
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
mso-ansi-language: EN-MY'>&nbsp;<o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
mso-ansi-language: EN-MY'>Training=20
and Consultancy<o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
mso-ansi-language: EN-MY'>Shabenah=20
has conducted many training workshops, seminars and technical =
presentations in=20
IT 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
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
mso-ansi-language: EN-MY'>&nbsp;<o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
mso-ansi-language: EN-MY'>Education<o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>-<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
mso-ansi-language: EN-MY'>Bachelor=20
of Information System (Universiti Tun Abdul Razak)<o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
mso-ansi-language: EN-MY'>-Diploma=20
in Information Technology (Universiti Kebangsaan =
Malaysia)<o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
mso-ansi-language: EN-MY'>-Microsoft=20
Office 2016 Specialist <o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
mso-ansi-language: EN-MY'>-IELTS=20
(International English Language Test System)<o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'>&nbsp;<span=20
style=3D'FONT-FAMILY: "Times New Roman",serif'><o:p></o:p>
Experience=20
<o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 110%; mso-ansi-language: EN-MY'>Professional=20
Corporate Trainer (for IT and Soft skill courses) <span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 110%; mso-ansi-language: EN-MY'><o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
mso-ansi-language: EN-MY'>With=20
a reputation for excellence and more than 10 years of experience, she =
designs,=20
develops and delivers professional workshops, courses and programs that =
help=20
individuals to advance in their careers and organizations to achieve =
their=20
business goals. Hundreds of private and public sector organizations rely =
on=20
Corporate Training Providers to help them develop high performing teams, =
to help=20
them develop their credentials and advance in their careers in the =
future.=20
<o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 110%; mso-ansi-language: =
EN-MY'>&nbsp;<o:p></o:p>
Group=20
Account Manager <o:p></o:p>
New=20
Horizons Computer Learning Centers <o:p></o:p>
2009=20
=96 2011 (2 years) Johor Bahru <o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 110%; mso-ansi-language: =
EN-MY'>&nbsp;<o:p></o:p>
Marketing=20
Manager <o:p></o:p>
COSMOPOINT=20
INTERNATIONAL COLLEGE OF TECHNOLOGY <o:p></o:p>
2007=20
=96 2008 (1 year) <o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 110%; mso-ansi-language: =
EN-MY'>&nbsp;<o:p></o:p>
Corporate=20
Training Manager <o:p></o:p>
Informatics=20
Singapore <o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 110%; mso-ansi-language: EN-MY'>2002=20
=96 2007 (5 years)<o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; COLOR: =
#0d0d0d'><o:p>&nbsp;</o:p>
<font=20
size=3D3>&nbsp;IN-HOUSE=20
TRAINING<o:p></o:p>
<font=20
size=3D3>This=20
program can be specially tailored &amp; customized for in house=20
training.&nbsp;<span=20
style=3D"FONT-SIZE: 10pt"><o:p></o:p>
<o:p><span=20
style=3D"TEXT-DECORATION: none"><font=20
face=3DCalibri>&nbsp;</o:p>
<span=20
style=3D"COLOR: black">Training Fees<span=20
style=3D"COLOR: black"><o:p></o:p>
<span=20
style=3D'FONT-FAMILY: "Arial",sans-serif; COLOR: black'>Group=20
Registration<o:p></o:p>
<span=20
style=3D'FONT-FAMILY: "Arial",sans-serif; COLOR: black'>Register 3 =
participants=20
from the same organization, the 4th participant is FREE<span=20
style=3D"COLOR: black"><o:p></o:p>
<span=20
style=3D'FONT-FAMILY: "Arial",sans-serif; BACKGROUND: aqua; COLOR: black; =
mso-highlight: aqua'>&nbsp;<span=20
lang=3DEN-MY=20
style=3D'FONT-FAMILY: "Arial",sans-serif; BACKGROUND: aqua; COLOR: black; =
mso-ansi-language: EN-MY; mso-highlight: aqua'>(Buy=20
3 Get 1 Free).Only=20
for early bird registration<o:p></o:p>
<o:p>&nbsp;</o:p>
Early Bird Fee<span=20
style=3D"COLOR: #0d0d0d"><o:p></o:p>
Registration before =
5<span=20
style=3D"COLOR: #0d0d0d">&nbsp; Nov=20
&nbsp;2020&nbsp;&nbsp;&nbsp;&nbsp;RM=20
1,400.00/pax<o:p></o:p>
<o:p>&nbsp;</o:p>
Normal Fee<span=20
style=3D"COLOR: #0d0d0d"><o:p></o:p>
Registration after 5=20
&nbsp;Nov&nbsp;2020 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RM 1,45<span=20
style=3D"COLOR: #0d0d0d">0.00/pax<o:p></o:p>
Kindly find above =
attached=20
link&nbsp;for the full brochure for this=20
programs.<o:p></o:p>
We hope you find =
it=20
informative and interesting&nbsp; and we=20
look<o:p></o:p>
forward to seeing =
you=20
soon.<o:p></o:p>
<o:p>&nbsp;</o:p>
Please act fast to grab =
your=20
favorite training program! Please call 012-588 2175<span=20
style=3D'FONT-FAMILY: "Times New =
Roman",serif'><o:p></o:p>
or email to =
<a>paris@otc.com.my</a><o:p></o:p>
<span=20
style=3D'FONT-FAMILY: "Calibri Light",sans-serif; COLOR: =
#c00000'><o:p><font=20
size=3D3>&nbsp;</o:p>
<span=20
style=3D'FONT-FAMILY: "Calibri Light",sans-serif; COLOR: #c00000'>Do =
forward this=20
email to all your friends and colleagues who might be interested to attend =
these=20
programs<span=20
style=3D'FONT-FAMILY: "Calibri =
Light",sans-serif'><o:p></o:p>
<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 <o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
BACKGROUND: white; COLOR: #c00000'>Unsubscribe<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
BACKGROUND: white; COLOR: #c00000'>=20
in 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; COLOR: =
#1f497d'><o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; COLOR: =
black'>Thanks<o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; COLOR: =
black'>Regards<o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'>Paris =
Oo<span=20
style=3D"COLOR: black"><o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; COLOR: =
black'>OTC=20
Training Centre Sdn Bhd Mobile=20
No. : 6012-588=20
2175<span=20
style=3D"COLOR: black"><o:p></o:p>
Email=20
address: <a>paris@otc.com.my</a><span=20
lang=3DEN-GB=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; COLOR: =
black; mso-ansi-language: EN-GB'><o:p></o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; COLOR: =
black'>Web=20
site: <a href=3D"http://www.otc.com.my"><span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif'><font=20
color=3D#0563c1>www.otc.com.my</a><span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; COLOR: =
black'><o:p></o:p>
Facebook:=20
<a href=3D"http://www.facebook.com/otcmalaysia" =
target=3D_blank><span=20
lang=3DEN-GB=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; COLOR: =
black; mso-ansi-language: =
EN-GB'>www.facebook.com/otcmalaysia</a><span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; COLOR: =
black'><o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; COLOR: =
#3366ff; mso-ansi-language: EN-MY'><o:p>&nbsp;</o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; COLOR: =
#3366ff; mso-ansi-language: EN-MY'><o:p>&nbsp;</o:p>
<o:p>&nbsp;</o:p>
<span=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; COLOR: =
#c00000'><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>

--1c64e923d14cde405914cc5b001b6fcc--