관리-도구

편집 파일: 1637591111.M303496P24902.server.saraya-global.com,S=21259,W=21791:2,

Envelope-to: hans@saraya.com.my
Delivery-date: Mon, 22 Nov 2021 22:25:11 +0800
Date: Mon, 22 Nov 2021 22:24:19 +0800
Mime-version: 1.0
Subject: [Info] Training Pandemic Promo
From: Training Course <elena@relaycss.com>
To: <hans@saraya.com.my>
Message-Id: <11222224.KFFQDIAP@relaycss.com>
Reply-To: comsystem@comsystemsolutions.com
Content-Type: text/html; charset="ISO-8859-1"
Content-transfer-encoding: quoted-printable

<HTML>

<body>

<div align=3D"center">
<table class=3D"MsoNormalTable" border=3D"0" cellspacing=3D"0" cellpadding=
=3D"0" width=3D"600" style=3D"width: 450=2E0pt; background: white">
<tr>
<td style=3D"padding:7=2E5pt 7=2E5pt 7=2E5pt 7=2E5pt">
<div align=3D"center">
<table class=3D"MsoNormalTable" border=3D"0" cellspacing=3D"0" cellpadding=
=3D"0" width=3D"600" style=3D"width: 450=2E0pt; background: gainsboro">
<tr style=3D"height: 72=2E0pt">
<td width=3D"600" style=3D"width: 450=2E0pt; height: 72=2E0pt; padding: 7=2E5pt; =
background: #ED1C24">

<span style=3D"font-size:14=2E0pt;font-family:&quot;Verdana&quot;,sans-serif;=

color:yellow">Confirm Training - Year End Promo

<span style=3D"font-size:24=2E0pt;font-family:&quot;Verdana&quot;,sans-serif;=

color:white">NOVEMBER &amp; DECEMBER 2021


(ONLINE-ZOOM SHORT COURSES)</td>
</tr>
<tr style=3D"height: 21=2E0pt">
<td style=3D"height: 21=2E0pt; padding: 7=2E5pt; background: black">


Excel Day 1 &amp; 2 (Intermediate), Day 3 &amp; 4 (Advanced) -
RM50


13,14, 20,
21 December 2021&nbsp; Online-Zoom (7pm-9pm)=

<blockquote>
<ul>
<li>


=B7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

COUNTIF / COUNTIFS&nbsp;&nbsp;&nbsp; </li>
<li>


=B7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

SUMIF / SUMIFS</li>
<li>


=B7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

VLOOKUP</li>
<li>


=B7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

CHARTS, SPARKLINES</li>
<li>


=B7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

PIVOT TABLE, PIVOT CHARTS, 
</li>
<li>


=B7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

SLICER</li>
<li>


=B7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

CREATE DROP DOWN LIST</li>
<li>


=B7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

DATE FUNCTION</li>
<li>


=B7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

CONDITIONAL FORMATING</li>
<li>


=B7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

SECURING YOUR DATA &amp; FILE</li>
<li>


=B7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
IF
FUNCTION</li>
<li>


=B7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
OR
&amp; AND FUNCTION</li>
</ul>
</blockquote>
&nbsp;</td>
</tr>
<tr>
<td style=3D"padding:7=2E5pt 7=2E5pt 7=2E5pt 7=2E5pt">


&nbsp;</td>
</tr>
<tr>
<td style=3D"padding: 7=2E5pt; background: black">


Powerquery Day 1- Day 4 RM100


Date: 8,9,15,16 December 2021 Online Zoom 7pm-9pm
&nbsp;
<ul>
<li>


Append Multiple Files into 1 File</li>
<li>


Append Multiple Sheets into 1 File</li>
<li>


Append Multiple Files with Multiple Sheets into 1
File</li>
<li>


Append Multiple format files into 1 file</li>
<li>

Split
&amp; Merging Column, </li>
<li>


Handling Blank Cells,Row or Column</li>
<li>


Extract Data, Transpose techniques</li>
<li>


Merging Files, VLOOKUP alternative in PQ</li>
<li>


Unpivot/Pivot Column, Conditional Column</li>
<li>

Date
calculations, Grouping in PQ</li>
<li>


Cleaning Data, Remove spaces in Data</li>
<li>


Transforming Non-Delimited Files</li>
<li>


Aggregrate Data</li>
</ul>
</td>
</tr>
<tr>
<td style=3D"padding:7=2E5pt 7=2E5pt 7=2E5pt 7=2E5pt">


&nbsp;</td>
</tr>
<tr>
<td style=3D"padding: 7=2E5pt; background: black">


Excel Dashboard Day 1 - Day 4 RM100


11,12,18,19 December 2021, Online-Zoom 2=2E30pm-5=2E30pm
<ul>
<li>


Introduction</li>
<li>


Dashboard Checklist</li>
<li>

Color
Palettes</li>
<li>


Functions Used : COUNTIF(S)</li>
<li>

SUMIF(S),
IF, IFERROR</li>
<li>

DATE,
MIN, MAX</li>
<li>


INDEX/MATCH, LARGE, SUM</li>
<li>

Charts :
Gauge Charts</li>
<li>

Line
Charts</li>
<li>


Overlapping Charts</li>
<li>

Elements
on Dashboard :</li>
<li>


Conditional Formatting</li>
<li>

Slider
on Charts</li>
<li>

Checkbox
on Charts</li>
<li>

List Box
with Charts</li>
</ul>

<span style=3D"font-size:10=2E0pt;font-family:&quot;Verdana&quot;,sans-serif;=

color:lime">&nbsp;</td>
</tr>
<tr>
<td style=3D"padding:7=2E5pt 7=2E5pt 7=2E5pt 7=2E5pt">


&nbsp;</td>
</tr>
<tr>
<td style=3D"padding: 7=2E5pt; background: whitesmoke">&nbsp;</td>
</tr>
<tr>
<td style=3D"padding:7=2E5pt 7=2E5pt 7=2E5pt 7=2E5pt">

This
courses are adhoc and conducted during pandemic ONLY=2E
Kindly take note, this are not HRDF claimable 


STEPS to
REGISTER

1=2E Furnish
below for us to invoice

&nbsp;a)
Company name 
&nbsp;b) Participants Name

2=2E We will
send invoice

3=2E Once
payment is in, we will furnish the telegram link,
whereby participants have to join in=2E Zoom link will be
shared there=2E Payment is required prior to class=

4=2E Upon
completion of class, recording &amp; certs will be provided
in telegram link=2E If you are unable to attend &amp; have&nbsp;
registered, we will share recording

Please call us for
more information or BROCHURE<span style=3D"font-size:9=2E0pt;=

font-family:&quot;Georgia&quot;,serif;color:#666666"> 

<span style=3D"font-size:10=2E0pt;font-family:&quot;Verdana&quot;,sans-serif;=

color:black">Tel: 0126290703 (Ms Maler), 03-22014622 Whatsap is welcomed</s=
pan>


<a href=3D"mailto:comsystem@comsystemsolutions=2Ecom">
comsystem@comsystemsolutions=2Ecom</a>

COMSYSTEM SOLUTIONS SDN BHD

www=2Ecompextrg=2Ecom
&nbsp;

&nbsp;


Note: All this program can be customised for In-House
Training=2E Call us for Proposal</td>
</tr>
<tr>
<td style=3D"padding:7=2E5pt 7=2E5pt 7=2E5pt 7=2E5pt">


If you wish to stop future mailings, or if you feel you
have been wrongfully placed in our mailinglist, please
reply the email by saying 

UNSUBSCRIBE=2E
We will discontinue the email&nbsp;&nbsp;</td>
</tr>
</table>
</div>
</td>
</tr>
</table>
</div>

</body>

</html>