관리-도구

편집 파일: 1614137736.M680779P13587.server.saraya-global.com,S=73207,W=74200:2,

Envelope-to: jaisone@saraya.com.my
Delivery-date: Wed, 24 Feb 2021 11:35:36 +0800
From: "(Online) Data Analysis and Interactive Dashboard Reporting In Excel 2016" <izyana@rk-rakan.com> 
To: "jaisone@saraya.com.my" <jaisone@saraya.com.my>
Date: Wed, 24 Feb 2021 11:34:51 +0800
MIME-Version: 1.0
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Sender: newsletter@enewsletter2.com
Message-ID: <EQSVR002ff8dc8d061724f84a8accbc126437e6e@EQSVR002>
Subject:  ***SPAM***  (Online) Data Analysis and Interactive Dashboard Reporting In Excel 2016

<html><=21-- pic/eqtoblank=2Egif?id=3D102823224 --> <table> <td> <img alt=
=3D=27=27 src=3D=27http://www=2EeNewsletter2=2Ecom/pic/eqtoblank=2Egif?id=
=3D102823224=27 /> </td></table><html><html><html><html><html><html><html=
><html><html><html>=0D=0A     <html>=0D=0A         <html>=0D=0A          =
   <html>=0D=0A                 <html>=0D=0A                     <html>=0D=
=0A                         <html>=0D=0A                             <htm=
l>=0D=0A                                 <html>=0D=0A                    =
                 <html>=0D=0A                                         <ht=
ml>=0D=0A                                             <html>=0D=0A       =
                                          <html>=0D=0A                   =
                                  <html>=0D=0A                           =
                              <html>=0D=0A                               =
                              <html><head>=0D=0A                         =
                                            <title>Big Berry Newsletter <=
/title>=0D=0A                                                            =
     </head><body bgcolor=3D=22=23ffffff=22>=0D=0A                       =
                                              <div align=3D=22center=22>=0D=
=0A                                                                     <=
table style=3D=22width: 600px; height: auto; font-family: Georgia, =26quo=
t;Times New Roman=26quot;, Times, serif; font-size: 12px;=22 cellspacing=3D=
=220=22 cellpadding=3D=2210=22 border=3D=220=22 bgcolor=3D=22=23ffffff=22=
 align=3D=22center=22>=0D=0A                                             =
                            <tbody>=0D=0A                                =
                                             <=21--img src=3D=22images/he=
ader=2Ejpg=22 alt=3D=22=22 /-->=0D=0A                                    =
                                         <tr>=0D=0A                      =
                                                           <td>=0D=0A    =
                                                                         =
    <table style=3D=22width: 600px; height: 636px; font-family: Georgia, =
=27Times New Roman=27, Times, serif; font-size: 12px;=22 cellspacing=3D=22=
0=22 cellpadding=3D=2210=22 border=3D=220=22 bgcolor=3D=22=23ffffff=22 al=
ign=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=23image-ma=
p=22 alt=3D=22=22 />=0D=0A                                               =
                                              <map name=3D=22image-map=22=
>=0D=0A                                                                  =
                           <area target=3D=22_blank=22 alt=3D=22bigberry=22=
 title=3D=22bigberry=22 href=3D=22http://bigberryconsulting=2Ecom/=22 coo=
rds=3D=227,6,266,129=22 shape=3D=22rect=22 />=0D=0A                      =
                                                                       <a=
rea target=3D=22_blank=22 alt=3D=22facebook=22 title=3D=22facebook=22 hre=
f=3D=22https://www=2Efacebook=2Ecom/BigBerryCnsltng/=22 coords=3D=22454,7=
1,19=22 shape=3D=22circle=22 />=0D=0A                                    =
                                                         <area target=3D=22=
_blank=22 alt=3D=22instagram=22 title=3D=22instagram=22 href=3D=22https:/=
/www=2Einstagram=2Ecom/big=2Eberry=2Econsulting/=22 coords=3D=22507,71,20=
=22 shape=3D=22circle=22 />=0D=0A                                        =
                                                     <area target=3D=22_b=
lank=22 alt=3D=22twitter=22 title=3D=22twitter=22 href=3D=22https://twitt=
er=2Ecom/BigBerryCnsltng=22 coords=3D=22558,71,20=22 shape=3D=22circle=22=
 />=0D=0A                                                                =
                             <area target=3D=22_blank=22 alt=3D=22linkedi=
n=22 title=3D=22linkedin=22 href=3D=22https://www=2Elinkedin=2Ecom/compan=
y/big-berry-consulting-sdn-bhd?trk=3Dtop_nav_home=22 coords=3D=22611,71,2=
1=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; color: =23=
333333; font-family: Georgia, =26quot;Times New Roman=26quot;, Times, ser=
if; font-size: 28px; background-color: =23ed1c24;=22>=0D=0A              =
                                                                         =
      <div>=0D=0A                                                        =
                                     <div><span style=3D=22font-family: V=
erdana;=22><strong></strong></span></div>=0D=0A                          =
                                                                   <div><=
span style=3D=22font-family: Verdana; color: =23ffffff;=22><strong>DATA A=
NALYSIS AND INTERACTIVE </strong></span><span style=3D=22font-family: Ver=
dana; color: =23ffff00; font-size: 26pt;=22><strong><em>DASHBOARD REPORTI=
NG </em></strong></span></div>=0D=0A                                     =
                                                        <div><span style=3D=
=22font-family: Verdana; color: =23ffffff;=22><strong>IN EXCEL 2016</stro=
ng></span></div>=0D=0A                                                   =
                                          </div>=0D=0A                   =
                                                                         =
 </td>=0D=0A                                                             =
                            </tr>=0D=0A                                  =
                                                       <tr style=3D=22bac=
kground-color: =23000000;=22>=0D=0A                                      =
                                                       <td style=3D=22hei=
ght: 28px; color: =23333333; font-family: Georgia, =26quot;Times New Roma=
n=26quot;, Times, serif; font-size: 28px;=22>=0D=0A                      =
                                                                       <d=
iv><span style=3D=22color: =23ffff00; font-size: 18pt;=22><span style=3D=22=
color: =23ffff00; font-size: 18pt;=22><strong><span style=3D=22font-famil=
y: Arial; font-size: 12pt;=22>23 =26amp; 24 March 2021, ONLINE (ZOOM) 9AM=
 - 5PM=26nbsp;</span></strong></span></span><div><span style=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=22color: =2300000=
0; font-family: verdana, geneva; font-size: 10pt;=22></span>=0D=0A       =
                                                                         =
             <div><span style=3D=22color: black; line-height: 107=25; fon=
t-family: Verdana, sans-serif; font-size: 10pt;=22></span>=0D=0A         =
                                                                         =
           <div><span style=3D=22font-size: 13=2E3333px; font-family: Ver=
dana; color: =23000000;=22></span></div>=0D=0A                           =
                                                                  <div st=
yle=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 market toda=
y=2E By participating in this Microsoft Excel Data Analysis and Dashboard=
 Reporting course you=27ll gain the widely sought after skills necessary =
to effectively analyze large sets of data=2E Once the data has been analy=
zed, clean and prepared for presentation, you will learn how to present t=
he data in an interactive dashboard report=2E=26nbsp;</span></div>=0D=0A =
                                                                         =
                   <strong style=3D=22color: =23666666;=22><br />=0D=0A  =
                                                                         =
                  <span style=3D=22font-family: verdana, geneva; color: =23=
ff0000; font-size: small;=22>PROGRAM OBJECTIVES</span><span style=3D=22fo=
nt-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><strong>After=
 completing this course, students will be able to=26nbsp;</strong></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>=
Manage database effectively=2E=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>Apply proper formula and functi=
on=2E=26nbsp;</span></div>=0D=0A                                         =
                                                    <div><span style=3D=22=
font-family: Verdana; font-size: 10pt;=22>=26=238226;</span><span style=3D=
=22white-space:pre=22>=09</span><span style=3D=22font-family: Verdana; fo=
nt-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><spa=
n style=3D=22font-family: Verdana; font-size: 10pt;=22>Link and Embed Dat=
a from other sources=2E=26nbsp;</span></div>=0D=0A                       =
                                                                      <di=
v><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>Applying Conditional Formatting and=
 Validation Rules=26nbsp;</span></div>=0D=0A                             =
                                                                <div><spa=
n 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-famil=
y: Verdana; font-size: 10pt;=22>Advanced Analytics Tools</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</spa=
n><span style=3D=22font-family: Verdana; font-size: 10pt;=22>Interactive =
Dashboard Reporting</span></div>=0D=0A                                   =
                                                          <div><span styl=
e=3D=22font-family: Verdana; font-size: 10pt;=22></span></div>=0D=0A     =
                                                                         =
               <div style=3D=22font-family: verdana, geneva; font-size: s=
mall;=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: Verdana; color: =23=
000000; font-size: 10pt;=22><strong>DAY 1=26nbsp;</strong></span></div>=0D=
=0A                                                                      =
                       <div><span style=3D=22font-family: Verdana; font-s=
ize: 10pt; color: =23000000;=22><strong></strong></span></div>=0D=0A     =
                                                                         =
               <div><span style=3D=22font-family: Verdana; color: =230000=
00; font-size: 10pt;=22><strong>LESSON 1: CUSTOMIZING THE EXCEL ENVIRONME=
NT=26nbsp;</strong>=26nbsp;</span></div>=0D=0A                           =
                                                                  <div><s=
pan style=3D=22font-family: Verdana; color: =23000000; font-size: 10pt;=22=
>=26=238226;</span><span style=3D=22white-space:pre=22>=09</span><span st=
yle=3D=22font-family: Verdana; color: =23000000; font-size: 10pt;=22>Conf=
igure Excel Options=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: =23000000; font-size: 10pt=
;=22>Customize the Ribbon and the Quick Access Toolbar=26nbsp;=26nbsp;</s=
pan></div>=0D=0A                                                         =
                                    <div><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>Enable Excel Add-Ins=26nbsp;=26nb=
sp;</span></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 2: KICK STA=
RT WITH INTERMEDIATE TO ADVANCE FORMULA AND FUNCTIONS=26nbsp;</strong></s=
pan></div>=0D=0A                                                         =
                                    <div><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>Use Array Formulas=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: Ver=
dana; color: =23000000; font-size: 10pt;=22>Use Range Names in 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 Specialized Fu=
nctions=26nbsp;=26nbsp;</span></div>=0D=0A                               =
                                                              <div><span =
style=3D=22font-family: Verdana; color: =23000000; font-size: 10pt;=22><s=
trong>Building=26nbsp; Formulas=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></strong><span style=3D=22font-family: Verdana; col=
or: =23000000; font-size: 10pt;=22><strong>Functions=26nbsp;</strong>=26n=
bsp;</span></div>=0D=0A                                                  =
                                           <div><span style=3D=22font-fam=
ily: 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: Ve=
rdana; color: =23000000; font-size: 10pt;=22>Using a Function in a Formul=
a=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 Refere=
nces 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: =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>Excel Compatibility Functions=26nbsp; =26nbsp;</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>Formula Errors=26nbsp;=26nbs=
p;</span></strong></div>=0D=0A                                           =
                                                  <div><strong><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>Logical Opera=
tors=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>F=
ormula Shortcuts=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-space:pre=22>=09</=
span><span style=3D=22font-family: Verdana; color: =23000000; font-size: =
10pt;=22>Point-and-Click Formula Creation=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>Point-and-Click Formula Editing=26nbsp;=26nbsp;<=
/span></div>=0D=0A                                                       =
                                      <div><span style=3D=22font-family: =
Verdana; color: =23000000; font-size: 10pt;=22>=EF=82=A7</span><span styl=
e=3D=22white-space:pre=22>=09</span><span style=3D=22font-family: Verdana=
; color: =23000000; font-size: 10pt;=22>The Formulas Tab=2E=26nbsp;=26nbs=
p;</span></div>=0D=0A                                                    =
                                         <div><span style=3D=22font-famil=
y: Verdana; color: =23000000; font-size: 10pt;=22>=EF=82=A7</span><span s=
tyle=3D=22white-space:pre=22>=09</span><span style=3D=22font-family: Verd=
ana; color: =23000000; font-size: 10pt;=22>Using the Insert Function Butt=
on=26nbsp; =26nbsp;</span></div>=0D=0A                                   =
                                                          <div><strong><s=
pan 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>Re=
ferencing 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-space:pre=22>=
=09</span><span style=3D=22font-family: Verdana; color: =23000000; font-s=
ize: 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-space:pre=22>=
=09</span><span style=3D=22font-family: Verdana; color: =23000000; font-s=
ize: 10pt;=22>Partially Fixed References=26nbsp;=26nbsp;</span></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>Referring to Other Worksheets=26nbsp;=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>Referring to Other Workbooks=26nbsp;=26n=
bsp;</span></div>=0D=0A                                                  =
                                           <div><span style=3D=22font-fam=
ily: Verdana; color: =23000000; font-size: 10pt;=22><strong>Lookup, Refer=
ence, and Information Functions=26nbsp;=26nbsp;</strong></span></div>=0D=0A=
                                                                         =
                    <div><strong><span style=3D=22font-family: Verdana; c=
olor: =23000000; font-size: 10pt;=22>=26=238226;</span><span style=3D=22w=
hite-space:pre=22>=09</span><span style=3D=22font-family: Verdana; color:=
 =23000000; font-size: 10pt;=22>The Basic Lookup=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-fami=
ly: Verdana; color: =23000000; font-size: 10pt;=22>VLOOKUP(): Vertical Lo=
okups=26nbsp;=26nbsp;</span></strong></div>=0D=0A                        =
                                                                     <div=
><strong><span style=3D=22font-family: Verdana; color: =23000000; font-si=
ze: 10pt;=22>=26=238226;</span><span style=3D=22white-space:pre=22>=09</s=
pan><span style=3D=22font-family: Verdana; color: =23000000; font-size: 1=
0pt;=22>HLOOKUP(): Horizontal Lookups=26nbsp;=26nbsp;</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>Advanced Lookups=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-space:pre=22>=09</span><span style=3D=22font-family=
: Verdana; color: =23000000; font-size: 10pt;=22>MATCH(): Finding the Pos=
ition 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;</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>Performing a =26=238220;Left Lookup=26=23=
8221;=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>Performing a Double =
Lookup=26nbsp;=26nbsp;</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-space:pre=22>=09</span></st=
rong><span style=3D=22font-family: Verdana; color: =23000000; font-size: =
10pt;=22><strong>Information Functions=26nbsp;</strong>=26nbsp;</span></d=
iv>=0D=0A                                                                =
                             <div><span style=3D=22font-family: Verdana; =
color: =23000000; font-size: 10pt;=22>=EF=82=A7</span><span style=3D=22wh=
ite-space:pre=22>=09</span><span style=3D=22font-family: Verdana; color: =
=23000000; font-size: 10pt;=22>The =26=238220;IS=26=238221; Functions: Ch=
ecking the Value Inside a Cell=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-s=
ize: 10pt;=22>IFERROR, IFERR=26nbsp;=26nbsp;</span></div>=0D=0A          =
                                                                         =
          <div><span style=3D=22font-family: Verdana; color: =23000000; f=
ont-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=
,299 </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 </body></html><br></html>=0D=0A