Advanced Excel VLOOKUP

OVERVIEW

You will learn functions that can work with your data in whatever format you want to complete a variety of tasks. You will also learn the limitations and pitfalls of each function so that you can determine which one is best for a particular application. This session will also cover the most recent additions to this area, such as XLOOKUP, XMATCH, and others.

WHY SHOULD YOU ATTEND?

Microsoft is constantly improving and adding new Excel functions. This session will go over the fundamental Excel functions as well as some of the more recent ones.

This session will advance your Excel problem-solving abilities. Finding data will be a simple task to complete your task. This is especially true for the most recent functions, which use dynamic arrays to obtain the information you require.

LEARNING OBJECTIVES

Using VLOOKUP, XLOOKUP
Using INDEX/MATCH or INDEX/XMATCH
Ways of matching data (wildcards, etc.)
SEARCH and FIND
Using the FILTER and SORT function
Using UNIQUE and SEQUENCE functions

AREAS COVERED

Handling Errors
Named Ranges
Advanced Filter
Tables
Dynamic Arrays
o SEQUENCE, FILTER, UNIQUE, SORT, more
New Functions
o CHOOSECOLS, VSTACK, TEXTSPLIT, TEXTBEFORE, LET

WHO WILL BENEFIT?

Business Owners, CEO, CFO, CTO
Managers of all levels,
Team Leaders, Supervisors
Administrative Specialists
Data Analyst, Sales Analyst
Accountants, CPAs, Controllers
Financial Consultants, IT Professionals
Human Resource Personnel
Bookkeepers, Marketers, Marketing Mangers
Anybody with large amounts of data, Auditors
Anybody who uses Microsoft Access/Excel on a regular basis and wants to be more efficient and productive

Purchase options

Option	Price
Recorded Link Only	$199
Recorded USB Only	$299
Corporate Recording (Upto 10 Attendees)	$499

*Training USB will be shipped within 7-10 working days. *Buy Now Pay Later option is available in the payment cart page.
*In case you're unable to attend the live session, we'll make sure you receive the recording promptly.

Create inquiry

Customer support

Email: [email protected]

Call: +1-855-202-3299

Mr. Bob Umlas

Excel Trainer and Consultant

About speaker

Mr. Umlas was voted an “MVP” (Most Valuable Professional) by Microsoft each year from 1993-2018 (25 years!) for his contributions to the various online Forums about Excel and is known worldwide for his contributions in Excel. He has been a beta tester for new versions of Excel since version 1.5 and was asked by Microsoft for his input for newer versions of Excel.

Bob worked for a major tax and accounting firm, using Microsoft Excel® 8 hours a day, writing custom applications for staff and clients from 1998 to 2018.
He has been using Excel since version 0.99 (on the Macintosh)! He was a contributing editor to Inside Microsoft Excel for many years, a magazine devoted exclusively to Microsoft Excel and published by The Cobb Group and later Ziff-Davis. He has had more than 300 articles published on subjects ranging from beginner to advanced macros, and on tips, shortcuts, and general techniques using virtually all aspects of Excel.

He is also the author of “This isn’t Excel, it’s Magic!”, “Excel Outside the Box”, “Excel Preschool: Finally Understanding what Excel is all About”.

Mr. Umlas used to co-lead the New York PC User’s group on Excel every month for about 10 years. He started leading this group again in 2018. He has been teaching Excel to individuals and corporations for several years.

Currently, Mr. Umlas leads a 12-hour class in Excel called Excel in Depth and a 6-hour class on VBA.