Envelope-to: edward@transocean.com
Delivery-date: Thu, 03 Aug 2017 06:48:55 -0700
To: <edward@transocean.com>
Subject: =?UTF-8?Q?Excel_Training:_Mastering_Advanced_Lookup_Functions?=
From: =?UTF-8?Q?Course=20Updates?= <events@webinars.grceducators.com>
Content-Type: multipart/alternative; boundary="-------?=_37719-5267276991572"
MIME-Version: 1.0
Precedence: bulk
Feedback-ID: ded_213.32.141.128:1620427:1620427_874:Sendinblue
Reply-To: events@webinars.grceducators.com
Message-Id: <201708031439.5dnzfymi5c3lvjj@webinars.grceducators.com>
Date: Thu, 03 Aug 2017 14:39:27 +0200
 
 Content preview:  If you are not able to see this mail, click http://r.webinars.grceducators.com/2phwo2ztr43lvjf.html 
        [ ]( http://r.webinars.grceducators.com/click/atzmobzazxc3lvjd.html
    )   Course Summary   This webinar focuses on alternatives to the VLOOKUP
    function. While many Excel users rely on VLOOKUP for basic lookup functionality,
    it’s often because they’re unaware of other functions that can enable
    them to work more efficiently in Excel. David sheds light on what can go
   awry with VLOOKUP; explains how to future-proof VLOOKUP; and discusses alternative
    functions, including IFNA, MATCH, SUMIF, SUMIFS, IFERROR, CHOOSE, and OFFSET.
      Attend this webinar to identify the limitation of VLOOKUP and learn about
    alternative functions. Understand which version of Excel support the IFNA
    worksheet function. And the state why the INDEX and MATCH combination often
    is superior to VLOOKUP or HLOOKUP. [...] 
 
 Content analysis details:   (-0.2 points, 3.0 required)
 
  pts rule name              description
 ---- ---------------------- --------------------------------------------------
  1.8 REMOVE_BEFORE_LINK     BODY: Removal phrase right before a link
  0.0 URIBL_BLOCKED          ADMINISTRATOR NOTICE: The query to URIBL was blocked.
                             See
                             http://wiki.apache.org/spamassassin/DnsBlocklists#dnsbl-block
                              for more information.
                             [URIs: grceducators.com]
  0.0 T_SPF_PERMERROR        SPF: test of record failed (permerror)
  0.0 T_SPF_HELO_PERMERROR   SPF: test of HELO record failed (permerror)
 -0.0 RP_MATCHES_RCVD        Envelope sender domain matches handover relay domain
 -1.9 BAYES_00               BODY: Bayes spam probability is 0 to 1%
                             [score: 0.0000]
  0.0 HTML_FONT_LOW_CONTRAST BODY: HTML font color similar or identical to
                             background
  0.0 HTML_MESSAGE           BODY: HTML included in message
 -0.1 DKIM_VALID             Message has at least one valid DKIM or DK signature
  0.1 DKIM_SIGNED            Message has a DKIM or DK signature, not necessarily valid
 -0.1 DKIM_VALID_AU          Message has a valid DKIM or DK signature from author's
                             domain
X-Spam-Flag: NO


---------?=_37719-5267276991572
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

If you are not able to see this mail, click http://r.webinars.grceducators.=
com/2phwo2ztr43lvjf.html=C2=A0=0A=C2=A0=0A=C2=A0=0A[   ]( http://r.webinars=
.grceducators.com/click/atzmobzazxc3lvjd.html )    =C2=A0  Course Summary =
=C2=A0=0A=0AThis webinar focuses on alternatives to the VLOOKUP function. W=
hile many Excel users rely on VLOOKUP for basic lookup functionality, it=
=E2=80=99s often because they=E2=80=99re unaware of other functions that ca=
n enable them to work more efficiently in Excel. David sheds light on what =
can go awry with VLOOKUP; explains how to future-proof VLOOKUP; and discuss=
es alternative functions, including IFNA, MATCH, SUMIF, SUMIFS, IFERROR, CH=
OOSE, and OFFSET.=0A=C2=A0=0AAttend this webinar to identify the limitation=
 of VLOOKUP and learn about alternative functions. Understand which version=
 of Excel support the IFNA worksheet function. And the state why the INDEX =
and MATCH combination often is superior to VLOOKUP or HLOOKUP.=0A=0A=C2=
=A0=0ALearning objectives=0AIdentify the limitations of VLOOKUP and learn a=
bout alternative functions. List which versions of Excel support the IFNA w=
orksheet function. State why the INDEX and MATCH combination often is super=
ior to VLOOKUP or HLOOKUP      =C2=A0=0A=C2=A0      [ =C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0 REGISTER NOW=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 ]( http://r.webinar=
s.grceducators.com/click/atzmobzb0ps3lvjd.html )      =C2=A0     =C2=A0=0A=
=0AEvent Marketing | GRC Educators | 740-870-0321 | support@grceducators.co=
m | www.grceducators.com | 806 Clark Street, P.O Box 171, Philo, OH-43771 U=
SA=0A=C2=A0=0A[ Unsubscribe here ]( http://r.webinars.grceducators.com/2phw=
o2ztr43lvjg.html ) =C2=A0     =C2=A0=0A=0A=C2=A9 2017 GRC Educators  =C2=
=A0


---------?=_37719-5267276991572
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.=
w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns=3D"http://www.w3.=
org/1999/xhtml" xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:sc=
hemas-microsoft-com:office:office"><head><meta http-equiv=3D"X-UA-Compatibl=
e" content=3D"IE=3Dedge" /><meta name=3D"viewport" content=3D"width=3Ddevic=
e-width, initial-scale=3D1" /><meta http-equiv=3D"Content-Type" content=3D"=
text/html; charset=3Dutf-8" /><meta name=3D"apple-mobile-web-app-capable" c=
ontent=3D"yes" /><meta name=3D"apple-mobile-web-app-status-bar-style" conte=
nt=3D"black" /><meta name=3D"format-detection" content=3D"telephone=3Dno" /=
><title>Excel Training: Mastering Advanced Lookup Functions</title><style t=
ype=3D"text/css">=0A        /* Resets */=0A        .ReadMsgBody { width: 10=
0%; background-color: #ebebeb;}=0A        .ExternalClass {width: 100%; back=
ground-color: #ebebeb;}=0A        .ExternalClass, .ExternalClass p, .Extern=
alClass span, .ExternalClass font, .ExternalClass td, .ExternalClass div {l=
ine-height:100%;}=0A        a[x-apple-data-detectors]{=0A            color:=
inherit !important;=0A            text-decoration:none !important;=0A      =
      font-size:inherit !important;=0A            font-family:inherit !impo=
rtant;=0A            font-weight:inherit !important;=0A            line-hei=
ght:inherit !important;=0A        }        =0A        body {-webkit-text-si=
ze-adjust:none; -ms-text-size-adjust:none;}=0A        body {margin:0; paddi=
ng:0;}=0A        .yshortcuts a {border-bottom: none !important;}=0A        =
.rnb-del-min-width{ min-width: 0 !important; }=0A=0A        /* Add new outl=
ook css start */=0A        .templateContainer{=0A            max-width:590p=
x !important;=0A            width:auto !important;=0A        }=0A        /*=
 Add new outlook css end */=0A=0A        /* Image width by default for 3 co=
lumns */=0A        img[class=3D"rnb-col-3-img"] {=0A        max-width:170px=
;=0A        }=0A=0A        /* Image width by default for 2 columns */=0A   =
     img[class=3D"rnb-col-2-img"] {=0A        max-width:264px;=0A        }=
=0A=0A        /* Image width by default for 2 columns aside small size */=
=0A        img[class=3D"rnb-col-2-img-side-xs"] {=0A        max-width:180px=
;=0A        }=0A=0A        /* Image width by default for 2 columns aside bi=
g size */=0A        img[class=3D"rnb-col-2-img-side-xl"] {=0A        max-wi=
dth:350px;=0A        }=0A=0A        /* Image width by default for 1 column =
*/=0A        img[class=3D"rnb-col-1-img"] {=0A        max-width:550px;=0A  =
      }=0A=0A        /* Image width by default for header */=0A        img[=
class=3D"rnb-header-img"] {=0A        max-width:590px;=0A        }=0A=0A   =
     /* Ckeditor line-height spacing */=0A        .rnb-force-col p, ul, ol{=
margin:0px!important;}=0A        .rnb-del-min-width p, ul, ol{margin:0px!im=
portant;}=0A=0A        /* tmpl-2 preview */=0A        .rnb-tmpl-width{ widt=
h:100%!important;}=0A=0A        /* tmpl-11 preview */=0A        .rnb-social=
-width{padding-right:15px!important;}=0A=0A        /* tmpl-11 preview */=0A=
        .rnb-social-align{float:right!important;}=0A=0A        @media only =
screen and (min-width:590px){=0A        /* mac fix width */=0A        .temp=
lateContainer{width:590px !important;}=0A        }=0A=0A        @media scre=
en and (max-width: 360px){=0A        /* yahoo app fix width "tmpl-2 tmpl-10=
 tmpl-13" in android devices */=0A        .rnb-yahoo-width{ width:360px!imp=
ortant;}=0A        }=0A=0A        @media screen and (max-width: 480px) {=0A=
        td[class=3D"rnb-container-padding"] {=0A        padding-left: 10px =
!important;=0A        padding-right: 10px !important;=0A        }=0A=0A    =
    /* force container nav to (horizontal) blocks */=0A        td[class=3D"=
rnb-force-nav"] {=0A        display: block;=0A        }=0A        }=0A=0A  =
      @media only screen and (max-width : 600px) {=0A=0A        /* center t=
he address &amp; social icons */=0A        .rnb-text-center {text-align:cen=
ter !important;}=0A=0A        /* force container columns to (horizontal) bl=
ocks */=0A        td[class~=3D"rnb-force-col"] {=0A        display: block;=
=0A        padding-right: 0 !important;=0A        padding-left: 0 !importan=
t;=0A        width:100%;=0A        }=0A=0A        table[class~=3D"rnb-conta=
iner"] {=0A         width: 100% !important;=0A        }=0A=0A        table[=
class=3D"rnb-btn-col-content"] {=0A        width: 100% !important;=0A      =
  }=0A        table[class=3D"rnb-col-3"] {=0A        /* unset table align=
=3D"left/right" */=0A        float: none !important;=0A        width: 100% =
!important;=0A=0A        /* change left/right padding and margins to top/bo=
ttom ones */=0A        margin-bottom: 10px;=0A        padding-bottom: 10px;=
=0A        /*border-bottom: 1px solid #eee;*/=0A        }=0A=0A        tabl=
e[class=3D"rnb-last-col-3"] {=0A        /* unset table align=3D"left/right"=
 */=0A        float: none !important;=0A        width: 100% !important;=0A =
       }=0A=0A        table[class=3D"rnb-col-2"] {=0A        /* unset table=
 align=3D"left/right" */=0A        float: none !important;=0A        width:=
 100% !important;=0A=0A        /* change left/right padding and margins to =
top/bottom ones */=0A        margin-bottom: 10px;=0A        padding-bottom:=
 10px;=0A        /*border-bottom: 1px solid #eee;*/=0A        }=0A=0A      =
  table[class=3D"rnb-col-2-noborder-onright"] {=0A        /* unset table al=
ign=3D"left/right" */=0A        float: none !important;=0A        width: 10=
0% !important;=0A=0A        /* change left/right padding and margins to top=
/bottom ones */=0A        margin-bottom: 10px;=0A        padding-bottom: 10=
px;=0A        }=0A=0A        table[class=3D"rnb-col-2-noborder-onleft"] {=
=0A        /* unset table align=3D"left/right" */=0A        float: none !im=
portant;=0A        width: 100% !important;=0A=0A        /* change left/righ=
t padding and margins to top/bottom ones */=0A        margin-top: 10px;=0A =
       padding-top: 10px;=0A        }=0A=0A        table[class=3D"rnb-last-=
col-2"] {=0A        /* unset table align=3D"left/right" */=0A        float:=
 none !important;=0A        width: 100% !important;=0A        }=0A=0A      =
  table[class=3D"rnb-col-1"] {=0A        /* unset table align=3D"left/right=
" */=0A        float: none !important;=0A        width: 100% !important;=0A=
        }=0A=0A        img[class=3D"rnb-col-3-img"] {=0A        /**max-widt=
h:none !important;**/=0A        width:100% !important;=0A        }=0A=0A   =
     img[class=3D"rnb-col-2-img"] {=0A        /**max-width:none !important;=
**/=0A        width:100% !important;=0A        }=0A=0A        img[class=3D"=
rnb-col-2-img-side-xs"] {=0A        /**max-width:none !important;**/=0A    =
    width:100% !important;=0A        }=0A=0A        img[class=3D"rnb-col-2-=
img-side-xl"] {=0A        /**max-width:none !important;**/=0A        width:=
100% !important;=0A        }=0A=0A        img[class=3D"rnb-col-1-img"] {=0A=
        /**max-width:none !important;**/=0A        width:100% !important;=
=0A        }=0A=0A        img[class=3D"rnb-header-img"] {=0A        /**max-=
width:none !important;**/=0A        width:100% !important;=0A        margin=
:0 auto;=0A        }=0A=0A        img[class=3D"rnb-logo-img"] {=0A        /=
**max-width:none !important;**/=0A        width:100% !important;=0A        =
}=0A=0A        td[class=3D"rnb-mbl-float-none"] {=0A        float:inherit !=
important;=0A        }=0A=0A        .img-block-center{text-align:center!imp=
ortant;}=0A=0A        .logo-img-center=0A        {=0A            float:inhe=
rit!important;=0A        }=0A=0A        /* tmpl-11 preview */=0A        .rn=
b-social-align{margin:0 auto!important; float:inherit!important;}=0A=0A    =
    /* tmpl-11 preview */=0A        .rnb-social-center{display:inline-block=
;}=0A=0A    }</style><!--[if gte mso 11]><style type=3D"text/css">table{bor=
der-spacing: 0; }table td {border-collapse: separate;}</style><![endif]--><=
!--[if !mso]><!--><style type=3D"text/css">table{border-spacing: 0;} table =
td {border-collapse: collapse;}</style> <!--<![endif]--><!--[if gte mso 15]=
><xml><o:OfficeDocumentSettings><o:AllowPNG/><o:PixelsPerInch>96</o:PixelsP=
erInch></o:OfficeDocumentSettings></xml><![endif]--><!--[if gte mso 9]><xml=
><o:OfficeDocumentSettings><o:AllowPNG/><o:PixelsPerInch>96</o:PixelsPerInc=
h></o:OfficeDocumentSettings></xml><![endif]--></head><body>=0A=0A<table cl=
ass=3D"main-template" style=3D"background-color:#e8e8e8;" width=3D"100%" ce=
llspacing=3D"0" cellpadding=3D"0" border=3D"0" bgcolor=3D"#e8e8e8" align=3D=
"center">=0A=0A=09<tbody><tr style=3D"display:none !important; font-size:1p=
x; mso-hide: all;"><td></td><td></td></tr>=0A    <tr>=0A        <td valign=
=3D"top" align=3D"center">=0A        <!--[if gte mso 9]>=0A                =
        <table align=3D"center" border=3D"0" cellspacing=3D"0" cellpadding=
=3D"0" width=3D"590" style=3D"width:590px;">=0A                        <tr>=
=0A                        <td align=3D"center" valign=3D"top" width=3D"590=
" style=3D"width:590px;">=0A                        <![endif]-->=0A        =
    <table class=3D"templateContainer" style=3D"max-width:590px!important; =
width: 590px;" width=3D"100%" cellspacing=3D"0" cellpadding=3D"0" border=3D=
"0">=0A        <tbody><tr>=0A=0A        <td style=3D"background-color:#e8e8=
e8;" valign=3D"top" bgcolor=3D"#e8e8e8" align=3D"center">=0A=0A            =
<div>=0A                <!--[if mso]>=0A                <table align=3D"lef=
t" border=3D"0" cellspacing=3D"0" cellpadding=3D"0" width=3D"100%" style=3D=
"width:100%;">=0A                <tr>=0A                <![endif]-->=0A    =
            =0A                <!--[if mso]>=0A                <td valign=
=3D"top" width=3D"590" style=3D"width:590px;">=0A                <![endif]-=
->=0A            <table class=3D"rnb-del-min-width" style=3D"min-width:590p=
x; background-color:#e8e8e8;" name=3D"Layout_1" id=3D"Layout_1" width=3D"10=
0%" cellspacing=3D"0" cellpadding=3D"0" border=3D"0" bgcolor=3D"#e8e8e8">=
=0A                <tbody><tr>=0A                    <td class=3D"rnb-del-m=
in-width" style=3D"min-width:590px; background-color: #e8e8e8;" valign=3D"t=
op" bgcolor=3D"#e8e8e8" align=3D"center">=0A                        <table =
class=3D"rnb-container" style=3D"background-color: rgb(255, 255, 255); bord=
er-radius: 0px; padding-left: 20px; padding-right: 20px; border-collapse: s=
eparate;" width=3D"100%" cellspacing=3D"0" cellpadding=3D"0" border=3D"0" b=
gcolor=3D"#ffffff">=0A                            <tbody><tr>=0A           =
                     <td style=3D"font-size:1px; line-height:1px;" height=
=3D"0">&nbsp;</td>=0A                            </tr>=0A                  =
          <tr>=0A                                <td class=3D"rnb-container=
-padding" style=3D"background-color: #ffffff;" valign=3D"top" bgcolor=3D"#f=
fffff" align=3D"left">=0A                                    <table width=
=3D"100%" cellspacing=3D"0" cellpadding=3D"0" border=3D"0" align=3D"center"=
>=0A                                        <tbody><tr>=0A                 =
                           <td valign=3D"top" align=3D"center">=0A         =
                                       <table ng-class=3D"{'logo-img-center=
':col.td.align}" class=3D"logo-img-center" cellspacing=3D"0" cellpadding=3D=
"0" border=3D"0" align=3D"left"> =0A                                       =
             <tbody><tr>=0A                                                =
        <td valign=3D"middle" align=3D"center">=0A                         =
                                   <div style=3D"border-top:0px None #000;b=
order-right:0px None #000;border-bottom:0px None #000;border-left:0px None =
#000;display:inline-block;"><img alt=3D"[&quot;Axons Technology and solutio=
ns Pvt Ltd&quot;]" style=3D"max-width:140px;display:block;" class=3D"rnb-lo=
go-img" src=3D"http://img.webinars.grceducators.com/2nqezxc3lvje.png" width=
=3D"140" vspace=3D"0" hspace=3D"0" border=3D"0"></div></td>=0A             =
                                       </tr>=0A                            =
                    </tbody></table>=0A                                    =
            </td>=0A                                        </tr>=0A       =
                             </tbody></table></td>=0A                      =
      </tr>=0A                            <tr>=0A                          =
      <td style=3D"font-size:1px; line-height:1px;" height=3D"0">&nbsp;</td=
>=0A                            </tr>=0A                        </tbody></t=
able>=0A                    </td>=0A                </tr>=0A            </t=
body></table>=0A            <!--[if mso]>=0A                </td>=0A       =
         <![endif]-->=0A                =0A                <!--[if mso]>=0A=
                </tr>=0A                </table>=0A                <![endif=
]-->=0A        </div></td>=0A    </tr><tr>=0A=0A        <td style=3D"backgr=
ound-color:#e8e8e8;" valign=3D"top" bgcolor=3D"#e8e8e8" align=3D"center">=
=0A=0A            <div>=0A                <!--[if mso]>=0A                <=
table align=3D"left" border=3D"0" cellspacing=3D"0" cellpadding=3D"0" width=
=3D"100%" style=3D"width:100%;">=0A                <tr>=0A                <=
![endif]-->=0A                =0A                <!--[if mso]>=0A          =
      <td valign=3D"top" width=3D"590" style=3D"width:590px;">=0A          =
      <![endif]-->=0A            <table class=3D"rnb-del-min-width" style=
=3D"min-width:100%; background-color:#e8e8e8;" name=3D"Layout_2" id=3D"Layo=
ut_2" width=3D"100%" cellspacing=3D"0" cellpadding=3D"0" border=3D"0" bgcol=
or=3D"#e8e8e8">=0A                <tbody><tr>=0A                    <td cla=
ss=3D"rnb-del-min-width" style=3D"background-color: #e8e8e8;" valign=3D"top=
" bgcolor=3D"#e8e8e8" align=3D"center">=0A                        <table cl=
ass=3D"rnb-container" style=3D"max-width: 100%; min-width: 100%; table-layo=
ut: fixed; background-color: rgb(255, 255, 255); border-radius: 0px; border=
-collapse: separate; padding-left: 20px; padding-right: 20px;" width=3D"100=
%" cellspacing=3D"0" cellpadding=3D"0" border=3D"0" bgcolor=3D"#ffffff">=0A=
                            <tbody><tr>=0A                                <=
td style=3D"font-size:1px; line-height:1px;" height=3D"0">&nbsp;</td>=0A   =
                         </tr>=0A                            <tr>=0A       =
                         <td class=3D"rnb-container-padding" style=3D"backg=
round-color: #ffffff;" valign=3D"top" bgcolor=3D"#ffffff" align=3D"left">=
=0A=0A                                    <table class=3D"rnb-columns-conta=
iner" width=3D"100%" cellspacing=3D"0" cellpadding=3D"0" border=3D"0">=0A  =
                                      <tbody><tr>=0A                       =
                     <td class=3D"rnb-force-col" style=3D"padding-right: 0p=
x;" width=3D"550" valign=3D"top">=0A                                       =
         <table valign=3D"top" class=3D"rnb-col-1" width=3D"550" cellspacin=
g=3D"0" cellpadding=3D"0" border=3D"0" align=3D"left">=0A                  =
                                  <tbody><tr>=0A                           =
                             <td class=3D"img-block-center" width=3D"100%" =
valign=3D"top" align=3D"left">=0A                                          =
                  <table width=3D"100%" cellspacing=3D"0" cellpadding=3D"0"=
 border=3D"0">=0A                                                          =
      <tbody>=0A                                                           =
         <tr>=0A                                                           =
             <td class=3D"img-block-center" width=3D"100%" valign=3D"top" a=
lign=3D"left">=0A=0A                                                       =
                 <table style=3D"display: inline-block;" cellspacing=3D"0" =
cellpadding=3D"0" border=3D"0">=0A                                         =
                                   <tbody><tr>=0A                          =
                                                      <td>=0A              =
                                                          <div style=3D"bor=
der-top:0px None #000;border-right:0px None #000;border-bottom:0px None #00=
0;border-left:0px None #000;display:inline-block;">=0A                     =
                                                       <a target=3D"_blank"=
 href=3D"http://r.webinars.grceducators.com/click/atzmobzazxc3lvjd.html">=
=0A                                                                        =
    <img class=3D"rnb-col-1-img" alt=3D"" src=3D"http://img.webinars.grcedu=
cators.com/2nqf0ps3lvje.png" style=3D"vertical-align: top; max-width: 700px=
;" width=3D"550" vspace=3D"0" hspace=3D"0" border=3D"0"></a>=0A            =
                                                                </div></td>=
=0A                                                                        =
    </tr>=0A                                                               =
         </tbody></table>=0A=0A                                            =
                        </td>=0A                                           =
                         </tr>=0A                                          =
                      </tbody>=0A                                          =
                      </table></td>=0A                                     =
               </tr><tr>=0A                                                =
        <td class=3D"col_td_gap" style=3D"font-size:1px; line-height:1px;" =
height=3D"10">&nbsp;</td>=0A                                               =
     </tr><tr>=0A                                                        <t=
d style=3D"font-size:18px; font-family:Arial,Helvetica,sans-serif; color:#9=
99; text-align:left;">=0A                                                  =
          <span style=3D"color:#999; "><span style=3D"color:#444444;"><span=
 style=3D"font-size: 14px;"><strong>Course Summary</strong></span></span></=
span></td>=0A                                                    </tr><tr>=
=0A                                                        <td class=3D"col=
_td_gap" style=3D"font-size:1px; line-height:1px;" height=3D"10">&nbsp;</td=
>=0A                                                    </tr><tr>=0A       =
                                                 <td style=3D"font-size:14p=
x; font-family:Arial,Helvetica,sans-serif, sans-serif; color:#555;">=0A    =
                                                        <div><div style=3D"=
text-align: justify;"><span style=3D"color:#444444;"><span style=3D"font-si=
ze: 12px;">This webinar focuses on alternatives to the VLOOKUP function. Wh=
ile many Excel users rely on VLOOKUP for basic lookup functionality, it's o=
ften because they're unaware of other functions that can enable them to wor=
k more efficiently in Excel. David sheds light on what can go awry with VLO=
OKUP; explains how to future-proof VLOOKUP; and discusses alternative funct=
ions, including IFNA, MATCH, SUMIF, SUMIFS, IFERROR, CHOOSE, and OFFSET.</s=
pan></span><br>=0A&nbsp;</div>=0A=0A<div style=3D"text-align: justify;"><sp=
an style=3D"color:#444444;"><span style=3D"font-size: 12px;">Attend this we=
binar to identify the limitation of VLOOKUP and learn about alternative fun=
ctions. Understand which version of Excel support the IFNA worksheet functi=
on. And the state why the INDEX and MATCH combination often is superior to =
VLOOKUP or HLOOKUP.</span></span></div>=0A=0A<div style=3D"text-align: just=
ify;">=0A<div>&nbsp;</div>=0A=0A<div><strong><span style=3D"font-size:14px;=
"><span style=3D"color: rgb(68, 68, 68);">Learning objectives</span></span>=
</strong></div>=0A=0A<div>=0A<ul>=0A=09<li><span style=3D"color:#444444;"><=
span style=3D"font-size: 12px;">Identify the limitations of VLOOKUP and lea=
rn about alternative functions.</span></span></li>=0A=09<li><span style=3D"=
color:#444444;"><span style=3D"font-size: 12px;">List which versions of Exc=
el support the IFNA worksheet function.</span></span></li>=0A=09<li><span s=
tyle=3D"color:#444444;"><span style=3D"font-size: 12px;">State why the INDE=
X and MATCH combination often is superior to VLOOKUP or HLOOKUP</span></spa=
n></li>=0A</ul>=0A</div>=0A</div>=0A</div>=0A                              =
                          </td>=0A                                         =
           </tr>=0A                                                    </tb=
ody></table>=0A=0A                                                </td></tr=
>=0A                                    </tbody></table></td>=0A           =
                 </tr>=0A                            <tr>=0A               =
                 <td style=3D"font-size:1px; line-height:1px;" height=3D"0"=
>&nbsp;</td>=0A                            </tr>=0A                        =
</tbody></table>=0A=0A                    </td>=0A                </tr>=0A =
           </tbody></table><!--[if mso]>=0A                </td>=0A        =
        <![endif]-->=0A                =0A                <!--[if mso]>=0A =
               </tr>=0A                </table>=0A                <![endif]=
-->=0A            </div></td>=0A    </tr><tr>=0A=0A        <td style=3D"bac=
kground-color:#e8e8e8;" valign=3D"top" bgcolor=3D"#e8e8e8" align=3D"center"=
>=0A=0A            <div>=0A                <!--[if mso]>=0A                =
<table align=3D"left" border=3D"0" cellspacing=3D"0" cellpadding=3D"0" widt=
h=3D"100%" style=3D"width:100%;">=0A                <tr>=0A                =
<![endif]-->=0A                =0A                <!--[if mso]>=0A         =
       <td valign=3D"top" width=3D"590" style=3D"width:590px;">=0A         =
       <![endif]-->=0A            <table class=3D"rnb-del-min-width" style=
=3D"min-width:590px; background-color:#e8e8e8;" name=3D"Layout_8" id=3D"Lay=
out_8" width=3D"100%" cellspacing=3D"0" cellpadding=3D"0" border=3D"0" bgco=
lor=3D"#e8e8e8">=0A                <tbody><tr>=0A                    <td cl=
ass=3D"rnb-del-min-width" style=3D"min-width:590px; background-color: #e8e8=
e8;" valign=3D"top" bgcolor=3D"#e8e8e8" align=3D"center">=0A               =
         <table class=3D"mso-button-block rnb-container" style=3D"backgroun=
d-color: rgb(255, 255, 255); border-radius: 0px; padding-left: 20px; paddin=
g-right: 20px; border-collapse: separate;" width=3D"100%" cellspacing=3D"0"=
 cellpadding=3D"0" border=3D"0" bgcolor=3D"#ffffff">=0A                    =
        <tbody><tr>=0A                                <td style=3D"font-siz=
e:1px; line-height:1px;" height=3D"20">&nbsp;</td>=0A                      =
      </tr>=0A                            <tr>=0A                          =
      <td class=3D"rnb-container-padding" style=3D"background-color: #fffff=
f;" valign=3D"top" bgcolor=3D"#ffffff" align=3D"left">=0A=0A               =
                     <table class=3D"rnb-columns-container" width=3D"100%" =
cellspacing=3D"0" cellpadding=3D"0" border=3D"0">=0A                       =
                 <tbody><tr>=0A                                            =
<td class=3D"rnb-force-col" valign=3D"top">=0A=0A                          =
                      <table valign=3D"top" class=3D"rnb-col-1" width=3D"55=
0" cellspacing=3D"0" cellpadding=3D"0" border=3D"0" align=3D"center">=0A=0A=
                                                    <tbody><tr>=0A         =
                                               <td valign=3D"top">=0A      =
                                                      <table class=3D"rnb-b=
tn-col-content" style=3D"margin:auto; border-collapse: separate;" cellspaci=
ng=3D"0" cellpadding=3D"0" border=3D"0" align=3D"center">=0A               =
                                                 <tbody><tr>=0A            =
                                                        <td style=3D"font-s=
ize:16px; font-family:Arial,Helvetica,sans-serif; color:#ffffff; font-weigh=
t:normal; padding-left:14px; padding-right:14px; vertical-align: middle; ba=
ckground-color:#e02d2d;border-radius:0px;border-top:0px None #000;border-ri=
ght:0px None #000;border-bottom:0px None #000;border-left:0px None #000;" w=
idth=3D"auto" valign=3D"middle" height=3D"36" bgcolor=3D"#e02d2d" align=3D"=
center">=0A                                                                =
        <span style=3D"color:#ffffff; font-weight:normal;">=0A             =
                                                                   <a style=
=3D"text-decoration:none; color:#ffffff; font-weight:normal;" target=3D"_bl=
ank" href=3D"http://r.webinars.grceducators.com/click/atzmobzb0ps3lvjd.html=
"><strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; REGISTER NOW</strong>&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;</a>=0A                                                   =
                         </span>=0A                                        =
                            </td>=0A                                       =
                         </tr></tbody></table>=0A                          =
                              </td>=0A                                     =
               </tr>=0A                                                    =
</tbody></table>=0A                                                </td>=0A=
                                        </tr>=0A                           =
         </tbody></table></td>=0A                            </tr>=0A      =
                      <tr>=0A                                <td style=3D"f=
ont-size:1px; line-height:1px;" height=3D"20">&nbsp;</td>=0A               =
             </tr>=0A                        </tbody></table>=0A=0A        =
            </td>=0A                </tr>=0A            </tbody></table>=0A=
            <!--[if mso]>=0A                </td>=0A                <![endi=
f]-->=0A                =0A                <!--[if mso]>=0A                =
</tr>=0A                </table>=0A                <![endif]-->=0A         =
   </div></td>=0A    </tr><tr>=0A=0A        <td style=3D"background-color:#=
e8e8e8;" valign=3D"top" bgcolor=3D"#e8e8e8" align=3D"center">=0A=0A        =
    <table class=3D"rnb-del-min-width rnb-tmpl-width" style=3D"min-width:59=
0px; background-color:#e8e8e8;" name=3D"Layout_3" id=3D"Layout_3" width=3D"=
100%" cellspacing=3D"0" cellpadding=3D"0" border=3D"0" bgcolor=3D"#e8e8e8">=
=0A                <tbody><tr>=0A                    <td class=3D"rnb-del-m=
in-width" style=3D"min-width:590px; background-color: #555;" valign=3D"top"=
 bgcolor=3D"#555" align=3D"center">=0A                        <table class=
=3D"rnb-container" style=3D"padding-right:20px; padding-left:20px;" width=
=3D"590" cellspacing=3D"0" cellpadding=3D"0" border=3D"0" align=3D"center">=
=0A                            <tbody><tr>=0A                              =
  <td style=3D"font-size:1px; line-height:1px;" height=3D"10">&nbsp;</td>=
=0A                            </tr>=0A                            <tr>=0A =
                               <td>=0A                                    <=
div style=3D"font-size:14px; color:#919191; font-weight:normal; text-align:=
center; font-family:Arial,Helvetica,sans-serif;"><div><span style=3D"color:=
#D3D3D3;"><span style=3D"font-size: 11px;">Event Marketing | GRC Educators =
| 740-870-0321 | support@grceducators.com | www.grceducators.com | 806 Clar=
k Street, P.O Box 171, Philo, OH-43771 USA </span></span>=0A=0A<div>&nbsp;<=
/div>=0A</div>=0A</div>=0A                                    <div style=3D=
"font-size:14px; font-weight:normal; text-align:center; font-family:Arial,H=
elvetica,sans-serif;">=0A                                        <a style=
=3D"text-decoration:none; color:#ccc;font-size:11px;font-weight:normal;font=
-family:Arial,Helvetica,sans-serif;" target=3D"_blank" href=3D"http://r.web=
inars.grceducators.com/2phwo2ztr43lvjg.html">Unsubscribe here</a></div>=0A =
                               </td></tr>=0A                            <tr=
>=0A                                <td style=3D"font-size:1px; line-height=
:1px;" height=3D"10">&nbsp;</td>=0A                            </tr>=0A    =
                        </tbody></table>=0A                    </td>=0A    =
            </tr>=0A            </tbody></table>=0A            </td>=0A    =
</tr><tr>=0A=0A        <td style=3D"background-color:#e8e8e8;" valign=3D"to=
p" bgcolor=3D"#e8e8e8" align=3D"center">=0A=0A            <table class=3D"r=
nb-del-min-width rnb-tmpl-width" style=3D"min-width:590px; background-color=
:#e8e8e8;" name=3D"Layout_4" id=3D"Layout_4" width=3D"100%" cellspacing=3D"=
0" cellpadding=3D"0" border=3D"0" bgcolor=3D"#e8e8e8">=0A                <t=
body><tr>=0A                    <td class=3D"rnb-del-min-width" style=3D"mi=
n-width:590px; background-color: #333;" valign=3D"top" bgcolor=3D"#333" ali=
gn=3D"center">=0A                        <table class=3D"rnb-container rnb-=
yahoo-width" style=3D"padding-right:20px; padding-left:20px;" width=3D"590"=
 cellspacing=3D"0" cellpadding=3D"0" border=3D"0" align=3D"center">=0A     =
                       <tbody><tr>=0A                                <td st=
yle=3D"font-size:1px; line-height:1px;" height=3D"20">&nbsp;</td>=0A       =
                     </tr>=0A                            <tr>=0A           =
                     <td style=3D"font-size:12px; color:#919191; font-weigh=
t:normal; text-align:center; font-family:Arial,Helvetica,sans-serif;">=0A  =
                                  <div><div>=C2=A9 2017 GRC Educators</div>=
=0A</div>=0A                                </td></tr>=0A                  =
          <tr>=0A                                <td style=3D"font-size:1px=
; line-height:1px;" height=3D"20">&nbsp;</td>=0A                           =
 </tr>=0A                        </tbody></table>=0A                    </t=
d>=0A                </tr>=0A            </tbody></table>=0A            </t=
d>=0A    </tr></tbody></table>=0A            <!--[if gte mso 9]>=0A        =
                </td>=0A                        </tr>=0A                   =
     </table>=0A                        <![endif]-->=0A                    =
    </td>=0A        </tr>=0A        </tbody></table>=0A=0A<div><img width=
=3D"1" height=3D"1" src=3D"http://r.webinars.grceducators.com/track/2phwo2z=
tr43lvjh.gif" /></div></body></html>


---------?=_37719-5267276991572--