Purchase any WEBINAR and get
10% Off
CODE: SAVE10
T&C applicable, please referFAQ
Validity : 14th Apr'24 to 24th Apr'24
Beyond VLOOKUP: Mastering Advanced Excel Formulas
- VLookUp
- HLookUp
- Index/Match
- LookUp
- Match Types
- Find
- Search
- IfError
- IfNA
- Named Ranges
- Table set up pitfalls and success tips
- Advanced Filter
- DFunctions
- When a Pivot Table can be a lookup tool
Overview of the webinar
At its heart, this session is a survey of Excel’s capability in the area of looking up data from one place in another. While the concept sounds simple, it rarely is when it comes to the various ways we get data and the myriad ways we need to use it. Instead of bending formulas and data to the will of the functions we know, you'll learn other functions that can work with your data just the way it is to complete a variety of tasks.
From augmenting one list with data from another to uncovering anomalies, filling your toolbox with more lookup tools can lead you to better, more efficient and more accurate solutions. We’ll also cover the limitations and pitfalls of each technique, so you know which one is best for a particular use. Learn the finer points of lookup function arguments and how they can help (or trip you up) with non-standard lookup jobs.
We’ll also cover how to construct, format and identify lists to take full advantage of the power of this application. Once you know what you need your data to like, you can refine your work processes to set you up for repeated success.
Who should attend?
- Data Analyst
- DBA
- Business Data Analyst
- Business Information Specialist
- HR
- Payroll Specialist
- Accountant
- Administrative Professional
- Administrative Assistant
- Compliance Specialist
- Marketing Specialist
- Marketing Manager
- Sales Analyst
Why should you attend?
So many of us are self-taught in Excel, which usually means once we find something that works, we tend not to look for a better more efficient solution. Or, we settle for a partially automated solution and grumble through the manual steps we couldn’t streamline with anything our Excel tool box.
This session will take your Excel problem-solving skills to the next level. For example, did you know that there are at least three different ways to do a vertical lookup operation that addresses various anomalies in lookup tables and result requirements? Do you know the trick to using a wide lookup table that obviates having to count columns to construct your formula? Are you familiar with the various ways to address error messages when they don’t actually represent errors in the context of your data?Learn these secrets and more to turn formulas into real problem-solving tools.
Faculty - Ms.Melissa Esquibel
Melissa Esquibel specializes in technology training, empowering users to be effective with their office productivity tools. As a Microsoft Certified Trainer (MCT) with more than 25 years in business application technology, Melissa has a unique ability to make learning programs enjoyable AND valuable.
Her consulting career spans banking, manufacturing, telecommunications, energy, and insurance, which allows her to provide real-world examples and applications. She has enabled everyone from rocket scientists to real estate brokers to put the “productive” back in office productivity software. Melissa graduated summa cum laude from Strayer University with a Bachelor of Business Administration, majoring in Legal Studies.