관리-도구

편집 파일: 1607621577.M647708P28792.server.saraya-global.com,S=26313,W=26837:2,

Envelope-to: hans@saraya.com.my
Delivery-date: Fri, 11 Dec 2020 01:32:57 +0800
Date: Thu, 10 Dec 2020 17:32:08 +0000 (UTC)
Mime-version: 1.0
From: IT <adam@trainingcampaign.my>
Message-Id: <1211132.CGAYOSGK@trainingcampaign.my>
Reply-To: training.prog@gmail.com
To: hans@saraya.com.my
Content-Type: text/html; charset=iso-8859-1
Content-transfer-encoding: quoted-printable
Subject: ***SPAM*** Online: Vlookup & Pivot

<HTML>

<head>
<meta http-equiv=3D"Content-Language" content=3D"en-us">
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dwindows-1=
252">
<title>STAY SAFE DURING COVID AND CONDU</title>
<style>

</style>
</head>

<body>

<div align=3D"center">

COMSYSTEM SOLUTIONS SD=
N
BHD

ONLINE TRAINING=

<table class=3D"MsoNormalTable" border=3D"0" cellspacing=3D"0" cellpadding=
=3D"0" width=3D"668" style=3D"width: 501.3pt; border-collapse: collapse">
<tr>
<td width=3D"40" valign=3D"top" style=3D"width:30.05pt;border:none;border-b=
ottom:solid #BF4A19 3.0pt;
padding:0cm 5.4pt 0cm 5.4pt">
&nbsp;</td>
<td width=3D"89" valign=3D"top" style=3D"width:66.85pt;border:none;border-b=
ottom:solid #BF4A19 3.0pt;
padding:0cm 5.4pt 0cm 5.4pt">&nbsp;</td>
<td width=3D"253" colspan=3D"2" valign=3D"top" style=3D"width:189.85pt;bord=
er:none;
border-bottom:solid #BF4A19 3.0pt;padding:0cm 5.4pt 0cm 5.4pt">&nbsp;</td>
<td width=3D"134" valign=3D"top" style=3D"width:100.25pt;border:none;border=
-bottom:
solid #BF4A19 3.0pt;padding:0cm 5.4pt 0cm 5.4pt">&nbsp;</td>
<td width=3D"152" valign=3D"top" style=3D"width:114.3pt;border:none;border-=
bottom:solid #BF4A19 3.0pt;
padding:0cm 5.4pt 0cm 5.4pt">&nbsp;</td>
</tr>
<tr>
<td width=3D"668" colspan=3D"6" valign=3D"top" style=3D"width: 501.3pt; bor=
der: medium none; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0=
cm; padding-bottom: 0cm">
&nbsp;</td>
</tr>
<tr style=3D"height: 91.35pt">
<td width=3D"668" colspan=3D"6" valign=3D"top" style=3D"width:501.3pt;paddi=
ng:0cm 5.4pt 0cm 5.4pt;
height:91.35pt">


&nbsp;


Pivot Table &amp;
Vlookup</td>
</tr>
<tr style=3D"height: 55.35pt">
<td width=3D"668" colspan=3D"6" valign=3D"top" style=3D"width:501.3pt;paddi=
ng:0cm 5.4pt 0cm 5.4pt;
height:55.35pt">


Plan and Prepare Effective Analytical Reports, Highlighting Insights
and Trends</td>
</tr>
<tr>
<td width=3D"366" colspan=3D"3" rowspan=3D"7" valign=3D"top" style=3D"width=
:274.5pt;padding:
0cm 5.4pt 0cm 5.4pt">


Objective</=
p>

&nbsp;=
<span style=3D"font-family: Segoe UI; font-style: normal; font-variant-liga=
tures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing:=
 normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: n=
one; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke=
-width: 0px; text-decoration-thickness: initial; text-decoration-style: ini=
tial; text-decoration-color: initial; display: inline !important; float: no=
ne; background-color: rgb(255, 255, 255)">The
pivot table is one of the most powerful functions of excel. A pivot
table is a table of statistics that help to summarize and reorganize
the data of a wide/broad table. This tool helps to shorten the data
and help to analyze the data categorize wise and create own
customized group. On the other hand, VLOOKUP is a function which
used in excel when you are required to find things/value in a data
or range by row. In this article, we look at how to use VLookup
within the Pivot Table.

<span style=3D"color: rgb(32, 33, 36); font-family: Segoe UI; font-size: 16=
px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: =
normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: l=
eft; text-indent: 0px; text-transform: none; white-space: normal; widows: 2=
; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickn=
ess: initial; text-decoration-style: initial; text-decoration-color: initia=
l; display: inline !important; float: none; background-color: rgb(255, 255,=
 255)">
If you are analyzing data and creating reports regularly,&nbsp;<b st=
yle=3D"color: rgb(32, 33, 36); font-family: Segoe UI; font-size: 16px; font=
-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; =
letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; tex=
t-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webk=
it-text-stroke-width: 0px; text-decoration-thickness: initial; text-decorat=
ion-style: initial; text-decoration-color: initial; background-color: rgb(2=
55, 255, 255)">Pivot
Tables<span style=3D"color: rgb(32, 33, 36); font-family: Segoe UI; fon=
t-size: 16px; font-style: normal; font-variant-ligatures: normal; font-vari=
ant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; tex=
t-align: left; text-indent: 0px; text-transform: none; white-space: normal;=
 widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decorat=
ion-thickness: initial; text-decoration-style: initial; text-decoration-col=
or: initial; display: inline !important; float: none; background-color: rgb=
(255, 255, 255)">&nbsp;and&nbsp;<b style=3D"color: rgb(32, 33, 36); =
font-family: Segoe UI; font-size: 16px; font-style: normal; font-variant-li=
gatures: normal; font-variant-caps: normal; letter-spacing: normal; orphans=
: 2; text-align: left; text-indent: 0px; text-transform: none; white-space:=
 normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text=
-decoration-thickness: initial; text-decoration-style: initial; text-decora=
tion-color: initial; background-color: rgb(255, 255, 255)">VLOOKUPs<spa=
n style=3D"color: rgb(32, 33, 36); font-family: Segoe UI; font-size: 16px; =
font-style: normal; font-variant-ligatures: normal; font-variant-caps: norm=
al; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left;=
 text-indent: 0px; text-transform: none; white-space: normal; widows: 2; wo=
rd-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness:=
 initial; text-decoration-style: initial; text-decoration-color: initial; d=
isplay: inline !important; float: none; background-color: rgb(255, 255, 255=
)">&nbsp;will
make your life much easier.&nbsp;<b style=3D"color: rgb(32, 33, 36);=
 font-family: Segoe UI; font-size: 16px; font-style: normal; font-variant-l=
igatures: normal; font-variant-caps: normal; letter-spacing: normal; orphan=
s: 2; text-align: left; text-indent: 0px; text-transform: none; white-space=
: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; tex=
t-decoration-thickness: initial; text-decoration-style: initial; text-decor=
ation-color: initial; background-color: rgb(255, 255, 255)">Pivot
Tables<span style=3D"color: rgb(32, 33, 36); font-family: Segoe UI; fon=
t-size: 16px; font-style: normal; font-variant-ligatures: normal; font-vari=
ant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; tex=
t-align: left; text-indent: 0px; text-transform: none; white-space: normal;=
 widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decorat=
ion-thickness: initial; text-decoration-style: initial; text-decoration-col=
or: initial; display: inline !important; float: none; background-color: rgb=
(255, 255, 255)">:&nbsp;<b style=3D"color: rgb(32, 33, 36); font-fam=
ily: Segoe UI; font-size: 16px; font-style: normal; font-variant-ligatures:=
 normal; font-variant-caps: normal; letter-spacing: normal; orphans: 2; tex=
t-align: left; text-indent: 0px; text-transform: none; white-space: normal;=
 widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decorat=
ion-thickness: initial; text-decoration-style: initial; text-decoration-col=
or: initial; background-color: rgb(255, 255, 255)">Pivot
Tables<span style=3D"color: rgb(32, 33, 36); font-family: Segoe UI; fon=
t-size: 16px; font-style: normal; font-variant-ligatures: normal; font-vari=
ant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; tex=
t-align: left; text-indent: 0px; text-transform: none; white-space: normal;=
 widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decorat=
ion-thickness: initial; text-decoration-style: initial; text-decoration-col=
or: initial; display: inline !important; float: none; background-color: rgb=
(255, 255, 255)">&nbsp;are
a powerful feature that allows you to easily summarize your data
from a&nbsp;<b style=3D"color: rgb(32, 33, 36); font-family: Segoe U=
I; font-size: 16px; font-style: normal; font-variant-ligatures: normal; fon=
t-variant-caps: normal; letter-spacing: normal; orphans: 2; text-align: lef=
t; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; =
word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thicknes=
s: initial; text-decoration-style: initial; text-decoration-color: initial;=
 background-color: rgb(255, 255, 255)">table<span style=3D"color: rgb(3=
2, 33, 36); font-family: Segoe UI; font-size: 16px; font-style: normal; fon=
t-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; l=
etter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text=
-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webki=
t-text-stroke-width: 0px; text-decoration-thickness: initial; text-decorati=
on-style: initial; text-decoration-color: initial; display: inline !importa=
nt; float: none; background-color: rgb(255, 255, 255)">&nbsp;or
list of data quickly and accurately.</td>
<td width=3D"16" valign=3D"top" style=3D"width:12.25pt;border:none;border-r=
ight:solid #ED7C30 3.0pt;
padding:0cm 5.4pt 0cm 5.4pt">
&nbsp;</td>
<td width=3D"286" colspan=3D"2" rowspan=3D"4" valign=3D"top" style=3D"width=
: 214.55pt; border-left: medium none; border-right: 3.0pt solid #ED7C30; bo=
rder-top: 3.0pt solid #ED7C30; border-bottom: medium none; padding-left: 5.=
4pt; padding-right: 5.4pt; padding-top: 0cm; padding-bottom: 0cm">


&nbsp;


=B7&nbsp;&nbsp;&nbsp;


21 - 22 December 
2020


Online Session

(9am-1pm)


RM750


&nbsp;</td>
</tr>
<tr>
<td width=3D"16" valign=3D"top" style=3D"width:12.25pt;border:none;border-r=
ight:solid #ED7C30 3.0pt;
padding:0cm 5.4pt 0cm 5.4pt">
&nbsp;</td>
</tr>
<tr>
<td width=3D"16" valign=3D"top" style=3D"width:12.25pt;border:none;border-r=
ight:solid #ED7C30 3.0pt;
padding:0cm 5.4pt 0cm 5.4pt">
&nbsp;</td>
</tr>
<tr>
<td width=3D"16" valign=3D"top" style=3D"width:12.25pt;border:none;border-r=
ight:solid #ED7C30 3.0pt;
padding:0cm 5.4pt 0cm 5.4pt">
&nbsp;</td>
</tr>
<tr>
<td width=3D"16" valign=3D"top" style=3D"width:12.25pt;padding:0cm 5.4pt 0c=
m 5.4pt">
&nbsp;</td>
<td width=3D"286" colspan=3D"2" valign=3D"top" style=3D"width:214.55pt;bord=
er-top:solid #ED7C30 3.0pt;
border-left:none;border-bottom:solid #ED7C30 3.0pt;border-right:none;
padding:0cm 5.4pt 0cm 5.4pt">
&nbsp;</td>
</tr>
<tr>
<td width=3D"16" valign=3D"top" style=3D"width:12.25pt;padding:0cm 5.4pt 0c=
m 5.4pt">
&nbsp;</td>
<td width=3D"286" colspan=3D"2" valign=3D"top" style=3D"width: 214.55pt; bo=
rder: medium none; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: =
0cm; padding-bottom: 0cm">
&nbsp;</td>
</tr>
<tr style=3D"height: 386.1pt">
<td width=3D"16" valign=3D"top" style=3D"width: 12.25pt; height: 447px; pad=
ding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; padding-bottom: 0=
cm">
&nbsp;</td>
<td width=3D"286" colspan=3D"2" valign=3D"top" style=3D"width: 214.55pt; he=
ight: 447px; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; p=
adding-bottom: 0cm; background: #FA9976">
Outline

 
Vlookup Function 
Introduction to the VLOOKUP

Troubleshooting Vlookup Problems 
Formatting Data, Removing Hidden Characters in Data 
Using Vlookup in a Dynamic Range 
Using named Formulas, Using Tables

Alternatives to Vlookup 
CHOOSE Function, INDEX Function, MATCH Function, OFFSET Function

Vlookup Tips &amp; Tricks 
Getting VLOOKUP to pick the latest

-----------------------------------------------------------------------

Pivot Table Fundamentals 
Using Pivot Table Tools 
Customizing Fields in a Pivot Table 
Calculations in Pivot Tables 
Creating and Using Pivot Charts 


Controlling What's Viewed in a Pivot Table 
Using Disparate
Data Sources in a Pivot Table 
Data Preparation
&nbsp;</td>
</tr>
<tr style=3D"height: 29.25pt">
<td width=3D"668" colspan=3D"6" valign=3D"top" style=3D"width: 501.3pt; hei=
ght: 158px; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; pa=
dding-bottom: 0cm">
&nbsp;
&nbsp;

For more details on
REGISTRATION, trainer and course fees:</td>
</tr>
<tr style=3D"height: 19.55pt">
<td width=3D"668" colspan=3D"6" style=3D"width: 501.3pt; height: 19.55pt; b=
order-left: medium none; border-right: medium none; border-top: medium none=
; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right=
: 5.4pt; padding-top: 0cm; padding-bottom: 0cm">
<a name=3D"_Hlk55472164">
|&nbsp;&nbsp; Contact</a>
us by replying to this email&nbsp;&nbsp; | 03-22014622 | comsystem@comsystemsolutions=
.com</td>
</tr>
<tr style=3D"height: 19.55pt">
td width=3D"668" colspan=3D"6" style=3D"width: 501.3pt; height: 19.55pt; bo=
rder-left: medium none; border-right: medium none; border-top: medium none;=
 border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right:=
 5.4pt; padding-top: 0cm; padding-bottom: 0cm">
To Unsubscribe reply with REMOVE as Subject</td>
</tr>
<tr style=3D"height: 18.65pt">
<td width=3D"668" colspan=3D"6" style=3D"width: 501.3pt; height: 18.65pt; b=
order: medium none; padding-left: 5.4pt; padding-right: 5.4pt; padding-top:=
 0cm; padding-bottom: 0cm">
&nbsp;</td>
</tr>
</table>
</div>

</html>