관리-도구

편집 파일: 1629948013.M922290P29279.server.saraya-global.com,S=73953,W=74958:2,

Envelope-to: jaisone@saraya.com.my
Delivery-date: Thu, 26 Aug 2021 11:20:13 +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: Thu, 26 Aug 2021 11:19:15 +0800
MIME-Version: 1.0
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Sender: newsletter@enewsletter2.com
Message-ID: <EQSVR002e4aeec19c06645039ec26d8b4b7973a0@EQSVR002>
Subject:  ***SPAM***  (Online) Data Analysis and Interactive Dashboard Reporting In Excel 2016

<html><=21-- pic/eqtoblank=2Egif?id=3D109245043 --> <table> <td> <img alt=
=3D=27=27 src=3D=27http://www=2EeNewsletter2=2Ecom/pic/eqtoblank=2Egif?id=
=3D109245043=27 /> </td></table><html><html><html><html><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=
                     <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><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, =26quot;Times New Roman=26quot;, Times, serif; font=
-size: 12px;=22 cellspacing=3D=220=22 cellpadding=3D=2210=22 border=3D=22=
0=22 bgcolor=3D=22=23ffffff=22 align=3D=22center=22>=0D=0A               =
                                                          <tbody>=0D=0A  =
                                                                         =
  <=21--img src=3D=22images/header=2Ejpg=22 alt=3D=22=22 /-->=0D=0A      =
                                                                       <t=
r>=0D=0A                                                                 =
                <td>=0D=0A                                               =
                                  <table style=3D=22width: 600px; height:=
 636px; font-family: Georgia, =27Times New Roman=27, Times, serif; font-s=
ize: 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                                                                   =
                      <tr>=0D=0A                                         =
                                                    <td style=3D=22paddin=
g: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=2Ej=
pg=22 usemap=3D=22=23image-map=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://bi=
gberryconsulting=2Ecom/=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=22facebook=22 href=3D=22https://www=2Efacebook=2Ecom/BigBerr=
yCnsltng/=22 coords=3D=22454,71,19=22 shape=3D=22circle=22 />=0D=0A      =
                                                                         =
              <area target=3D=22_blank=22 alt=3D=22instagram=22 title=3D=22=
instagram=22 href=3D=22https://www=2Einstagram=2Ecom/big=2Eberry=2Econsul=
ting/=22 coords=3D=22507,71,20=22 shape=3D=22circle=22 />=0D=0A          =
                                                                         =
          <area target=3D=22_blank=22 alt=3D=22twitter=22 title=3D=22twit=
ter=22 href=3D=22https://twitter=2Ecom/BigBerryCnsltng=22 coords=3D=22558=
,71,20=22 shape=3D=22circle=22 />=0D=0A                                  =
                                                           <area target=3D=
=22_blank=22 alt=3D=22linkedin=22 title=3D=22linkedin=22 href=3D=22https:=
//www=2Elinkedin=2Ecom/company/big-berry-consulting-sdn-bhd?trk=3Dtop_nav=
_home=22 coords=3D=22611,71,21=22 shape=3D=22circle=22 />=0D=0A          =
                                                                         =
          </map>=0D=0A                                                   =
                                          </div>=0D=0A                   =
                                                                         =
 </td>=0D=0A                                                             =
                            </tr>=0D=0A                                  =
                                                       <tr style=3D=22bac=
kground-color: white;=22>=0D=0A                                          =
                                                   <td style=3D=22width: =
600px; height: 96px; color: =23333333; font-family: Georgia, =26quot;Time=
s New Roman=26quot;, Times, serif; font-size: 28px; background-color: =23=
ed1c24;=22>=0D=0A                                                        =
                                     <div>=0D=0A                         =
                                                                    <div>=
<span style=3D=22font-family: 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><spa=
n style=3D=22font-family: 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 2016</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-s=
ize: 18pt;=22><span style=3D=22color: =23ffff00; font-size: 18pt;=22><str=
ong><span style=3D=22font-family: Arial; font-size: 12pt;=22>13 =26amp; 1=
4 SEPTEMBER 2021, ONLINE (ZOOM) 9AM - 5PM=26nbsp;</span></strong></span><=
/span><div><span style=3D=22color: =23ffffff;=22>HRDF Claimable</span></d=
iv>=0D=0A                                                                =
                             </div>=0D=0A                                =
                                                             </td>=0D=0A =
                                                                         =
               </tr>=0D=0A                                               =
                                          <tr>=0D=0A                     =
                                                                        <=
td><span style=3D=22color: =23000000; font-family: verdana, geneva; font-=
size: 10pt;=22></span>=0D=0A                                             =
                                                <div><span style=3D=22col=
or: black; line-height: 107=25; font-family: Verdana, sans-serif; font-si=
ze: 10pt;=22></span>=0D=0A                                               =
                                              <div><span style=3D=22font-=
size: 13=2E3333px; font-family: Verdana; color: =23000000;=22></span></di=
v>=0D=0A                                                                 =
                            <div style=3D=22text-align: justify; =22><spa=
n style=3D=22font-family: Verdana; font-size: 10pt; color: =23000000;=22>=
Microsoft Excel is one of the most powerful and popular data analysis des=
ktop application on the market today=2E By participating in this Microsof=
t Excel Data Analysis and Dashboard Reporting course you=27ll gain the wi=
dely sought after skills necessary to effectively analyze large sets of d=
ata=2E Once the data has been analyzed, clean and prepared for presentati=
on, you will learn how to present the data in an interactive dashboard re=
port=2E=26nbsp;</span></div>=0D=0A                                       =
                                                      <strong style=3D=22=
color: =23666666;=22><br />=0D=0A                                        =
                                                     <span style=3D=22fon=
t-family: verdana, geneva; color: =23ff0000; font-size: small;=22>PROGRAM=
 OBJECTIVES</span><span style=3D=22font-family: verdana, geneva; color: =23=
000000; font-size: small;=22><br />=0D=0A                                =
                                                             </span></str=
ong></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: Verdana; font-size: 10pt;=22>=26=238226;</sp=
an><span style=3D=22white-space:pre=22>=09</span><span style=3D=22font-fa=
mily: 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=238226;</span><span style=3D=22white-sp=
ace:pre=22>=09</span><span style=3D=22font-family: Verdana; font-size: 10=
pt;=22>Apply proper formula and function=2E=26nbsp;</span></div>=0D=0A   =
                                                                         =
                 <div><span style=3D=22font-family: Verdana; font-size: 1=
0pt;=22>=26=238226;</span><span style=3D=22white-space:pre=22>=09</span><=
span style=3D=22font-family: 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 styl=
e=3D=22white-space:pre=22>=09</span><span style=3D=22font-family: Verdana=
; font-size: 10pt;=22>Link and Embed Data from other sources=2E=26nbsp;</=
span></div>=0D=0A                                                        =
                                     <div><span style=3D=22font-family: V=
erdana; font-size: 10pt;=22>=26=238226;</span><span style=3D=22white-spac=
e: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><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>Adv=
anced Analytics Tools</span></div>=0D=0A                                 =
                                                            <div><span st=
yle=3D=22font-family: Verdana; font-size: 10pt;=22>=26=238226;</span><spa=
n style=3D=22white-space:pre=22>=09</span><span style=3D=22font-family: V=
erdana; font-size: 10pt;=22>Interactive Dashboard Reporting</span></div>=0D=
=0A                                                                      =
                       <div><span style=3D=22font-family: Verdana; font-s=
ize: 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-famil=
y: verdana, geneva; font-size: small; color: =23000000;=22><strong>PROGRA=
M OUTLINE</strong></span></div>=0D=0A                                    =
                                                         <div><span style=
=3D=22font-family: Verdana; color: =23000000; font-size: 10pt;=22><strong=
>DAY 1=26nbsp;</strong></span></div>=0D=0A                               =
                                                              <div><span =
style=3D=22font-family: Verdana; font-size: 10pt; color: =23000000;=22><s=
trong></strong></span></div>=0D=0A                                       =
                                                      <div><span style=3D=
=22font-family: Verdana; color: =23000000; font-size: 10pt;=22><strong>LE=
SSON 1: CUSTOMIZING THE EXCEL ENVIRONMENT=26nbsp;</strong>=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>Configure Excel Options=26nbsp;=26nbs=
p;</span></div>=0D=0A                                                    =
                                         <div><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>Customize the Ribbon and the=
 Quick Access Toolbar=26nbsp;=26nbsp;</span></div>=0D=0A                 =
                                                                         =
   <div><span style=3D=22font-family: Verdana; color: =23000000; font-siz=
e: 10pt;=22>=26=238226;</span><span style=3D=22white-space:pre=22>=09</sp=
an><span style=3D=22font-family: Verdana; color: =23000000; font-size: 10=
pt;=22>Enable Excel Add-Ins=26nbsp;=26nbsp;</span></div>=0D=0A           =
                                                                         =
         <div><br />=0D=0A                                               =
                                              </div>=0D=0A               =
                                                                         =
     <div><span style=3D=22font-family: Verdana; color: =23000000; font-s=
ize: 10pt;=22><strong>LESSON 2: KICK START WITH INTERMEDIATE TO ADVANCE F=
ORMULA AND FUNCTIONS=26nbsp;</strong></span></div>=0D=0A                 =
                                                                         =
   <div><span style=3D=22font-family: Verdana; color: =23000000; font-siz=
e: 10pt;=22>=26=238226;</span><span style=3D=22white-space:pre=22>=09</sp=
an><span style=3D=22font-family: Verdana; color: =23000000; font-size: 10=
pt;=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: Verdana; color: =23000000; font-size=
: 10pt;=22>Use Range Names in Formulas=26nbsp;=26nbsp;</span></div>=0D=0A=
                                                                         =
                    <div><span style=3D=22font-family: Verdana; color: =23=
000000; font-size: 10pt;=22>=26=238226;</span><span style=3D=22white-spac=
e:pre=22>=09</span><span style=3D=22font-family: Verdana; color: =2300000=
0; font-size: 10pt;=22>Use Specialized Functions=26nbsp;=26nbsp;</span></=
div>=0D=0A                                                               =
                              <div><span style=3D=22font-family: Verdana;=
 color: =23000000; font-size: 10pt;=22><strong>Building=26nbsp; Formulas=26=
nbsp;</strong></span></div>=0D=0A                                        =
                                                     <div><strong><span s=
tyle=3D=22font-family: Verdana; color: =23000000; font-size: 10pt;=22>=26=
=238226;</span><span style=3D=22white-space:pre=22>=09</span></strong><sp=
an 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; fo=
nt-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: =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>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 st=
yle=3D=22white-space:pre=22>=09</span><span style=3D=22font-family: Verda=
na; color: =23000000; font-size: 10pt;=22>Using Cell Ranges with a Functi=
on=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=22fon=
t-family: Verdana; color: =23000000; font-size: 10pt;=22>Excel Compatibil=
ity Functions=26nbsp; =26nbsp;</span></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>Formula Errors=26nbsp;=26nbsp;</span></strong></div>=0D=0A       =
                                                                         =
             <div><strong><span style=3D=22font-family: Verdana; color: =23=
000000; font-size: 10pt;=22>=26=238226;</span><span style=3D=22white-spac=
e:pre=22>=09</span><span style=3D=22font-family: Verdana; color: =2300000=
0; font-size: 10pt;=22>Logical 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=22=
white-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-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>Point-and-Click Formula Creati=
on=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=22fon=
t-family: Verdana; color: =23000000; font-size: 10pt;=22>Point-and-Click =
Formula Editing=26nbsp;=26nbsp;</span></div>=0D=0A                       =
                                                                      <di=
v><span style=3D=22font-family: Verdana; color: =23000000; font-size: 10p=
t;=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>T=
he Formulas Tab=2E=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><s=
pan style=3D=22font-family: Verdana; color: =23000000; font-size: 10pt;=22=
>Using the Insert Function Button=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><span style=3D=22font-family: Verdana; color: =23=
000000; font-size: 10pt;=22>Referencing in Formulas=26nbsp;=26nbsp;</span=
></strong></div>=0D=0A                                                   =
                                          <div><span style=3D=22font-fami=
ly: 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: Ver=
dana; color: =23000000; font-size: 10pt;=22>Absolute Cell References=26nb=
sp;</span></div>=0D=0A                                                   =
                                          <div><span style=3D=22font-fami=
ly: 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: Ver=
dana; color: =23000000; font-size: 10pt;=22>Partially Fixed References=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>Referring to Other W=
orksheets=26nbsp;=26nbsp;</span></div>=0D=0A                             =
                                                                <div><spa=
n 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>Referri=
ng to Other Workbooks=26nbsp;=26nbsp;</span></div>=0D=0A                 =
                                                                         =
   <div><span style=3D=22font-family: Verdana; color: =23000000; font-siz=
e: 10pt;=22><strong>Lookup, Reference, and Information Functions=26nbsp;=26=
nbsp;</strong></span></div>=0D=0A                                        =
                                                     <div><strong><span s=
tyle=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>The Basic =
Lookup=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><span style=3D=22font-family: Verdana; color: =23000000; font-size: =
10pt;=22>VLOOKUP(): Vertical Lookups=26nbsp;=26nbsp;</span></strong></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><span style=3D=22font-family: Verdana;=
 color: =23000000; font-size: 10pt;=22>HLOOKUP(): Horizontal Lookups=26nb=
sp;=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 st=
yle=3D=22font-family: Verdana; color: =23000000; font-size: 10pt;=22>Adva=
nced Lookups=26nbsp;=26nbsp;</span></strong></div>=0D=0A                 =
                                                                         =
   <div><span style=3D=22font-family: Verdana; color: =23000000; font-siz=
e: 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 Position of Items in a Range=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>INDEX(): Retrieving the Value from a =
Cell=26nbsp;=26nbsp;</span></div>=0D=0A                                  =
                                                           <div><span sty=
le=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=22=
font-family: Verdana; color: =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 Double Lookup=26nbsp;=26nbsp;</span></div>=0D=0A   =
                                                                         =
                 <div><strong><span style=3D=22font-family: Verdana; colo=
r: =23000000; font-size: 10pt;=22>=26=238226;</span><span style=3D=22whit=
e-space:pre=22>=09</span></strong><span style=3D=22font-family: Verdana; =
color: =23000000; font-size: 10pt;=22><strong>Information Functions=26nbs=
p;</strong>=26nbsp;</span></div>=0D=0A                                   =
                                                          <div><span styl=
e=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=22=
font-family: Verdana; color: =23000000; font-size: 10pt;=22>The =26=23822=
0;IS=26=238221; Functions: Checking the Value Inside a Cell=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>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 sty=
le=3D=22white-space:pre=22>=09</span><span style=3D=22font-family: Verdan=
a; color: =23000000; font-size: 10pt;=22>Tutorial: Generating Invoices fr=
om a Product Catalog=26nbsp;=26nbsp;</span></div>=0D=0A                  =
                                                                         =
  <div><span style=3D=22font-family: Verdana; color: =23000000; font-size=
: 10pt;=22><strong>Manipulating Dates, Times, and Text=26nbsp;=26nbsp;</s=
trong></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>Effective Data Hou=
sekeeping</span></strong></div>=0D=0A                                    =
                                                         <div><strong><sp=
an 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>Mani=
pulating Data</span></strong></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>CONCATENAT=
E(): Joining Strings of Text Together=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>LEFT(), MID(), and RIGHT(): Copying Portions of a Te=
xt String=26nbsp;=26nbsp;</span></div>=0D=0A                             =
                                                                <div><spa=
n 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>UPPER()=
, LOWER(), and PROPER(): Changing Capitalization=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=22=
white-space:pre=22>=09</span><span style=3D=22font-family: Verdana; color=
: =23000000; font-size: 10pt;=22>Date and Time Functions=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>TODAY() and NOW(): Inserting the Current =
Date and Time=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>DAY=
(), MONTH(), and YEAR(): More Date Calculations=26nbsp;=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>WEEKDAY(): 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 t=
he Difference Between Dates=26nbsp;=26nbsp;</span></div>=0D=0A           =
                                                                         =
         <div><span style=3D=22font-family: Verdana; color: =23000000; fo=
nt-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>DAYS360(): Finding Out the Number of Days Between Two Dates=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>YEARFRAC(): Calculat=
ing the Percentage of a Year Between Two Dates=26nbsp;=26nbsp;</span></di=
v>=0D=0A                                                                 =
                            <div><span style=3D=22font-family: Verdana; c=
olor: =23000000; font-size: 10pt;=22>=EF=82=A7</span><span style=3D=22whi=
te-space:pre=22>=09</span><span style=3D=22font-family: Verdana; color: =23=
000000; font-size: 10pt;=22>WEEKNUM(): Figuring Out in Which Week a Date =
Falls=26nbsp; =26nbsp;</span></div>=0D=0A                                =
                                                             <div><span s=
tyle=3D=22font-family: Verdana; color: =23000000; font-size: 10pt;=22><st=
rong>Advanced Formula Writing and Troubleshooting=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-space:pre=22>=09</span><span style=3D=22font-family: Ver=
dana; color: =23000000; font-size: 10pt;=22>Applying Criteria in Formulas=
=26nbsp;=26nbsp;</span></strong></div>=0D=0A                             =
                                                                <div><spa=
n 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>COUNTIF=
(): Counting Only the Cells You Specify=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>SUMIF(): Adding Only the Cells You Specify=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>COUNTIFS() and SUMIFS(): Co=
unting and Summing Using=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>=
Multiple Criteria=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></strong><span style=3D=22font-family: Verdana; color: =23000000; =
font-size: 10pt;=22><strong>Descriptive 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-space:pre=22>=09</span><span style=3D=22font=
-family: Verdana; color: =23000000; font-size: 10pt;=22>Creating and Usin=
g a Named Range=26nbsp;=26nbsp;</span></div>=0D=0A                       =
                                                                      <di=
v><span style=3D=22font-family: Verdana; color: =23000000; font-size: 10p=
t;=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>C=
reating Slightly Smarter Named Ranges=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>Naming Formulas and Constants=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>Managing Named Ranges=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>Automatically Creating Named Ranges=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>Applying Names to Ex=
isting Formulas=26nbsp;=26nbsp;</span></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><span style=3D=22font-family: Verdana; color: =23000000; font-size: =
10pt;=22>Controlling Recalculation=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=22=
white-space:pre=22>=09</span></strong><span style=3D=22font-family: Verda=
na; color: =23000000; font-size: 10pt;=22><strong>Solving Formula Errors=26=
nbsp;</strong>=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>Step-by-St=
ep Evaluation=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>Tra=
cing Precedents and Dependents=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>Error Checking=26nbsp;=26nbsp;</span></div>=0D=0A          =
                                                                         =
          <div><span style=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                       =
                                                                      <di=
v><span style=3D=22font-family: Verdana; color: =23000000; font-size: 10p=
t;=22><strong>LESSON 3: ANALYZING DATA WITH FUNCTIONS AND CONDITIONAL FOR=
MATTING=26nbsp;</strong>=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=
>Analyze Data by using Logical Functions=26nbsp;=26nbsp;</span></div>=0D=0A=
                                                                         =
                    <div><span style=3D=22font-family: Verdana; color: =23=
000000; font-size: 10pt;=22>=26=238226;</span><span style=3D=22white-spac=
e:pre=22>=09</span><span style=3D=22font-family: Verdana; color: =2300000=
0; font-size: 10pt;=22>Apply Advanced Conditional Formatting=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 4: ORGANIZI=
NG AND ANALYZING DATASETS AND TABLES=26nbsp;=26nbsp;</strong></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>Create and Modify SMART Tables=26nbsp;=26n=
bsp;</span></div>=0D=0A                                                  =
                                           <div><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>Sort =26amp;Filter Data=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>The Magic of SMART=
 tables</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-famil=
y: Verdana; color: =23000000; font-size: 10pt;=22>Use SUBTOTAL and Databa=
se Functions=26nbsp;</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>LE=
SSON 5: VISUALIZING DATA WITH DYNAMIC CHARTS=26nbsp;=26nbsp;</strong></sp=
an></div>=0D=0A                                                          =
                                   <div><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><span style=3D=22font-family: Verdana;=
 color: =23000000; font-size: 10pt;=22>Create Charts=26nbsp;=26nbsp;</spa=
n></div>=0D=0A                                                           =
                                  <div><span style=3D=22font-family: Verd=
ana; 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>Modify and Format Charts=26nbsp;=26nb=
sp;</span></div>=0D=0A                                                   =
                                          <div><span style=3D=22font-fami=
ly: Verdana; color: =23000000; font-size: 10pt;=22>=26=238226;</span><spa=
n style=3D=22white-space:pre=22>=09</span><span style=3D=22font-family: V=
erdana; color: =23000000; font-size: 10pt;=22>Preparing Dynamic Features =
on the Charts</span></div>=0D=0A                                         =
                                                    <div><br />=0D=0A    =
                                                                         =
                </div>=0D=0A                                             =
                                                <div><span style=3D=22fon=
t-family: Verdana; color: =23000000; font-size: 10pt;=22><strong>LESSON 6=
: USING PIVOT TABLES=26nbsp;</strong></span></div>=0D=0A                 =
                                                                         =
   <div><span style=3D=22font-family: Verdana; color: =23000000; font-siz=
e: 10pt;=22><strong>This module explains how to use Pivot Tables=2E=26nbs=
p;=26nbsp;</strong></span></div>=0D=0A                                   =
                                                          <div><span styl=
e=3D=22font-family: Verdana; color: =23000000; font-size: 10pt;=22><stron=
g>Lessons=26nbsp;=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>Creating Pivot 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: =23000000; font-size=
: 10pt;=22>Inserting Slicers=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>Working with Pivot Tables=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>Inserting Pivot Charts=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>More Pivot Table Functionality=26nbsp;</span></div>=0D=0A       =
                                                                         =
             <div><span style=3D=22font-family: Verdana; color: =23000000=
; font-size: 10pt;=22><strong>Lab: Using Pivot Tables=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>Working with Pivot Tables=26nbsp;=
</span></div>=0D=0A                                                      =
                                       <div><span style=3D=22font-family:=
 Verdana; color: =23000000; font-size: 10pt;=22><strong>After completing =
this module, students will be able to:=26nbsp;</strong></span></div>=0D=0A=
                                                                         =
                    <div><span style=3D=22font-family: Verdana; color: =23=
000000; font-size: 10pt;=22>=26=238226;</span><span style=3D=22white-spac=
e:pre=22>=09</span><span style=3D=22font-family: Verdana; color: =2300000=
0; font-size: 10pt;=22>Use pivot tables to analyze data=2E=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>Edit pivot tables=2E=26nbsp;</span></=
div>=0D=0A                                                               =
                              <div><span style=3D=22font-family: Verdana;=
 color: =23000000; font-size: 10pt;=22>=26=238226;</span><span style=3D=22=
white-space:pre=22>=09</span><span style=3D=22font-family: Verdana; color=
: =23000000; font-size: 10pt;=22>Format pivot tables=2E=26nbsp;</span></d=
iv>=0D=0A                                                                =
                             <div><span style=3D=22font-family: Verdana; =
color: =23000000; font-size: 10pt;=22>=26=238226;</span><span style=3D=22=
white-space:pre=22>=09</span><span style=3D=22font-family: Verdana; color=
: =23000000; font-size: 10pt;=22>Insert pivot charts=2E=26nbsp;</span></d=
iv>=0D=0A                                                                =
                             <div><span style=3D=22font-family: Verdana; =
color: =23000000; font-size: 10pt;=22>=26=238226;</span><span style=3D=22=
white-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 style=3D=22font-family: Verdana; color: =23000000; f=
ont-size: 10pt;=22>=26=238226;</span><span style=3D=22white-space:pre=22>=
=09</span><span style=3D=22font-family: Verdana; color: =23000000; font-s=
ize: 10pt;=22>Preparing Analysis, Survey and reporting KPIs</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 7: PREPARING A SIMPLIFIED DASH=
BOARD REPORTING =26amp; DATA 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 BUS=
INESS INTELLIGENT TOOLS (POWER BI)</strong></span></div>=0D=0A           =
                                                                         =
         <div><span style=3D=22font-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><span style=3D=22color: =23ff0000; font-famil=
y: verdana, geneva; font-size: 10pt;=22><strong>TRAINER PROFILE=26nbsp; <=
/strong></span></div>=0D=0A                                              =
                                               <div>=0D=0A               =
                                                                         =
     <div><span style=3D=22font-size: 10pt; font-family: Verdana;=22></sp=
an></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 diligent and dedicated Computer Science educatio=
nist with 18 years=26=238217; experience in ICT and Softskill training es=
pecially for private and government agencies around Malaysia and Singapor=
e=2E Track record of consistently building the participants=26=238217; ca=
libre and knowledge in Information Technology, Business Communication and=
 Self-development skills=2E Committed to provide high quality corporate t=
raining at all levels=2E Profound ability to develop productive and effec=
tual 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>Subst=
antial knowledge of age specific effective teaching and instructional str=
ategies</strong></span></div>=0D=0A                                      =
                                                       <div style=3D=22te=
xt-align: justify; =22><span style=3D=22font-family: Verdana; font-size: =
10pt;=22><strong>Solid experience in supervising ICT related practical pr=
ojects as client=26=238217;s requirement=2E</strong></span></div>=0D=0A  =
                                                                         =
                  <div style=3D=22text-align: justify; =22><span style=3D=
=22font-family: Verdana; font-size: 10pt;=22>She had vast of experiences =
in Microsoft Office especially Microsoft Excel training, which covering m=
ulti-national businesses, local businesses, and non-profit organizations=2E=
 She specialize in Computer Courses=26=238211;Microsoft Office Applicatio=
n ver=2E 2013/2010/2007/2003 such as: Microsoft Outlook (Basic=26=238211;=
Expert Level)/ Microsoft with VBA (Basic-Expert Level)/ Adobe Photoshop (=
Basic-Expert Level)/ Adobe In Design (Basic-Expert level)/ Adobe Flash (B=
asic-Expert Level)/ Adobe Flash (Basic-Expert Level)/ Adobe Premier (Basi=
c-Expert Level)/ Adobe Illustrator (Basic-Expert Level)/ Web Designing/ W=
eb programming/ Internet Appreciation Courses/ Window 8/7/XP/2000=26=2382=
11;JavaScript Basic (Basic-Expert Level)/ Movie Maker/ HTML Basic-Advance=
/ Lotus Notes Basic-Advance/ ITL Foundation</span></div>=0D=0A           =
                                                                         =
         <div style=3D=22text-align: justify; =22><span style=3D=22font-f=
amily: Verdana; font-size: 10pt;=22>She has trained corporations includin=
g Port Of Tanjung Pelepas, Port of Tanjung Langsat, JAKIM, Universiti Isl=
am Antarabangsa Malaysia, Universiti Teknologi Malaysia, Tenaga Nasional =
Berhad, Sistem Air Johor, Technip (AsiaFlex Products Sdn Bhd) , UEM,=26nb=
sp; Ministry Of Health Malaysia, PSMB, Genting Properties Sdn Bhd, TV3, P=
olis DiRaja Malaysia, Dyson, Iskandar Regional Development Authorities (I=
RDA, Johor), IOI Properties, CIDB Malaysia=2E</span></div>=0D=0A         =
                                                                         =
           <div style=3D=22text-align: justify; =22><span style=3D=22font=
-family: Verdana; font-size: 10pt;=22>On a personal level, she is a stron=
g believer of continual improvement is a journey of self-learning=2E In h=
er classes, she guides the participants on forming their own solutions=2E=
 She received regular feedback from her participants for being inspiring =
in her nature=2E She relates her trainings and teaching with the practica=
l side of the corporate world=2E She is known as a trainer and teacher wh=
o instil the essence of learning</span></div>=0D=0A                      =
                                                                       <d=
iv><br />=0D=0A                                                          =
                                   </div>=0D=0A                          =
                                                                   <div><=
span style=3D=22font-size: 10pt; font-family: Verdana;=22></span></div>=0D=
=0A                                                                      =
                       <span style=3D=22color: =23000000; font-family: ve=
rdana, geneva; font-size: 10pt;=22><strong><span style=3D=22color: =23ff0=
000; font-size: 12pt;=22>Call us to get full brochure</span></strong></sp=
an></div>=0D=0A                                                          =
                                   </td>=0D=0A                           =
                                                              </tr>=0D=0A=
                                                                         =
                <tr>=0D=0A                                               =
                                              <td style=3D=22text-align: =
justify; color: =23666666; background-color: whitesmoke;=22>=0D=0A       =
                                                                         =
             <div><span style=3D=22color: =23000000; font-family: verdana=
, geneva; font-size: 12pt;=22><strong>TRAINING FEE</strong></span></div>=0D=
=0A                                                                      =
                       <div><span style=3D=22color: =23000000;=22><span s=
tyle=3D=22color: =23000000; font-family: verdana, geneva; font-size: 12pt=
;=22><strong>NORMAL PRICE RM 1,399 </strong></span><span style=3D=22color=
: =23000000; font-family: verdana, geneva; font-size: 8pt;=22><strong>(Ex=
cl=2E 6=25 SST)</strong></span></span><br />=0D=0A                       =
                                                                      <sp=
an style=3D=22color: =23000000; font-family: verdana, geneva; font-size: =
12pt;=22>GROUP DISCOUNT 10=25=26nbsp;(5 and above)</span></div>=0D=0A    =
                                                                         =
                </td>=0D=0A                                              =
                                           </tr>=0D=0A                   =
                                                                      <tr=
>=0D=0A                                                                  =
                           <td style=3D=22text-align: justify; color: =23=
666666;=22>=0D=0A                                                        =
                                     <p><span style=3D=22color: =23000000=
; font-family: Verdana; font-size: 10pt;=22><strong>Please call us for mo=
re information or BROCHURE</strong></span><br />=0D=0A                   =
                                                                         =
 <span style=3D=22color: =23000000; font-family: Verdana; font-size: 10pt=
;=22><strong>Tel: +6(03) 8079 0904 / +6(03) 8079 0905 / +6012 3838079 / +=
6018 2053388 /+6018 2052366 </strong></span></p>=0D=0A                   =
                                                                         =
 <div><span style=3D=22color: =23000000; font-family: Verdana; font-size:=
 10pt;=22>Michelle (<a href=3D=22mailto:michelle=40bigberryconsulting=2Ec=
om=22><span style=3D=22font-size: 10pt; color: =23000000;=22>michelle=40b=
igberryconsulting=2Ecom</span></a></span><span style=3D=22color: =2300000=
0; font-family: Verdana; font-size: 10pt;=22>)<br />=0D=0A               =
                                                                         =
     </span><span style=3D=22color: =23000000; font-family: Verdana; font=
-size: 10pt;=22>Brian (brian<a href=3D=22mailto:thaneswary=40bigberrycons=
ulting=2Ecom=22><span style=3D=22font-size: 10pt; color: =23000000;=22>=40=
bigberryconsulting=2Ecom</span></a></span><span style=3D=22color: =230000=
00; font-family: Verdana; font-size: 10pt;=22>)<br />=0D=0A              =
                                                                         =
      </span><span style=3D=22color: =23000000; font-family: Verdana; fon=
t-size: 10pt;=22> Mimi Wahida (<a href=3D=22mailto:mohd=2Enasrulshah=40bi=
gberryconsulting=2Ecom=22><span style=3D=22font-size: 10pt; color: =23000=
000;=22>mimi=2Ewahida=40bigberryconsulting=2Ecom</span></a></span><span s=
tyle=3D=22color: =23000000; font-family: Verdana; font-size: 10pt;=22>)<b=
r />=0D=0A                                                               =
                              </span><span style=3D=22color: =23000000; f=
ont-family: Verdana; font-size: 10pt;=22> Fara Ahmad</span><span style=3D=
=22font-family: Verdana; font-size: 10pt; color: =23000000;=22> (</span><=
a href=3D=22mailto:fara=40bigberryconsulting=2Ecom=22><span style=3D=22fo=
nt-family: Verdana; font-size: 10pt; color: =23000000;=22>fara=40bigberry=
consulting=2Ecom</span></a><span style=3D=22font-family: Verdana; font-si=
ze: 10pt; color: =23000000;=22>)</span><br />=0D=0A                      =
                                                                       <s=
pan 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=40bigbe=
rryconsulting=2Ecom=22><span style=3D=22font-family: Verdana; font-size: =
10pt; color: =23000000;=22>nurul=2Enadia=40bigberryconsulting=2Ecom</span=
></a><span style=3D=22font-family: Verdana; font-size: 10pt; color: =2300=
0000;=22>)</span><br />=0D=0A                                            =
                                                 <span style=3D=22color: =
=23000000; font-family: Verdana;=22><br />=0D=0A                         =
                                                                    </spa=
n><span style=3D=22color: =23000000; font-family: Verdana; font-size: 10p=
t;=22> More courses, visit </span><span style=3D=22font-family: Verdana;=22=
><a href=3D=22http://www=2Ebigberryconsulting=2Ecom/=22><span style=3D=22=
font-size: 10pt; color: =23000000;=22>http://www=2Ebigberryconsulting=2Ec=
om/</span></a></span></div>=0D=0A                                        =
                                                     <div>=0D=0A         =
                                                                         =
           <div><font face=3D=22Verdana=22></font>=26nbsp;</div>=0D=0A   =
                                                                         =
                 <div><span style=3D=22color: =23000000; font-family: Ver=
dana; font-size: 12pt;=22><strong>Note: All this program can be customise=
d for In-House Training=2E Call us for Proposal</strong></span></div>=0D=0A=
                                                                         =
                    </div>=0D=0A                                         =
                                                    </td>=0D=0A          =
                                                                         =
      </tr>=0D=0A                                                        =
                                 <tr bgcolor=3D=22=23c41111=22 style=3D=22=
font-family: sans-serif;background-repeat: no-repeat;background-position:=
 bottom;background-image: url(http://bigberryconsulting=2Ecom/newsletter/=
jan_2020/images/bgimage2=2Ejpg);background-size: cover;padding: 25px 0px;=
 margin-bottom: 0px;height: 60px;=22>=0D=0A                              =
                                                               <td color=3D=
=22=23c41111=22 align=3D=22center=22>=0D=0A                              =
                                                               <div class=
=3D=22mar-none back_red=22>=0D=0A                                        =
                                                     <span>=0D=0A        =
                                                                         =
            <span class=3D=22card-header text-center bor-none=22 style=3D=
=22border: none;background-color: transparent;text-align: center=21import=
ant;color: =23fff=21important;border-radius: calc(=2E25rem - 1px) calc(=2E=
25rem - 1px) 0 0;=22>=0D=0A                                              =
                                               Copyright =40 2019 Bigberr=
y Consulting Sdn Bhd=2E All Rights Reserved=0D=0A                        =
                                                                     </sp=
an>=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 fut=
ure mailings, or if you feel you have been wrongfully placed in our maili=
nglist,=0D=0A                                                            =
                                 please reply the email by saying </span>=
<span style=3D=22font-size: 12pt; font-family: Verdana; background-color:=
 =23ffff00;=22><strong>UNSUBSCRIBE</strong></span><span style=3D=22font-s=
ize: 12pt; font-family: Verdana; background-color: =2300ff00;=22>=2E We w=
ill discontinue the email=26nbsp;=26nbsp;</span></td>=0D=0A              =
                                                                         =
  </tr>=0D=0A                                                            =
                         </tbody>=0D=0A                                  =
                                               </table>=0D=0A            =
                                                                     </td=
>=0D=0A                                                                  =
           </tr>=0D=0A                                                   =
                      </tbody>=0D=0A                                     =
                                </table>=0D=0A                           =
                                          </div>=0D=0A                   =
                                                  <div id=3D=22UMS_TOOLTI=
P=22 style=3D=22position: absolute; cursor: pointer; z-index: 2147483647;=
 background: transparent; top: -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 =0D=0A=
 =0D=0A =0D=0A =0D=0A </body></html><br></html>=0D=0A