2018 - Webinar on Microsoft Excel: Let’s Look Beyond the Lookup – Training Doyens

OVERVIEW
Simple VLOOKUP is a powerful tool, but there are a thousand ways to tweak it to make it more powerful – or to bypass it for more flexible, useful functions.
Join our upcoming webinar to be presented by Neil Malek to learn how to use VLOOKUP in Excel and many other powerful, dynamic functions available in Excel.
Webinar Highlights
• Making VLOOKUP work well in every scenario, even when it can’t handle the request
• Replacing VLOOKUP with more flexible functions
• Supplementing your lookups with alternative tools
LEARNING OBJECTIVES
Simple VLOOKUP is a powerful tool, but there are a thousand ways to tweak it to be more powerful – or to bypass it for more flexible, useful functions. Supplementing Microsoft Excel VLOOKUP with functions like IFERROR, MATCH, and CONCAT, or using tools like SUMIFS, LARGE, INDEX, MATCH, and SEARCH can build a suite of functionality you can apply to the kind of data you see in the real world. If you can’t guarantee that your data will be properly structured, VLOOKUP will give you errors and incorrect answers,more often than not.
WHO WILL BENEFIT
Business Analysts
Managers
Financial Professionals
Administrative Professionals
HR Professionals
SPEAKER
Neil Malek is principal at Knack Training, a software training company specializing in Microsoft products. For nearly two decades, Neil has been working with non-profits, governments, and Fortune 500 companies to identify and address skills gaps.
For more detail please click on this below link:
http://bit.ly/2LxL7Wi
Email: support-AT-trainingdoyens.com
Toll Free: +1-888-300-8494
Tel: +1-720-996-1616
Fax: +1-888-909-1882