When: |
21 Dec through 21 Dec 2017 | |
Where: |
Aurora, Colorado, United States | |
Website URL: |
https://goo.gl/7caJTJ | |
Sponsoring organization: |
Training Doyens | |
Categories: |
Business - Finance |
Keywords:
Event description:
VLOOKUP formula is one of the most popular formulas in Excel. In this webinar Excel expert Dennis Taylor discusses the use and limitations of VLOOKUP to help you expand your use of this function. Join the webinar and upgrade your skills.
Thursday, December 21st, 2017
01:00 PM EST | 10:00 AM PST
Duration: 90 minutes
AREAS COVERED
• Perform dual lookups, where you look across columns and down rows to cross reference the data you need
• See how to arrange two worksheets from within the same workbook onscreen at the same time
• See why the MATCH and INDEX combination is often superior to the VLOOKUP or HLOOKUP function
• Uncover the limitations of VLOOKUP, along with alternatives
• Use the SUMIFS function to sum value based on multiple criteria
LEARNING OBJECTIVES
• Understand how to use VLOOKUP to perform both exact and approximate matches
• Use the MATCH function to overcome a data integrity risk with VLOOKUP
• See how the SUMIF and SUMIFS functions can serve as al...
Read more
Posting date:
15 December 2017 | 188 views
Placement:
Not-featured (How do I make my event featured?)
Flag (Report this event)