BEGIN:VCALENDAR
PRODID:NingEventWidget-v1
VERSION:2.0
METHOD:PUBLISH
BEGIN:VTIMEZONE
TZID:America/New_York
X-LIC-LOCATION:America/New_York
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:19700308T020000
RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=2SU
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:19701101T020000
RRULE:FREQ=YEARLY;BYMONTH=11;BYDAY=1SU
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
UID:2140535:Event:281187
DTSTAMP:20260415T205740Z
SUMMARY:Going Beyond VLOOKUP to Master Excel Formulas
DESCRIPTION:Topic : Going Beyond VLOOKUP to Master Excel Formulas\nReg
 ister :https://www.ijonaskills.us/webinarDetails?webinarid=625&speaker
 id=53&domain=4&source=MTN_LN\nDiscount Coupon : Use this Coupon (NEW2
 COMPLIANCE) and get (10% Off) On New Signup\nOverview\nAfter participa
 ting in this informative webcast presented by Excel expert David Rings
 trom, CPA, you'll have the skills needed to go beyond Excel's VLOOKUP 
 function to master complicated formulas. VLOOKUP is the function many 
 Excel users rely on to return data from other locations in a worksheet
 ; however, utilizing VLOOKUP isn't always the most efficient approach.
  David shares helpful tweaks you can implement with the revered VLOOKU
 P function and explains several alternatives, including the INDEX and 
 MATCH, SUMIF, SUMIFS, IFNA, and IFERROR functions.\nAreas Covered in t
 he Session :\n\nComparing HLOOKUP to VLOOKUP for performing horizontal
  matches versus vertical matches.\nContrasting the INDEX and MATCH com
 bination to VLOOKUP or HLOOKUP.\nDiagnosing #N/A errors that arise whe
 n numbers are stored as text or when text contains extraneous spaces.\
 nDiscovering how to use wildcards and multiple criteria within lookup 
 formulas.\nEliminating inputs that could cause VLOOKUP to return #N/A 
 with Data Validation.\nEmploying the SUMIF function to sum values rela
 ted to multiple instances of criteria you specify.\nFuture-proofing VL
 OOKUP by referencing entire columns when available.\nFuture-proofing V
 LOOKUP by using Excel's Table feature versus referencing static ranges
 .\nIdentifying situations where VLOOKUP may return #N/A instead of a v
 alue.\nIdentifying the risks of the LOOKUP function in Excel.\nImprovi
 ng the integrity of spreadsheets with Excel's VLOOKUP function.\nLearn
 ing about the IFNA function available in Excel 2013 and later.\n\nSpea
 ker Profile :\nDavid H. Ringstrom, CPA Keynote Speaker at Ijona Skills
 . He is an author and nationally recognized instructor who teaches sco
 res of webinars each year. His Excel courses are based on over 25 year
 s of consulting and teaching experience. David's mantra is \"Either yo
 u work Excel, or it works you,\" so he focuses on what he sees users d
 on't, but should, know about Microsoft Excel. His goal is to empower y
 ou to use Excel more effectively.\n\nContact Info :\nIjona Skills\nhtt
 ps://www.ijonaskills.us/\nEmail : support@ijonaskills.us\nPhone : +1 3
 02-830-3132\n\nFor more information visit https://medtechiq.ning.com/e
 vents/going-beyond-vlookup-to-master-excel-formulas
DTSTART;TZID=America/New_York:20200228T153000
DTEND;TZID=America/New_York:20200228T163000
CATEGORIES:webinar
LOCATION:Online
WEBSITE:https://www.ijonaskills.us/webinarDetails?webinarid=625&sp
 eakerid=53&domain=4&source=MTN_LN
URL:https://www.ijonaskills.us/webinarDetails?webinarid=625&speake
 rid=53&domain=4&source=MTN_LN
CONTACT:3028303132
ORGANIZER:Ijona Skills
ATTACH;FMTTYPE="image/jpeg":https://storage.ning.com/topology/rest/1.0
 /file/get/3885607906?profile=original
ATTENDEE;ROLE=REQ-PARTICIPANT;PARTSTAT=ACCEPTED;RSVP=TRUE;CN="chaithan
 ya G":https://medtechiq.ning.com/profile/chaithanyaG
END:VEVENT
END:VCALENDAR