Beyond VLOOKUP: Mastering Advanced Excel Formulas

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