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:195814
DTSTAMP:20260518T025620Z
SUMMARY:Using VLOOKUP, MATCH, and INDEX
DESCRIPTION:Overview\n\nThis webinar is for any user of Excel who work
 s with large amounts of data and has data in multiple worksheets. Lear
 ning about the lookup functions will allow you to match data between d
 atabases.\nLearn about VLOOKUP function in Excel which enables you to 
 quickly and easily look for a value down a column of data and return a
  value from the same row in a different column. Perfect for when worki
 ng with large tabular data.\nINDEX and MATCH work in a similar way but
  provide more flexibility.\nIn just one fast-paced and informative tra
 ining session, you’ll learn how to use lookup functions to let you w
 ork with your data more efficiently and gain powerful new tools to hel
 p you manipulate data and make better business decisions.\n\nWhy shoul
 d you Attend\nIf you handle large amounts of data in Excel, this webin
 ar on how to use VLOOKUP, MATCH and INDEX will help you tremendously.T
 he training will be delivered using Excel 2016 for Windows although fo
 r users of earlier versions, most of the functionality is available in
  Excel 2010 and Excel 2013.\nAreas Covered in the Session\n\n\nLearnin
 g the arguments in the VLOOKUP function\nUnderstanding the importance 
 of absolute references within many lookup functions\nVLOOKUP function 
 in Excel for performing approximate matches\nSimplifying multiple-fiel
 d look-ups with concatenation (combining fields into a single cell)\nD
 iscovering how to use wildcards and multiple criteria within lookup fo
 rmulas\nUsing VLOOKUP to look up data from another workbook\nLearning 
 how VLOOKUP stops looking after it finds an initial match within a lis
 t\nExploring why VLOOKUP sometimes returns #N/A instead of a desired r
 esult\nLearning about the IFNA function available in Excel 2013 and la
 ter\nUse the IFERROR function to display something other than an #N/A 
 error value when VLOOKUP can't find a match\nSeeing how the HLOOKUP fu
 nction enables you to perform horizontal matches\nLearning why the IND
 EX and MATCH combination often is superior to VLOOKUP or HLOOKUP\nUsin
 g the MATCH function to find the position of an item on a list\nPerfor
 m dual lookups, allowing you to look across columns and down rows to c
 ross-reference data you need\nFuture-proof VLOOKUP by using Excel's Ta
 ble feature versus referencing static ranges\nView two worksheets from
  within the same workbook at the same time\n\n\nWho Will Benefit\n\n\n
 Business Owners\nCEO's / CFO's / CTO's\nManagers\nAccountants\nCPA's\n
 Financial Consultants\nIT Professionals\nAuditors\nHuman Resource Pers
 onnel\nBookkeepers\nMarketers\nAnybody with large amounts of Data\nAny
 body who uses Microsoft Excel on a regular basis, and wants to be more
  efficient and productive\n\n\nSpeaker Profile\n\nCathy Horwitz is an
  independent consultant specializing in Microsoft Office instruction. 
 She has over 30 years of experience as a Microsoft Office instructor. 
 Cathy is proficient in all levels of Excel, Word, PowerPoint, Outlook 
 and Access. Cathy holds a degree in Psychology and a Master in Busines
 s Administration degree with an emphasis in Human Resources. \n\n\nFo
 r more information visit https://medtechiq.ning.com/events/using-vlook
 up-match-and-index
DTSTART;TZID=America/New_York:20191120T120000
DTEND;TZID=America/New_York:20191120T130000
CATEGORIES:webinar
LOCATION:Fremont, CA
WEBSITE:http://www.traininng.com/webinar/using-vlookup,-match,-and-ind
 ex--201105live?medtechiq-Nov-Seo-2019
URL:http://www.traininng.com/webinar/using-vlookup,-match,-and-index--
 201105live?medtechiq-Nov-Seo-2019
CONTACT:(510) 962-8903
ORGANIZER;CN="Joseph Wilcox":https://medtechiq.ning.com/profile/Joseph
 Wilcox
ATTACH;FMTTYPE="image/jpeg":https://storage.ning.com/topology/rest/1.0
 /file/get/1223597505?profile=original
ATTENDEE;ROLE=REQ-PARTICIPANT;PARTSTAT=ACCEPTED;RSVP=TRUE;CN="Joseph W
 ilcox":https://medtechiq.ning.com/profile/JosephWilcox
END:VEVENT
END:VCALENDAR