BEGIN:VCALENDAR X-WR-TIMEZONE:US/Eastern DTSTART:20190605T130000 DTEND:20190605T160000 VERSION:2.0 LOCATION:OnlinePRODID:-//Training Doyens //EN METHOD:REQUEST BEGIN:VEVENT UID:20190605T000000-501888540-example.com DTSTAMP:20190605T000000 DTSTART;TZID="US/Eastern":20190605T130000 DTEND;TZID="US/Eastern":20190605T160000 SUMMARY:3-Hour Excel Automation Boot Camp: Top Ten Excel Functions, Lookup Functions (VLOOKUP, HLOOKUP, MATCH, INDEX), Basics of Excel Macros with an Introduction to VBA DESCRIPTION: Excel functions can greatly enhance your ability to perform tasks in day to day activities in Excel. While there are hundreds of functions available, there are 10 functions that all Excel users should know. Whether you are an office worker, or a small business owner using Excel to keep track of your finances or just the casual user, these Excel functions can be very important time savers and enhance your ability to create better performing spreadsheets! Learning about the lookup functions in Excel will allow you to match data between databases. VLOOKUP 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 working with large tabular data. INDEX and MATCH work in a similar way but provide more flexibility. PRIORITY:3END:VEVENT END:VCALENDAR