관리-도구

편집 파일: 1627873381.M473372P28976.server.saraya-global.com,S=73964,W=74969:2,

Envelope-to: jaisone@saraya.com.my
Delivery-date: Mon, 02 Aug 2021 11:03:01 +0800
From: "(Online) Data Analysis and Interactive Dashboard Reporting In Excel 2016" <nurul@rk-rakan.com> 
To: "jaisone@saraya.com.my" <jaisone@saraya.com.my>
Date: Mon, 02 Aug 2021 11:01:47 +0800
MIME-Version: 1.0
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Sender: newsletter@enewsletter2.com
Message-ID: <EQSVR00227b74a9c41e24221b1c1488f56d1b75b@EQSVR002>
Subject:  ***SPAM***  (Online) Data Analysis and Interactive Dashboard Reporting In Excel 2016

<html><=21-- pic/eqtoblank=2Egif?id=3D107658774 --> <table> <td> <img alt=
=3D=27=27 src=3D=27http://www=2EeNewsletter2=2Ecom/pic/eqtoblank=2Egif?id=
=3D107658774=27 /> </td></table><html><html><html><html><html><html><html=
><html><html><html><html>=0D=0A     <html>=0D=0A         <html>=0D=0A    =
         <html>=0D=0A                 <html>=0D=0A                     <h=
tml>=0D=0A                         <html>=0D=0A                          =
   <html>=0D=0A                                 <html>=0D=0A             =
                        <html>=0D=0A                                     =
    <html>=0D=0A                                             <html>=0D=0A=
                                                 <html>=0D=0A            =
                                         <html>=0D=0A                    =
                                     <html>=0D=0A                        =
                                     <html><head>=0D=0A                  =
                                                   <title>Big Berry Newsl=
etter </title>=0D=0A                                                     =
            </head><body bgcolor=3D=22=23ffffff=22>=0D=0A                =
                                                     <div align=3D=22cent=
er=22>=0D=0A                                                             =
        <table style=3D=22width: 600px; height: auto; font-family: Georgi=
a, =26quot;Times New Roman=26quot;, Times, serif; font-size: 12px;=22 cel=
lspacing=3D=220=22 cellpadding=3D=2210=22 border=3D=220=22 bgcolor=3D=22=23=
ffffff=22 align=3D=22center=22>=0D=0A                                    =
                                     <tbody>=0D=0A                       =
                                                      <=21--img src=3D=22=
images/header=2Ejpg=22 alt=3D=22=22 /-->=0D=0A                           =
                                                  <tr>=0D=0A             =
                                                                    <td>=0D=
=0A                                                                      =
           <table style=3D=22width: 600px; height: 636px; font-family: Ge=
orgia, =27Times New Roman=27, Times, serif; font-size: 12px;=22 cellspaci=
ng=3D=220=22 cellpadding=3D=2210=22 border=3D=220=22 bgcolor=3D=22=23ffff=
ff=22 align=3D=22center=22>=0D=0A                                        =
                                             <tbody>=0D=0A               =
                                                                         =
 <tr>=0D=0A                                                              =
                               <td style=3D=22padding:0px;=22>=0D=0A     =
                                                                         =
               <div>=0D=0A                                               =
                                              <=21-- Image Map Generated =
by http://www=2Eimage-map=2Enet/ -->=0D=0A                               =
                                                              <img src=3D=
=22http://bigberry=2Ew3rider=2Ecom/images/header=2Ejpg=22 usemap=3D=22=23=
image-map=22 alt=3D=22=22 />=0D=0A                                       =
                                                      <map name=3D=22imag=
e-map=22>=0D=0A                                                          =
                                   <area target=3D=22_blank=22 alt=3D=22b=
igberry=22 title=3D=22bigberry=22 href=3D=22http://bigberryconsulting=2Ec=
om/=22 coords=3D=227,6,266,129=22 shape=3D=22rect=22 />=0D=0A            =
                                                                         =
        <area target=3D=22_blank=22 alt=3D=22facebook=22 title=3D=22faceb=
ook=22 href=3D=22https://www=2Efacebook=2Ecom/BigBerryCnsltng/=22 coords=3D=
=22454,71,19=22 shape=3D=22circle=22 />=0D=0A                            =
                                                                 <area ta=
rget=3D=22_blank=22 alt=3D=22instagram=22 title=3D=22instagram=22 href=3D=
=22https://www=2Einstagram=2Ecom/big=2Eberry=2Econsulting/=22 coords=3D=22=
507,71,20=22 shape=3D=22circle=22 />=0D=0A                               =
                                                              <area targe=
t=3D=22_blank=22 alt=3D=22twitter=22 title=3D=22twitter=22 href=3D=22http=
s://twitter=2Ecom/BigBerryCnsltng=22 coords=3D=22558,71,20=22 shape=3D=22=
circle=22 />=0D=0A                                                       =
                                      <area target=3D=22_blank=22 alt=3D=22=
linkedin=22 title=3D=22linkedin=22 href=3D=22https://www=2Elinkedin=2Ecom=
/company/big-berry-consulting-sdn-bhd?trk=3Dtop_nav_home=22 coords=3D=226=
11,71,21=22 shape=3D=22circle=22 />=0D=0A                                =
                                                             </map>=0D=0A=
                                                                         =
                    </div>=0D=0A                                         =
                                                    </td>=0D=0A          =
                                                                         =
      </tr>=0D=0A                                                        =
                                 <tr style=3D=22background-color: white;=22=
>=0D=0A                                                                  =
                           <td style=3D=22width: 600px; height: 96px; col=
or: =23333333; font-family: Georgia, =26quot;Times New Roman=26quot;, Tim=
es, serif; font-size: 28px; background-color: =23ed1c24;=22>=0D=0A       =
                                                                         =
             <div>=0D=0A                                                 =
                                            <div><span style=3D=22font-fa=
mily: Verdana;=22><strong></strong></span></div>=0D=0A                   =
                                                                         =
 <div><span style=3D=22font-family: Verdana; color: =23ffffff;=22><strong=
>DATA ANALYSIS AND INTERACTIVE </strong></span><span style=3D=22font-fami=
ly: Verdana; color: =23ffff00; font-size: 26pt;=22><strong><em>DASHBOARD =
REPORTING </em></strong></span></div>=0D=0A                              =
                                                               <div><span=
 style=3D=22font-family: Verdana; color: =23ffffff;=22><strong>IN EXCEL 2=
016</strong></span></div>=0D=0A                                          =
                                                   </div>=0D=0A          =
                                                                         =
          </td>=0D=0A                                                    =
                                     </tr>=0D=0A                         =
                                                                <tr style=
=3D=22background-color: =23000000;=22>=0D=0A                             =
                                                                <td style=
=3D=22height: 28px; color: =23333333; font-family: Georgia, =26quot;Times=
 New Roman=26quot;, Times, serif; font-size: 28px;=22>=0D=0A             =
                                                                         =
       <div><span style=3D=22color: =23ffff00; font-size: 18pt;=22><span =
style=3D=22color: =23ffff00; font-size: 18pt;=22><strong><span style=3D=22=
font-family: Arial; font-size: 12pt;=22>13 =26amp; 14 SEPTEMBER 2021, ONL=
INE (ZOOM) 9AM - 5PM=26nbsp;</span></strong></span></span><div><span styl=
e=3D=22color: =23ffffff;=22>HRDF Claimable</span></div>=0D=0A            =
                                                                         =
        </div>=0D=0A                                                     =
                                        </td>=0D=0A                      =
                                                                   </tr>=0D=
=0A                                                                      =
                   <tr>=0D=0A                                            =
                                                 <td><span style=3D=22col=
or: =23000000; font-family: verdana, geneva; font-size: 10pt;=22></span>=0D=
=0A                                                                      =
                       <div><span style=3D=22color: black; line-height: 1=
07=25; font-family: Verdana, sans-serif; font-size: 10pt;=22></span>=0D=0A=
                                                                         =
                    <div><span style=3D=22font-size: 13=2E3333px; font-fa=
mily: Verdana; color: =23000000;=22></span></div>=0D=0A                  =
                                                                         =
  <div style=3D=22text-align: justify; =22><span style=3D=22font-family: =
Verdana; font-size: 10pt; color: =23000000;=22>Microsoft Excel is one of =
the most powerful and popular data analysis desktop application on the ma=
rket today=2E By participating in this Microsoft Excel Data Analysis and =
Dashboard Reporting course you=27ll gain the widely sought after skills n=
ecessary to effectively analyze large sets of data=2E Once the data has b=
een analyzed, clean and prepared for presentation, you will learn how to =
present the data in an interactive dashboard report=2E=26nbsp;</span></di=
v>=0D=0A                                                                 =
                            <strong style=3D=22color: =23666666;=22><br /=
>=0D=0A                                                                  =
                           <span style=3D=22font-family: verdana, geneva;=
 color: =23ff0000; font-size: small;=22>PROGRAM OBJECTIVES</span><span st=
yle=3D=22font-family: verdana, geneva; color: =23000000; font-size: small=
;=22><br />=0D=0A                                                        =
                                     </span></strong></div>=0D=0A        =
                                                                         =
            <div>=0D=0A                                                  =
                                           <div></div>=0D=0A             =
                                                                         =
       <div><span style=3D=22font-family: Verdana; font-size: 10pt;=22><s=
trong>After completing this course, students will be able to=26nbsp;</str=
ong></span></div>=0D=0A                                                  =
                                           <div><span style=3D=22font-fam=
ily: Verdana; font-size: 10pt;=22>=26=238226;</span><span style=3D=22whit=
e-space:pre=22>=09</span><span style=3D=22font-family: Verdana; font-size=
: 10pt;=22>Manage database effectively=2E=26nbsp;</span></div>=0D=0A     =
                                                                         =
               <div><span style=3D=22font-family: Verdana; font-size: 10p=
t;=22>=26=238226;</span><span style=3D=22white-space:pre=22>=09</span><sp=
an style=3D=22font-family: Verdana; font-size: 10pt;=22>Apply proper form=
ula and function=2E=26nbsp;</span></div>=0D=0A                           =
                                                                  <div><s=
pan style=3D=22font-family: Verdana; font-size: 10pt;=22>=26=238226;</spa=
n><span style=3D=22white-space:pre=22>=09</span><span style=3D=22font-fam=
ily: Verdana; font-size: 10pt;=22>Troubleshooting errors=26nbsp;</span></=
div>=0D=0A                                                               =
                              <div><span style=3D=22font-family: Verdana;=
 font-size: 10pt;=22>=26=238226;</span><span style=3D=22white-space:pre=22=
>=09</span><span style=3D=22font-family: Verdana; font-size: 10pt;=22>Lin=
k and Embed Data from other sources=2E=26nbsp;</span></div>=0D=0A        =
                                                                         =
            <div><span style=3D=22font-family: Verdana; font-size: 10pt;=22=
>=26=238226;</span><span style=3D=22white-space:pre=22>=09</span><span st=
yle=3D=22font-family: Verdana; font-size: 10pt;=22>Applying Conditional F=
ormatting and Validation Rules=26nbsp;</span></div>=0D=0A                =
                                                                         =
    <div><span style=3D=22font-family: Verdana; font-size: 10pt;=22>=26=23=
8226;</span><span style=3D=22white-space:pre=22>=09</span><span style=3D=22=
font-family: Verdana; font-size: 10pt;=22>Advanced Analytics Tools</span>=
</div>=0D=0A                                                             =
                                <div><span style=3D=22font-family: Verdan=
a; font-size: 10pt;=22>=26=238226;</span><span style=3D=22white-space:pre=
=22>=09</span><span style=3D=22font-family: Verdana; font-size: 10pt;=22>=
Interactive Dashboard Reporting</span></div>=0D=0A                       =
                                                                      <di=
v><span style=3D=22font-family: Verdana; font-size: 10pt;=22></span></div=
>=0D=0A                                                                  =
                           <div style=3D=22font-family: verdana, geneva; =
font-size: small;=22></div>=0D=0A                                        =
                                                     </div>=0D=0A        =
                                                                         =
            <div style=3D=22color: =23666666;=22>=26nbsp;</div>=0D=0A    =
                                                                         =
                <div><span style=3D=22font-family: verdana, geneva; font-=
size: small; color: =23000000;=22><strong>PROGRAM OUTLINE</strong></span>=
</div>=0D=0A                                                             =
                                <div><span style=3D=22font-family: Verdan=
a; color: =23000000; font-size: 10pt;=22><strong>DAY 1=26nbsp;</strong></=
span></div>=0D=0A                                                        =
                                     <div><span style=3D=22font-family: V=
erdana; font-size: 10pt; color: =23000000;=22><strong></strong></span></d=
iv>=0D=0A                                                                =
                             <div><span style=3D=22font-family: Verdana; =
color: =23000000; font-size: 10pt;=22><strong>LESSON 1: CUSTOMIZING THE E=
XCEL ENVIRONMENT=26nbsp;</strong>=26nbsp;</span></div>=0D=0A             =
                                                                         =
       <div><span style=3D=22font-family: Verdana; color: =23000000; font=
-size: 10pt;=22>=26=238226;</span><span style=3D=22white-space:pre=22>=09=
</span><span style=3D=22font-family: Verdana; color: =23000000; font-size=
: 10pt;=22>Configure Excel Options=26nbsp;=26nbsp;</span></div>=0D=0A    =
                                                                         =
                <div><span style=3D=22font-family: Verdana; color: =23000=
000; font-size: 10pt;=22>=26=238226;</span><span style=3D=22white-space:p=
re=22>=09</span><span style=3D=22font-family: Verdana; color: =23000000; =
font-size: 10pt;=22>Customize the Ribbon and the Quick Access Toolbar=26n=
bsp;=26nbsp;</span></div>=0D=0A                                          =
                                                   <div><span style=3D=22=
font-family: Verdana; color: =23000000; font-size: 10pt;=22>=26=238226;</=
span><span style=3D=22white-space:pre=22>=09</span><span style=3D=22font-=
family: Verdana; color: =23000000; font-size: 10pt;=22>Enable Excel Add-I=
ns=26nbsp;=26nbsp;</span></div>=0D=0A                                    =
                                                         <div><br />=0D=0A=
                                                                         =
                    </div>=0D=0A                                         =
                                                    <div><span style=3D=22=
font-family: Verdana; color: =23000000; font-size: 10pt;=22><strong>LESSO=
N 2: KICK START WITH INTERMEDIATE TO ADVANCE FORMULA AND FUNCTIONS=26nbsp=
;</strong></span></div>=0D=0A                                            =
                                                 <div><span style=3D=22fo=
nt-family: Verdana; color: =23000000; font-size: 10pt;=22>=26=238226;</sp=
an><span style=3D=22white-space:pre=22>=09</span><span style=3D=22font-fa=
mily: Verdana; color: =23000000; font-size: 10pt;=22>Use Array Formulas=26=
nbsp;=26nbsp;</span></div>=0D=0A                                         =
                                                    <div><span style=3D=22=
font-family: Verdana; color: =23000000; font-size: 10pt;=22>=26=238226;</=
span><span style=3D=22white-space:pre=22>=09</span><span style=3D=22font-=
family: Verdana; color: =23000000; font-size: 10pt;=22>Use Range Names in=
 Formulas=26nbsp;=26nbsp;</span></div>=0D=0A                             =
                                                                <div><spa=
n style=3D=22font-family: Verdana; color: =23000000; font-size: 10pt;=22>=
=26=238226;</span><span style=3D=22white-space:pre=22>=09</span><span sty=
le=3D=22font-family: Verdana; color: =23000000; font-size: 10pt;=22>Use S=
pecialized Functions=26nbsp;=26nbsp;</span></div>=0D=0A                  =
                                                                         =
  <div><span style=3D=22font-family: Verdana; color: =23000000; font-size=
: 10pt;=22><strong>Building=26nbsp; Formulas=26nbsp;</strong></span></div=
>=0D=0A                                                                  =
                           <div><strong><span style=3D=22font-family: Ver=
dana; color: =23000000; font-size: 10pt;=22>=26=238226;</span><span style=
=3D=22white-space:pre=22>=09</span></strong><span style=3D=22font-family:=
 Verdana; color: =23000000; font-size: 10pt;=22><strong>Functions=26nbsp;=
</strong>=26nbsp;</span></div>=0D=0A                                     =
                                                        <div><span style=3D=
=22font-family: Verdana; color: =23000000; font-size: 10pt;=22>=EF=82=A7<=
/span><span style=3D=22white-space:pre=22>=09</span><span style=3D=22font=
-family: Verdana; color: =23000000; font-size: 10pt;=22>Using a Function =
in a Formula=26nbsp;=26nbsp;</span></div>=0D=0A                          =
                                                                   <div><=
span style=3D=22font-family: Verdana; color: =23000000; font-size: 10pt;=22=
>=EF=82=A7</span><span style=3D=22white-space:pre=22>=09</span><span styl=
e=3D=22font-family: Verdana; color: =23000000; font-size: 10pt;=22>Using =
Cell References with a Function=26nbsp;=26nbsp;</span></div>=0D=0A       =
                                                                         =
             <div><span style=3D=22font-family: Verdana; color: =23000000=
; font-size: 10pt;=22>=EF=82=A7</span><span style=3D=22white-space:pre=22=
>=09</span><span style=3D=22font-family: Verdana; color: =23000000; font-=
size: 10pt;=22>Using Cell Ranges with a Function=26nbsp;=26nbsp;</span></=
div>=0D=0A                                                               =
                              <div><span style=3D=22font-family: Verdana;=
 color: =23000000; font-size: 10pt;=22>=EF=82=A7</span><span style=3D=22w=
hite-space:pre=22>=09</span><span style=3D=22font-family: Verdana; color:=
 =23000000; font-size: 10pt;=22>Excel Compatibility Functions=26nbsp; =26=
nbsp;</span></div>=0D=0A                                                 =
                                            <div><strong><span style=3D=22=
font-family: Verdana; color: =23000000; font-size: 10pt;=22>=26=238226;</=
span><span style=3D=22white-space:pre=22>=09</span><span style=3D=22font-=
family: Verdana; color: =23000000; font-size: 10pt;=22>Formula Errors=26n=
bsp;=26nbsp;</span></strong></div>=0D=0A                                 =
                                                            <div><strong>=
<span style=3D=22font-family: Verdana; color: =23000000; font-size: 10pt;=
=22>=26=238226;</span><span style=3D=22white-space:pre=22>=09</span><span=
 style=3D=22font-family: Verdana; color: =23000000; font-size: 10pt;=22>L=
ogical Operators=26nbsp;</span></strong></div>=0D=0A                     =
                                                                        <=
div><strong><span style=3D=22font-family: Verdana; color: =23000000; font=
-size: 10pt;=22>=26=238226;</span><span style=3D=22white-space:pre=22>=09=
</span><span style=3D=22font-family: Verdana; color: =23000000; font-size=
: 10pt;=22>Formula Shortcuts=26nbsp;=26nbsp;</span></strong></div>=0D=0A =
                                                                         =
                   <div><span style=3D=22font-family: Verdana; color: =23=
000000; font-size: 10pt;=22>=EF=82=A7</span><span style=3D=22white-space:=
pre=22>=09</span><span style=3D=22font-family: Verdana; color: =23000000;=
 font-size: 10pt;=22>Point-and-Click Formula Creation=26nbsp;=26nbsp;</sp=
an></div>=0D=0A                                                          =
                                   <div><span style=3D=22font-family: Ver=
dana; color: =23000000; font-size: 10pt;=22>=EF=82=A7</span><span style=3D=
=22white-space:pre=22>=09</span><span style=3D=22font-family: Verdana; co=
lor: =23000000; font-size: 10pt;=22>Point-and-Click Formula Editing=26nbs=
p;=26nbsp;</span></div>=0D=0A                                            =
                                                 <div><span style=3D=22fo=
nt-family: Verdana; color: =23000000; font-size: 10pt;=22>=EF=82=A7</span=
><span style=3D=22white-space:pre=22>=09</span><span style=3D=22font-fami=
ly: Verdana; color: =23000000; font-size: 10pt;=22>The Formulas Tab=2E=26=
nbsp;=26nbsp;</span></div>=0D=0A                                         =
                                                    <div><span style=3D=22=
font-family: Verdana; color: =23000000; font-size: 10pt;=22>=EF=82=A7</sp=
an><span style=3D=22white-space:pre=22>=09</span><span style=3D=22font-fa=
mily: Verdana; color: =23000000; font-size: 10pt;=22>Using the Insert Fun=
ction Button=26nbsp; =26nbsp;</span></div>=0D=0A                         =
                                                                    <div>=
<strong><span style=3D=22font-family: Verdana; color: =23000000; font-siz=
e: 10pt;=22>=26=238226;</span><span style=3D=22white-space: pre;=22>=09</=
span><span style=3D=22font-family: Verdana; color: =23000000; font-size: =
10pt;=22>Referencing in Formulas=26nbsp;=26nbsp;</span></strong></div>=0D=
=0A                                                                      =
                       <div><span style=3D=22font-family: Verdana; color:=
 =23000000; font-size: 10pt;=22>=EF=82=A7</span><span style=3D=22white-sp=
ace:pre=22>=09</span><span style=3D=22font-family: Verdana; color: =23000=
000; font-size: 10pt;=22>Absolute Cell References=26nbsp;</span></div>=0D=
=0A                                                                      =
                       <div><span style=3D=22font-family: Verdana; color:=
 =23000000; font-size: 10pt;=22>=EF=82=A7</span><span style=3D=22white-sp=
ace:pre=22>=09</span><span style=3D=22font-family: Verdana; color: =23000=
000; font-size: 10pt;=22>Partially Fixed References=26nbsp;=26nbsp;</span=
></div>=0D=0A                                                            =
                                 <div><span style=3D=22font-family: Verda=
na; color: =23000000; font-size: 10pt;=22>=EF=82=A7</span><span style=3D=22=
white-space:pre=22>=09</span><span style=3D=22font-family: Verdana; color=
: =23000000; font-size: 10pt;=22>Referring to Other Worksheets=26nbsp;=26=
nbsp;</span></div>=0D=0A                                                 =
                                            <div><span style=3D=22font-fa=
mily: Verdana; color: =23000000; font-size: 10pt;=22>=EF=82=A7</span><spa=
n style=3D=22white-space:pre=22>=09</span><span style=3D=22font-family: V=
erdana; color: =23000000; font-size: 10pt;=22>Referring to Other Workbook=
s=26nbsp;=26nbsp;</span></div>=0D=0A                                     =
                                                        <div><span style=3D=
=22font-family: Verdana; color: =23000000; font-size: 10pt;=22><strong>Lo=
okup, Reference, and Information Functions=26nbsp;=26nbsp;</strong></span=
></div>=0D=0A                                                            =
                                 <div><strong><span style=3D=22font-famil=
y: Verdana; color: =23000000; font-size: 10pt;=22>=26=238226;</span><span=
 style=3D=22white-space:pre=22>=09</span><span style=3D=22font-family: Ve=
rdana; color: =23000000; font-size: 10pt;=22>The Basic Lookup=26nbsp;=26n=
bsp;</span></strong></div>=0D=0A                                         =
                                                    <div><strong><span st=
yle=3D=22font-family: Verdana; color: =23000000; font-size: 10pt;=22>=26=23=
8226;</span><span style=3D=22white-space:pre=22>=09</span><span style=3D=22=
font-family: Verdana; color: =23000000; font-size: 10pt;=22>VLOOKUP(): Ve=
rtical Lookups=26nbsp;=26nbsp;</span></strong></div>=0D=0A               =
                                                                         =
     <div><strong><span style=3D=22font-family: Verdana; color: =23000000=
; font-size: 10pt;=22>=26=238226;</span><span style=3D=22white-space:pre=22=
>=09</span><span style=3D=22font-family: Verdana; color: =23000000; font-=
size: 10pt;=22>HLOOKUP(): Horizontal Lookups=26nbsp;=26nbsp;</span></stro=
ng></div>=0D=0A                                                          =
                                   <div><strong><span style=3D=22font-fam=
ily: Verdana; color: =23000000; font-size: 10pt;=22>=26=238226;</span><sp=
an style=3D=22white-space:pre=22>=09</span><span style=3D=22font-family: =
Verdana; color: =23000000; font-size: 10pt;=22>Advanced Lookups=26nbsp;=26=
nbsp;</span></strong></div>=0D=0A                                        =
                                                     <div><span style=3D=22=
font-family: Verdana; color: =23000000; font-size: 10pt;=22>=EF=82=A7</sp=
an><span style=3D=22white-space:pre=22>=09</span><span style=3D=22font-fa=
mily: Verdana; color: =23000000; font-size: 10pt;=22>MATCH(): Finding the=
 Position of Items in a Range=26nbsp;=26nbsp;</span></div>=0D=0A         =
                                                                         =
           <div><span style=3D=22font-family: Verdana; color: =23000000; =
font-size: 10pt;=22>=EF=82=A7</span><span style=3D=22white-space:pre=22>=09=
</span><span style=3D=22font-family: Verdana; color: =23000000; font-size=
: 10pt;=22>INDEX(): Retrieving the Value from a Cell=26nbsp;=26nbsp;</spa=
n></div>=0D=0A                                                           =
                                  <div><span style=3D=22font-family: Verd=
ana; color: =23000000; font-size: 10pt;=22>=EF=82=A7</span><span style=3D=
=22white-space:pre=22>=09</span><span style=3D=22font-family: Verdana; co=
lor: =23000000; font-size: 10pt;=22>Performing a =26=238220;Left Lookup=26=
=238221;=26nbsp;</span></div>=0D=0A                                      =
                                                       <div><span style=3D=
=22font-family: Verdana; color: =23000000; font-size: 10pt;=22>=EF=82=A7<=
/span><span style=3D=22white-space:pre=22>=09</span><span style=3D=22font=
-family: Verdana; color: =23000000; font-size: 10pt;=22>Performing a Doub=
le Lookup=26nbsp;=26nbsp;</span></div>=0D=0A                             =
                                                                <div><str=
ong><span style=3D=22font-family: Verdana; color: =23000000; font-size: 1=
0pt;=22>=26=238226;</span><span style=3D=22white-space:pre=22>=09</span><=
/strong><span style=3D=22font-family: Verdana; color: =23000000; font-siz=
e: 10pt;=22><strong>Information Functions=26nbsp;</strong>=26nbsp;</span>=
</div>=0D=0A                                                             =
                                <div><span style=3D=22font-family: Verdan=
a; color: =23000000; font-size: 10pt;=22>=EF=82=A7</span><span style=3D=22=
white-space:pre=22>=09</span><span style=3D=22font-family: Verdana; color=
: =23000000; font-size: 10pt;=22>The =26=238220;IS=26=238221; Functions: =
Checking the Value Inside a Cell=26nbsp;=26nbsp;</span></div>=0D=0A      =
                                                                         =
              <div><span style=3D=22font-family: Verdana; color: =2300000=
0; font-size: 10pt;=22>=EF=82=A7</span><span style=3D=22white-space:pre=22=
>=09</span><span style=3D=22font-family: Verdana; color: =23000000; font-=
size: 10pt;=22>IFERROR, IFERR=26nbsp;=26nbsp;</span></div>=0D=0A         =
                                                                         =
           <div><span style=3D=22font-family: Verdana; color: =23000000; =
font-size: 10pt;=22>=EF=82=A7</span><span style=3D=22white-space:pre=22>=09=
</span><span style=3D=22font-family: Verdana; color: =23000000; font-size=
: 10pt;=22>Tutorial: Generating Invoices from a Product Catalog=26nbsp;=26=
nbsp;</span></div>=0D=0A                                                 =
                                            <div><span style=3D=22font-fa=
mily: Verdana; color: =23000000; font-size: 10pt;=22><strong>Manipulating=
 Dates, Times, and Text=26nbsp;=26nbsp;</strong></span></div>=0D=0A      =
                                                                         =
              <div><strong><span style=3D=22font-family: Verdana; color: =
=23000000; font-size: 10pt;=22>=26=238226;</span><span style=3D=22white-s=
pace:pre=22>=09</span><span style=3D=22font-family: Verdana; color: =2300=
0000; font-size: 10pt;=22>Effective Data Housekeeping</span></strong></di=
v>=0D=0A                                                                 =
                            <div><strong><span style=3D=22font-family: Ve=
rdana; color: =23000000; font-size: 10pt;=22>=26=238226;</span><span styl=
e=3D=22white-space:pre=22>=09</span><span style=3D=22font-family: Verdana=
; color: =23000000; font-size: 10pt;=22>Manipulating Data</span></strong>=
</div>=0D=0A                                                             =
                                <div><span style=3D=22font-family: Verdan=
a; color: =23000000; font-size: 10pt;=22>=EF=82=A7</span><span style=3D=22=
white-space:pre=22>=09</span><span style=3D=22font-family: Verdana; color=
: =23000000; font-size: 10pt;=22>CONCATENATE(): Joining Strings of Text T=
ogether=26nbsp;=26nbsp;</span></div>=0D=0A                               =
                                                              <div><span =
style=3D=22font-family: Verdana; color: =23000000; font-size: 10pt;=22>=EF=
=82=A7</span><span style=3D=22white-space:pre=22>=09</span><span style=3D=
=22font-family: Verdana; color: =23000000; font-size: 10pt;=22>LEFT(), MI=
D(), and RIGHT(): Copying Portions of a Text String=26nbsp;=26nbsp;</span=
></div>=0D=0A                                                            =
                                 <div><span style=3D=22font-family: Verda=
na; color: =23000000; font-size: 10pt;=22>=EF=82=A7</span><span style=3D=22=
white-space:pre=22>=09</span><span style=3D=22font-family: Verdana; color=
: =23000000; font-size: 10pt;=22>UPPER(), LOWER(), and PROPER(): Changing=
 Capitalization=26nbsp; =26nbsp;</span></div>=0D=0A                      =
                                                                       <d=
iv><span style=3D=22font-family: Verdana; color: =23000000; font-size: 10=
pt;=22>=26=238226;</span><span style=3D=22white-space:pre=22>=09</span><s=
pan style=3D=22font-family: Verdana; color: =23000000; font-size: 10pt;=22=
>Date and Time Functions=26nbsp;</span></div>=0D=0A                      =
                                                                       <d=
iv><span style=3D=22font-family: Verdana; color: =23000000; font-size: 10=
pt;=22>=EF=82=A7</span><span style=3D=22white-space:pre=22>=09</span><spa=
n style=3D=22font-family: Verdana; color: =23000000; font-size: 10pt;=22>=
TODAY() and NOW(): Inserting the Current Date and Time=26nbsp;=26nbsp;</s=
pan></div>=0D=0A                                                         =
                                    <div><span style=3D=22font-family: Ve=
rdana; color: =23000000; font-size: 10pt;=22>=EF=82=A7</span><span style=3D=
=22white-space:pre=22>=09</span><span style=3D=22font-family: Verdana; co=
lor: =23000000; font-size: 10pt;=22>DAY(), MONTH(), and YEAR(): More Date=
 Calculations=26nbsp;=26nbsp;</span></div>=0D=0A                         =
                                                                    <div>=
<span style=3D=22font-family: Verdana; color: =23000000; font-size: 10pt;=
=22>=EF=82=A7</span><span style=3D=22white-space:pre=22>=09</span><span s=
tyle=3D=22font-family: Verdana; color: =23000000; font-size: 10pt;=22>WEE=
KDAY(): Determining the Day of the Week=26nbsp;</span></div>=0D=0A       =
                                                                         =
             <div><span style=3D=22font-family: Verdana; color: =23000000=
; font-size: 10pt;=22>=EF=82=A7</span><span style=3D=22white-space:pre=22=
>=09</span><span style=3D=22font-family: Verdana; color: =23000000; font-=
size: 10pt;=22>DATEDIF(): Calculating the Difference Between Dates=26nbsp=
;=26nbsp;</span></div>=0D=0A                                             =
                                                <div><span style=3D=22fon=
t-family: Verdana; color: =23000000; font-size: 10pt;=22>=EF=82=A7</span>=
<span style=3D=22white-space:pre=22>=09</span><span style=3D=22font-famil=
y: Verdana; color: =23000000; font-size: 10pt;=22>DAYS360(): Finding Out =
the Number of Days Between Two Dates=26nbsp;=26nbsp;</span></div>=0D=0A  =
                                                                         =
                  <div><span style=3D=22font-family: Verdana; color: =230=
00000; font-size: 10pt;=22>=EF=82=A7</span><span style=3D=22white-space:p=
re=22>=09</span><span style=3D=22font-family: Verdana; color: =23000000; =
font-size: 10pt;=22>YEARFRAC(): Calculating the Percentage of a Year Betw=
een Two Dates=26nbsp;=26nbsp;</span></div>=0D=0A                         =
                                                                    <div>=
<span style=3D=22font-family: Verdana; color: =23000000; font-size: 10pt;=
=22>=EF=82=A7</span><span style=3D=22white-space:pre=22>=09</span><span s=
tyle=3D=22font-family: Verdana; color: =23000000; font-size: 10pt;=22>WEE=
KNUM(): Figuring Out in Which Week a Date Falls=26nbsp; =26nbsp;</span></=
div>=0D=0A                                                               =
                              <div><span style=3D=22font-family: Verdana;=
 color: =23000000; font-size: 10pt;=22><strong>Advanced Formula Writing a=
nd Troubleshooting=26nbsp;</strong></span></div>=0D=0A                   =
                                                                         =
 <div><strong><span style=3D=22font-family: Verdana; color: =23000000; fo=
nt-size: 10pt;=22>=26=238226;</span><span style=3D=22white-space:pre=22>=09=
</span><span style=3D=22font-family: Verdana; color: =23000000; font-size=
: 10pt;=22>Applying Criteria in Formulas=26nbsp;=26nbsp;</span></strong><=
/div>=0D=0A                                                              =
                               <div><span style=3D=22font-family: Verdana=
; color: =23000000; font-size: 10pt;=22>=EF=82=A7</span><span style=3D=22=
white-space:pre=22>=09</span><span style=3D=22font-family: Verdana; color=
: =23000000; font-size: 10pt;=22>COUNTIF(): Counting Only the Cells You S=
pecify=26nbsp;=26nbsp;</span></div>=0D=0A                                =
                                                             <div><span s=
tyle=3D=22font-family: Verdana; color: =23000000; font-size: 10pt;=22>=EF=
=82=A7</span><span style=3D=22white-space:pre=22>=09</span><span style=3D=
=22font-family: Verdana; color: =23000000; font-size: 10pt;=22>SUMIF(): A=
dding Only the Cells You Specify=26nbsp;=26nbsp;</span></div>=0D=0A      =
                                                                         =
              <div><span style=3D=22font-family: Verdana; color: =2300000=
0; font-size: 10pt;=22>=EF=82=A7</span><span style=3D=22white-space:pre=22=
>=09</span><span style=3D=22font-family: Verdana; color: =23000000; font-=
size: 10pt;=22>COUNTIFS() and SUMIFS(): Counting and Summing Using=26nbsp=
;</span></div>=0D=0A                                                     =
                                        <div><span style=3D=22font-family=
: Verdana; color: =23000000; font-size: 10pt;=22>=EF=82=A7</span><span st=
yle=3D=22white-space:pre=22>=09</span><span style=3D=22font-family: Verda=
na; color: =23000000; font-size: 10pt;=22>Multiple Criteria=26nbsp;=26nbs=
p;</span></div>=0D=0A                                                    =
                                         <div><strong><span style=3D=22fo=
nt-family: Verdana; color: =23000000; font-size: 10pt;=22>=26=238226;</sp=
an><span style=3D=22white-space:pre=22>=09</span></strong><span style=3D=22=
font-family: Verdana; color: =23000000; font-size: 10pt;=22><strong>Descr=
iptive Names for Cell References</strong>=26nbsp;=26nbsp;</span></div>=0D=
=0A                                                                      =
                       <div><span style=3D=22font-family: Verdana; color:=
 =23000000; font-size: 10pt;=22>=EF=82=A7</span><span style=3D=22white-sp=
ace:pre=22>=09</span><span style=3D=22font-family: Verdana; color: =23000=
000; font-size: 10pt;=22>Creating and Using a Named Range=26nbsp;=26nbsp;=
</span></div>=0D=0A                                                      =
                                       <div><span style=3D=22font-family:=
 Verdana; color: =23000000; font-size: 10pt;=22>=EF=82=A7</span><span sty=
le=3D=22white-space:pre=22>=09</span><span style=3D=22font-family: Verdan=
a; color: =23000000; font-size: 10pt;=22>Creating Slightly Smarter Named =
Ranges=26nbsp;=26nbsp;</span></div>=0D=0A                                =
                                                             <div><span s=
tyle=3D=22font-family: Verdana; color: =23000000; font-size: 10pt;=22>=EF=
=82=A7</span><span style=3D=22white-space:pre=22>=09</span><span style=3D=
=22font-family: Verdana; color: =23000000; font-size: 10pt;=22>Naming For=
mulas and Constants=26nbsp;=26nbsp;</span></div>=0D=0A                   =
                                                                         =
 <div><span style=3D=22font-family: Verdana; color: =23000000; font-size:=
 10pt;=22>=EF=82=A7</span><span style=3D=22white-space:pre=22>=09</span><=
span style=3D=22font-family: Verdana; color: =23000000; font-size: 10pt;=22=
>Managing Named Ranges=26nbsp;=26nbsp;</span></div>=0D=0A                =
                                                                         =
    <div><span style=3D=22font-family: Verdana; color: =23000000; font-si=
ze: 10pt;=22>=EF=82=A7</span><span style=3D=22white-space:pre=22>=09</spa=
n><span style=3D=22font-family: Verdana; color: =23000000; font-size: 10p=
t;=22>Automatically Creating Named Ranges=26nbsp;=26nbsp;</span></div>=0D=
=0A                                                                      =
                       <div><span style=3D=22font-family: Verdana; color:=
 =23000000; font-size: 10pt;=22>=EF=82=A7</span><span style=3D=22white-sp=
ace:pre=22>=09</span><span style=3D=22font-family: Verdana; color: =23000=
000; font-size: 10pt;=22>Applying Names to Existing Formulas=26nbsp;=26nb=
sp;</span></div>=0D=0A                                                   =
                                          <div><strong><span style=3D=22f=
ont-family: Verdana; color: =23000000; font-size: 10pt;=22>=26=238226;</s=
pan><span style=3D=22white-space:pre=22>=09</span><span style=3D=22font-f=
amily: Verdana; color: =23000000; font-size: 10pt;=22>Controlling Recalcu=
lation=26nbsp;=26nbsp;</span></strong></div>=0D=0A                       =
                                                                      <di=
v><strong><span style=3D=22font-family: Verdana; color: =23000000; font-s=
ize: 10pt;=22>=26=238226;</span><span style=3D=22white-space:pre=22>=09</=
span></strong><span style=3D=22font-family: Verdana; color: =23000000; fo=
nt-size: 10pt;=22><strong>Solving Formula Errors=26nbsp;</strong>=26nbsp;=
</span></div>=0D=0A                                                      =
                                       <div><span style=3D=22font-family:=
 Verdana; color: =23000000; font-size: 10pt;=22>=EF=82=A7</span><span sty=
le=3D=22white-space:pre=22>=09</span><span style=3D=22font-family: Verdan=
a; color: =23000000; font-size: 10pt;=22>Step-by-Step Evaluation=26nbsp;=26=
nbsp;</span></div>=0D=0A                                                 =
                                            <div><span style=3D=22font-fa=
mily: Verdana; color: =23000000; font-size: 10pt;=22>=EF=82=A7</span><spa=
n style=3D=22white-space:pre=22>=09</span><span style=3D=22font-family: V=
erdana; color: =23000000; font-size: 10pt;=22>Tracing Precedents and Depe=
ndents=26nbsp;=26nbsp;</span></div>=0D=0A                                =
                                                             <div><span s=
tyle=3D=22font-family: Verdana; color: =23000000; font-size: 10pt;=22>=EF=
=82=A7</span><span style=3D=22white-space:pre=22>=09</span><span style=3D=
=22font-family: Verdana; color: =23000000; font-size: 10pt;=22>Error Chec=
king=26nbsp;=26nbsp;</span></div>=0D=0A                                  =
                                                           <div><span sty=
le=3D=22font-family: Verdana; color: =23000000;=22></span></div>=0D=0A   =
                                                                         =
                 <div>=26nbsp;</div>=0D=0A                               =
                                                              <div><span =
style=3D=22font-family: Verdana; font-size: 10pt;=22><strong>DAY 2=26nbsp=
;</strong></span></div>=0D=0A                                            =
                                                 <div><span style=3D=22fo=
nt-family: Verdana; color: =23000000; font-size: 10pt;=22><strong>LESSON =
3: ANALYZING DATA WITH FUNCTIONS AND CONDITIONAL FORMATTING=26nbsp;</stro=
ng>=26nbsp;</span></div>=0D=0A                                           =
                                                  <div><span style=3D=22f=
ont-family: Verdana; color: =23000000; font-size: 10pt;=22>=26=238226;</s=
pan><span style=3D=22white-space:pre=22>=09</span><span style=3D=22font-f=
amily: Verdana; color: =23000000; font-size: 10pt;=22>Analyze Data by usi=
ng Logical Functions=26nbsp;=26nbsp;</span></div>=0D=0A                  =
                                                                         =
  <div><span style=3D=22font-family: Verdana; color: =23000000; font-size=
: 10pt;=22>=26=238226;</span><span style=3D=22white-space:pre=22>=09</spa=
n><span style=3D=22font-family: Verdana; color: =23000000; font-size: 10p=
t;=22>Apply Advanced Conditional Formatting=26nbsp;=26nbsp;</span></div>=0D=
=0A                                                                      =
                       <div><br />=0D=0A                                 =
                                                            </div>=0D=0A =
                                                                         =
                   <div><span style=3D=22font-family: Verdana; color: =23=
000000; font-size: 10pt;=22><strong>LESSON 4: ORGANIZING AND ANALYZING DA=
TASETS AND TABLES=26nbsp;=26nbsp;</strong></span></div>=0D=0A            =
                                                                         =
        <div><span style=3D=22font-family: Verdana; color: =23000000; fon=
t-size: 10pt;=22>=26=238226;</span><span style=3D=22white-space:pre=22>=09=
</span><span style=3D=22font-family: Verdana; color: =23000000; font-size=
: 10pt;=22>Create and Modify SMART Tables=26nbsp;=26nbsp;</span></div>=0D=
=0A                                                                      =
                       <div><span style=3D=22font-family: Verdana; color:=
 =23000000; font-size: 10pt;=22>=26=238226;</span><span style=3D=22white-=
space:pre=22>=09</span><span style=3D=22font-family: Verdana; color: =230=
00000; font-size: 10pt;=22>Sort =26amp;Filter Data=26nbsp;=26nbsp;</span>=
</div>=0D=0A                                                             =
                                <div><span style=3D=22font-family: Verdan=
a; color: =23000000; font-size: 10pt;=22>=26=238226;</span><span style=3D=
=22white-space:pre=22>=09</span><span style=3D=22font-family: Verdana; co=
lor: =23000000; font-size: 10pt;=22>The Magic of SMART tables</span></div=
>=0D=0A                                                                  =
                           <div><span style=3D=22font-family: Verdana; co=
lor: =23000000; font-size: 10pt;=22>=26=238226;</span><span style=3D=22wh=
ite-space:pre=22>=09</span><span style=3D=22font-family: Verdana; color: =
=23000000; font-size: 10pt;=22>Use SUBTOTAL and Database Functions=26nbsp=
;</span></div>=0D=0A                                                     =
                                        <div><br />=0D=0A                =
                                                                         =
    </div>=0D=0A                                                         =
                                    <div><span style=3D=22font-family: Ve=
rdana; color: =23000000; font-size: 10pt;=22><strong>LESSON 5: VISUALIZIN=
G DATA WITH DYNAMIC CHARTS=26nbsp;=26nbsp;</strong></span></div>=0D=0A   =
                                                                         =
                 <div><span style=3D=22font-family: Verdana; color: =2300=
0000; font-size: 10pt;=22>=26=238226;</span><span style=3D=22white-space:=
pre=22>=09</span><span style=3D=22font-family: Verdana; color: =23000000;=
 font-size: 10pt;=22>Create Charts=26nbsp;=26nbsp;</span></div>=0D=0A    =
                                                                         =
                <div><span style=3D=22font-family: Verdana; color: =23000=
000; font-size: 10pt;=22>=26=238226;</span><span style=3D=22white-space:p=
re=22>=09</span><span style=3D=22font-family: Verdana; color: =23000000; =
font-size: 10pt;=22>Modify and Format Charts=26nbsp;=26nbsp;</span></div>=
=0D=0A                                                                   =
                          <div><span style=3D=22font-family: Verdana; col=
or: =23000000; font-size: 10pt;=22>=26=238226;</span><span style=3D=22whi=
te-space:pre=22>=09</span><span style=3D=22font-family: Verdana; color: =23=
000000; font-size: 10pt;=22>Preparing Dynamic Features on the Charts</spa=
n></div>=0D=0A                                                           =
                                  <div><br />=0D=0A                      =
                                                                       </=
div>=0D=0A                                                               =
                              <div><span style=3D=22font-family: Verdana;=
 color: =23000000; font-size: 10pt;=22><strong>LESSON 6: USING PIVOT TABL=
ES=26nbsp;</strong></span></div>=0D=0A                                   =
                                                          <div><span styl=
e=3D=22font-family: Verdana; color: =23000000; font-size: 10pt;=22><stron=
g>This module explains how to use Pivot Tables=2E=26nbsp;=26nbsp;</strong=
></span></div>=0D=0A                                                     =
                                        <div><span style=3D=22font-family=
: Verdana; color: =23000000; font-size: 10pt;=22><strong>Lessons=26nbsp;=26=
nbsp;</strong></span></div>=0D=0A                                        =
                                                     <div><span style=3D=22=
font-family: Verdana; color: =23000000; font-size: 10pt;=22>=26=238226;</=
span><span style=3D=22white-space:pre=22>=09</span><span style=3D=22font-=
family: Verdana; color: =23000000; font-size: 10pt;=22>Creating Pivot Tab=
les=26nbsp;=26nbsp;</span></div>=0D=0A                                   =
                                                          <div><span styl=
e=3D=22font-family: Verdana; color: =23000000; font-size: 10pt;=22>=26=23=
8226;</span><span style=3D=22white-space:pre=22>=09</span><span style=3D=22=
font-family: Verdana; color: =23000000; font-size: 10pt;=22>Inserting Sli=
cers=26nbsp;</span></div>=0D=0A                                          =
                                                   <div><span style=3D=22=
font-family: Verdana; color: =23000000; font-size: 10pt;=22>=26=238226;</=
span><span style=3D=22white-space:pre=22>=09</span><span style=3D=22font-=
family: Verdana; color: =23000000; font-size: 10pt;=22>Working with Pivot=
 Tables=26nbsp;</span></div>=0D=0A                                       =
                                                      <div><span style=3D=
=22font-family: Verdana; color: =23000000; font-size: 10pt;=22>=26=238226=
;</span><span style=3D=22white-space:pre=22>=09</span><span style=3D=22fo=
nt-family: Verdana; color: =23000000; font-size: 10pt;=22>Inserting Pivot=
 Charts=26nbsp;</span></div>=0D=0A                                       =
                                                      <div><span style=3D=
=22font-family: Verdana; color: =23000000; font-size: 10pt;=22>=26=238226=
;</span><span style=3D=22white-space:pre=22>=09</span><span style=3D=22fo=
nt-family: Verdana; color: =23000000; font-size: 10pt;=22>More Pivot Tabl=
e Functionality=26nbsp;</span></div>=0D=0A                               =
                                                              <div><span =
style=3D=22font-family: Verdana; color: =23000000; font-size: 10pt;=22><s=
trong>Lab: Using Pivot Tables=26nbsp;</strong></span></div>=0D=0A        =
                                                                         =
            <div><span style=3D=22font-family: Verdana; color: =23000000;=
 font-size: 10pt;=22>=26=238226;</span><span style=3D=22white-space:pre=22=
>=09</span><span style=3D=22font-family: Verdana; color: =23000000; font-=
size: 10pt;=22>Working with Pivot Tables=26nbsp;</span></div>=0D=0A      =
                                                                         =
              <div><span style=3D=22font-family: Verdana; color: =2300000=
0; font-size: 10pt;=22><strong>After completing this module, students wil=
l be able to:=26nbsp;</strong></span></div>=0D=0A                        =
                                                                     <div=
><span style=3D=22font-family: Verdana; color: =23000000; font-size: 10pt=
;=22>=26=238226;</span><span style=3D=22white-space:pre=22>=09</span><spa=
n style=3D=22font-family: Verdana; color: =23000000; font-size: 10pt;=22>=
Use pivot tables to analyze data=2E=26nbsp;</span></div>=0D=0A           =
                                                                         =
         <div><span style=3D=22font-family: Verdana; color: =23000000; fo=
nt-size: 10pt;=22>=26=238226;</span><span style=3D=22white-space:pre=22>=09=
</span><span style=3D=22font-family: Verdana; color: =23000000; font-size=
: 10pt;=22>Edit pivot tables=2E=26nbsp;</span></div>=0D=0A               =
                                                                         =
     <div><span style=3D=22font-family: Verdana; color: =23000000; font-s=
ize: 10pt;=22>=26=238226;</span><span style=3D=22white-space:pre=22>=09</=
span><span style=3D=22font-family: Verdana; color: =23000000; font-size: =
10pt;=22>Format pivot tables=2E=26nbsp;</span></div>=0D=0A               =
                                                                         =
     <div><span style=3D=22font-family: Verdana; color: =23000000; font-s=
ize: 10pt;=22>=26=238226;</span><span style=3D=22white-space:pre=22>=09</=
span><span style=3D=22font-family: Verdana; color: =23000000; font-size: =
10pt;=22>Insert pivot charts=2E=26nbsp;</span></div>=0D=0A               =
                                                                         =
     <div><span style=3D=22font-family: Verdana; color: =23000000; font-s=
ize: 10pt;=22>=26=238226;</span><span style=3D=22white-space:pre=22>=09</=
span><span style=3D=22font-family: Verdana; color: =23000000; font-size: =
10pt;=22>Use Slicers</span></div>=0D=0A                                  =
                                                           <div><span sty=
le=3D=22font-family: Verdana; color: =23000000; font-size: 10pt;=22>=26=23=
8226;</span><span style=3D=22white-space:pre=22>=09</span><span style=3D=22=
font-family: Verdana; color: =23000000; font-size: 10pt;=22>Preparing Ana=
lysis, Survey and reporting KPIs</span></div>=0D=0A                      =
                                                                       <d=
iv><br />=0D=0A                                                          =
                                   </div>=0D=0A                          =
                                                                   <div><=
span style=3D=22font-family: Verdana; color: =23000000; font-size: 10pt;=22=
><strong>LESSON 7: PREPARING A SIMPLIFIED DASHBOARD REPORTING =26amp; DAT=
A VISUALIZATION IN EXCEL</strong></span></div>=0D=0A                     =
                                                                        <=
div><strong><br />=0D=0A                                                 =
                                            </strong></div>=0D=0A        =
                                                                         =
            <div><span style=3D=22font-family: Verdana; font-size: 10pt;=22=
><strong>LESSON 8: INTRODUCTION TO EXCEL BUSINESS INTELLIGENT TOOLS (POWE=
R BI)</strong></span></div>=0D=0A                                        =
                                                     <div><span style=3D=22=
font-family: Verdana; font-size: 10pt;=22><strong></strong></span></div>=0D=
=0A                                                                      =
                       <div></div>=0D=0A                                 =
                                                            <div style=3D=
=22color: =23666666;=22>=26nbsp;</div>=0D=0A                             =
                                                                <div><spa=
n style=3D=22color: =23ff0000; font-family: verdana, geneva; font-size: 1=
0pt;=22><strong>TRAINER PROFILE=26nbsp; </strong></span></div>=0D=0A     =
                                                                         =
               <div>=0D=0A                                               =
                                              <div><span style=3D=22font-=
size: 10pt; font-family: Verdana;=22></span></div>=0D=0A                 =
                                                                         =
   <div style=3D=22text-align: justify; =22><span style=3D=22font-family:=
 Verdana; font-size: 10pt;=22><strong>Puan Shabenah Bee</strong> is dilig=
ent and dedicated Computer Science educationist with 18 years=26=238217; =
experience in ICT and Softskill training especially for private and gover=
nment agencies around Malaysia and Singapore=2E Track record of consisten=
tly building the participants=26=238217; calibre and knowledge in Informa=
tion Technology, Business Communication and Self-development skills=2E Co=
mmitted to provide high quality corporate training at all levels=2E Profo=
und ability to develop productive and effectual lesson plans based on the=
 curriculum and executing the same=2E</span></div>=0D=0A                 =
                                                                         =
   <div style=3D=22text-align: justify; =22><span style=3D=22font-family:=
 Verdana; font-size: 10pt;=22><strong>Substantial knowledge of age specif=
ic effective teaching and instructional strategies</strong></span></div>=0D=
=0A                                                                      =
                       <div style=3D=22text-align: justify; =22><span sty=
le=3D=22font-family: Verdana; font-size: 10pt;=22><strong>Solid experienc=
e in supervising ICT related practical projects as client=26=238217;s req=
uirement=2E</strong></span></div>=0D=0A                                  =
                                                           <div style=3D=22=
text-align: justify; =22><span style=3D=22font-family: Verdana; font-size=
: 10pt;=22>She had vast of experiences in Microsoft Office especially Mic=
rosoft Excel training, which covering multi-national businesses, local bu=
sinesses, and non-profit organizations=2E She specialize in Computer Cour=
ses=26=238211;Microsoft Office Application ver=2E 2013/2010/2007/2003 suc=
h as: Microsoft Outlook (Basic=26=238211;Expert Level)/ Microsoft with VB=
A (Basic-Expert Level)/ Adobe Photoshop (Basic-Expert Level)/ Adobe In De=
sign (Basic-Expert level)/ Adobe Flash (Basic-Expert Level)/ Adobe Flash =
(Basic-Expert Level)/ Adobe Premier (Basic-Expert Level)/ Adobe Illustrat=
or (Basic-Expert Level)/ Web Designing/ Web programming/ Internet Appreci=
ation Courses/ Window 8/7/XP/2000=26=238211;JavaScript Basic (Basic-Exper=
t Level)/ Movie Maker/ HTML Basic-Advance/ Lotus Notes Basic-Advance/ ITL=
 Foundation</span></div>=0D=0A                                           =
                                                  <div style=3D=22text-al=
ign: justify; =22><span style=3D=22font-family: Verdana; font-size: 10pt;=
=22>She has trained corporations including Port Of Tanjung Pelepas, Port =
of Tanjung Langsat, JAKIM, Universiti Islam Antarabangsa Malaysia, Univer=
siti Teknologi Malaysia, Tenaga Nasional Berhad, Sistem Air Johor, Techni=
p (AsiaFlex Products Sdn Bhd) , UEM,=26nbsp; Ministry Of Health Malaysia,=
 PSMB, Genting Properties Sdn Bhd, TV3, Polis DiRaja Malaysia, Dyson, Isk=
andar Regional Development Authorities (IRDA, Johor), IOI Properties, CID=
B Malaysia=2E</span></div>=0D=0A                                         =
                                                    <div style=3D=22text-=
align: justify; =22><span style=3D=22font-family: Verdana; font-size: 10p=
t;=22>On a personal level, she is a strong believer of continual improvem=
ent is a journey of self-learning=2E In her classes, she guides the parti=
cipants on forming their own solutions=2E She received regular feedback f=
rom her participants for being inspiring in her nature=2E She relates her=
 trainings and teaching with the practical side of the corporate world=2E=
 She is known as a trainer and teacher who instil the essence of learning=
</span></div>=0D=0A                                                      =
                                       <div><br />=0D=0A                 =
                                                                         =
   </div>=0D=0A                                                          =
                                   <div><span style=3D=22font-size: 10pt;=
 font-family: Verdana;=22></span></div>=0D=0A                            =
                                                                 <span st=
yle=3D=22color: =23000000; font-family: verdana, geneva; font-size: 10pt;=
=22><strong><span style=3D=22color: =23ff0000; font-size: 12pt;=22>Call u=
s to get full brochure</span></strong></span></div>=0D=0A                =
                                                                         =
    </td>=0D=0A                                                          =
                               </tr>=0D=0A                               =
                                                          <tr>=0D=0A     =
                                                                         =
               <td style=3D=22text-align: justify; color: =23666666; back=
ground-color: whitesmoke;=22>=0D=0A                                      =
                                                       <div><span style=3D=
=22color: =23000000; font-family: verdana, geneva; font-size: 12pt;=22><s=
trong>TRAINING FEE</strong></span></div>=0D=0A                           =
                                                                  <div><s=
pan style=3D=22color: =23000000;=22><span style=3D=22color: =23000000; fo=
nt-family: verdana, geneva; font-size: 12pt;=22><strong>NORMAL PRICE RM 1=
,399 </strong></span><span style=3D=22color: =23000000; font-family: verd=
ana, geneva; font-size: 8pt;=22><strong>(Excl=2E 6=25 SST)</strong></span=
></span><br />=0D=0A                                                     =
                                        <span style=3D=22color: =23000000=
; font-family: verdana, geneva; font-size: 12pt;=22>GROUP DISCOUNT 10=25=26=
nbsp;(5 and above)</span></div>=0D=0A                                    =
                                                         </td>=0D=0A     =
                                                                         =
           </tr>=0D=0A                                                   =
                                      <tr>=0D=0A                         =
                                                                    <td s=
tyle=3D=22text-align: justify; color: =23666666;=22>=0D=0A               =
                                                                         =
     <p><span style=3D=22color: =23000000; font-family: Verdana; font-siz=
e: 10pt;=22><strong>Please call us for more information or BROCHURE</stro=
ng></span><br />=0D=0A                                                   =
                                          <span style=3D=22color: =230000=
00; font-family: Verdana; font-size: 10pt;=22><strong>Tel: +6(03) 8079 09=
04 / +6(03) 8079 0905 / +6012 3838079 / +6018 2053388 /+6018 2052366 </st=
rong></span></p>=0D=0A                                                   =
                                          <div><span style=3D=22color: =23=
000000; font-family: Verdana; font-size: 10pt;=22>Michelle (<a href=3D=22=
mailto:michelle=40bigberryconsulting=2Ecom=22><span style=3D=22font-size:=
 10pt; color: =23000000;=22>michelle=40bigberryconsulting=2Ecom</span></a=
></span><span style=3D=22color: =23000000; font-family: Verdana; font-siz=
e: 10pt;=22>)<br />=0D=0A                                                =
                                             </span><span style=3D=22colo=
r: =23000000; font-family: Verdana; font-size: 10pt;=22>Brian (brian<a hr=
ef=3D=22mailto:thaneswary=40bigberryconsulting=2Ecom=22><span style=3D=22=
font-size: 10pt; color: =23000000;=22>=40bigberryconsulting=2Ecom</span><=
/a></span><span style=3D=22color: =23000000; font-family: Verdana; font-s=
ize: 10pt;=22>)<br />=0D=0A                                              =
                                               </span><span style=3D=22co=
lor: =23000000; font-family: Verdana; font-size: 10pt;=22> Mimi Wahida (<=
a href=3D=22mailto:mohd=2Enasrulshah=40bigberryconsulting=2Ecom=22><span =
style=3D=22font-size: 10pt; color: =23000000;=22>mimi=2Ewahida=40bigberry=
consulting=2Ecom</span></a></span><span style=3D=22color: =23000000; font=
-family: Verdana; font-size: 10pt;=22>)<br />=0D=0A                      =
                                                                       </=
span><span style=3D=22color: =23000000; font-family: Verdana; font-size: =
10pt;=22> Fara Ahmad</span><span style=3D=22font-family: Verdana; font-si=
ze: 10pt; color: =23000000;=22> (</span><a href=3D=22mailto:fara=40bigber=
ryconsulting=2Ecom=22><span style=3D=22font-family: Verdana; font-size: 1=
0pt; color: =23000000;=22>fara=40bigberryconsulting=2Ecom</span></a><span=
 style=3D=22font-family: Verdana; font-size: 10pt; color: =23000000;=22>)=
</span><br />=0D=0A                                                      =
                                       <span style=3D=22color: =23000000;=
 font-family: Verdana; font-size: 10pt;=22>Nurul Nadia</span><span style=3D=
=22font-family: Verdana; font-size: 10pt; color: =23000000;=22> (</span><=
a href=3D=22mailto:nurul=2Enadia=40bigberryconsulting=2Ecom=22><span styl=
e=3D=22font-family: Verdana; font-size: 10pt; color: =23000000;=22>nurul=2E=
nadia=40bigberryconsulting=2Ecom</span></a><span style=3D=22font-family: =
Verdana; font-size: 10pt; color: =23000000;=22>)</span><br />=0D=0A      =
                                                                         =
              <span style=3D=22color: =23000000; font-family: Verdana;=22=
><br />=0D=0A                                                            =
                                 </span><span style=3D=22color: =23000000=
; font-family: Verdana; font-size: 10pt;=22> More courses, visit </span><=
span style=3D=22font-family: Verdana;=22><a href=3D=22http://www=2Ebigber=
ryconsulting=2Ecom/=22><span style=3D=22font-size: 10pt; color: =23000000=
;=22>http://www=2Ebigberryconsulting=2Ecom/</span></a></span></div>=0D=0A=
                                                                         =
                    <div>=0D=0A                                          =
                                                   <div><font face=3D=22V=
erdana=22></font>=26nbsp;</div>=0D=0A                                    =
                                                         <div><span style=
=3D=22color: =23000000; font-family: Verdana; font-size: 12pt;=22><strong=
>Note: All this program can be customised for In-House Training=2E Call u=
s for Proposal</strong></span></div>=0D=0A                               =
                                                              </div>=0D=0A=
                                                                         =
                    </td>=0D=0A                                          =
                                               </tr>=0D=0A               =
                                                                         =
 <tr bgcolor=3D=22=23c41111=22 style=3D=22font-family: sans-serif;backgro=
und-repeat: no-repeat;background-position: bottom;background-image: url(h=
ttp://bigberryconsulting=2Ecom/newsletter/jan_2020/images/bgimage2=2Ejpg)=
;background-size: cover;padding: 25px 0px; margin-bottom: 0px;height: 60p=
x;=22>=0D=0A                                                             =
                                <td color=3D=22=23c41111=22 align=3D=22ce=
nter=22>=0D=0A                                                           =
                                  <div class=3D=22mar-none back_red=22>=0D=
=0A                                                                      =
                       <span>=0D=0A                                      =
                                                       <span class=3D=22c=
ard-header text-center bor-none=22 style=3D=22border: none;background-col=
or: transparent;text-align: center=21important;color: =23fff=21important;=
border-radius: calc(=2E25rem - 1px) calc(=2E25rem - 1px) 0 0;=22>=0D=0A  =
                                                                         =
                  Copyright =40 2019 Bigberry Consulting Sdn Bhd=2E All R=
ights Reserved=0D=0A                                                     =
                                        </span>=0D=0A                    =
                                                                         =
</span>=0D=0A                                                            =
                                 </div>=0D=0A                            =
                                                                 </td>=0D=
=0A                                                                      =
                   </tr>=0D=0A                                           =
                                              <tr>=0D=0A                 =
                                                                         =
   <td><span style=3D=22font-size: 12pt; font-family: Verdana; background=
-color: =2300ff00;=22>If you wish to stop future mailings, or if you feel=
 you have been wrongfully placed in our mailinglist,=0D=0A               =
                                                                         =
     please reply the email by saying </span><span style=3D=22font-size: =
12pt; font-family: Verdana; background-color: =23ffff00;=22><strong>UNSUB=
SCRIBE</strong></span><span style=3D=22font-size: 12pt; font-family: Verd=
ana; background-color: =2300ff00;=22>=2E We will discontinue the email=26=
nbsp;=26nbsp;</span></td>=0D=0A                                          =
                                               </tr>=0D=0A               =
                                                                      </t=
body>=0D=0A                                                              =
                   </table>=0D=0A                                        =
                                         </td>=0D=0A                     =
                                                        </tr>=0D=0A      =
                                                                   </tbod=
y>=0D=0A                                                                 =
    </table>=0D=0A                                                       =
              </div>=0D=0A                                               =
                      <div id=3D=22UMS_TOOLTIP=22 style=3D=22position: ab=
solute; cursor: pointer; z-index: 2147483647; background: transparent; to=
p: -100000px; left: -100000px;=22></div>=0D=0A                           =
                                      =0D=0A=0D=0A =0D=0A =0D=0A =0D=0A =0D=
=0A =0D=0A =0D=0A =0D=0A =0D=0A =0D=0A </body></html><br></html>=0D=0A