Microsoft Excel - Let's Look Beyond the Look-Up

This Microsoft Excel training program will explain why the INDEX and MATCH combination often is superior to VLOOKUP or HLOOKUP. It will compare the MIN, SMALL, MAX, and LARGE functions. The program will also define uses of the OFFSET worksheet function and detail how to apply the SUMIF function and the SUMIFS function.

Why Should You Attend:

This webinar will help attendees learn how to:

• Work more efficiently in Excel by utilizing lookup formulas.
• Employ several alternatives to VLOOKUP.
• Avoid the complexity of nested IF statements with Excel’s CHOOSE function.
• Perform dual lookups.
• Attendees will receive detailed handouts that can serve as reference tools to fall back on after participating in the webcast.