Guaranteed to be Good
All training experiences include a 7-day 100% money-back guarantee.
Mastering Excel Lookup Functions: What Every User Should Know
Summary
Ever gotten sick of manually linking data across Excel spreadsheets? Of course you have - it takes a ton of time and it’s easy to make errors. What if you could tell Excel what you were looking for and have it automatically find and link the data for you? Well, you can and it’s a game changer!
VLOOKUP, HLOOKUP and XLOOKUP formulas give you that power and more - and once you master them, there’s no turning back.
Join us for an interactive 90-minute, instructor-led training, where you’ll learn the ins and outs of Excel’s powerful lookup functions. Using plenty of examples, Excel expert Mitzi Katz will show you what they are, how to use them, and what they can do for you.
After this workshop:
- You’ll be ready to use Excel’s VLOOKUP, HLOOKUP and XLOOKUP formulas
- You’ll understand when these lookups can - and should - be used
- You’ll be able to confidently employ them to save time, work with data more efficiently and be more productive.
- You’ll also walk away with great ideas on structuring your data that will help you going forward - even when lookups don’t come into play
- & MUCH more!
Program Highlights
LOOKUP functions explained
- What are lookup functions?
- What can they do, why should I use them, and how can they help me?
- What are the differences between VLOOKUP, HLOOKUP and XLOOKUP?
- The importance of structuring - or restructuring - your data to get the most out of them
Mastering the VLOOKUP and HLOOKUP Functions
- How to construct and use the VLOOKUP and HLOOKUP functions
- Picking the right function for the right job
- Unleashing the power of nested lookups
- How to perform two-dimensional lookups
- How exact match and approximate match differ - and why it matters
- Error-proofing lookup formulas - avoiding the dreaded #NA
- Watch you instructor create - and explain - many examples and variations
NEW: The XLOOKUP Function
- What is XLOOKUP and which Excel versions use it?
- What can XLOOKUP do that VLOOKUP and HLOOKUP can’t? (short answer: you’ll be amazed)
- Using the XLOOKUP function - examples created and explained
- Replacing VLOOKUP & HLOOKUP with XLOOKUP in your existing spreadsheets - it’s surprisingly easy!
Additional tools:
- 15 minutes of assisted exercises to boost your performance right away
- 30 minutes of interaction & live Q&A session!
About The Speaker
Mitzi Gibson Katz has trained thousands of end users and developed curriculum for over twenty-five years.
- As a consultant, she specializes in the Microsoft Office suite including Excel, Access, PowerPoint, Word, Outlook and much more.
- After teaching a variety of special education classes in Kansas, Montana, and Alaska for the early part of her career, Mitzi became interested in technology as the first personal computers were introduced to the market. She made the change in careers from public school education to private computer training and has been teaching students how to use software applications ever since.
- Mitzi helps students understand Microsoft Applications by her passion: "It's the people part of the business that keeps me involved.
Program Benefits
After this interactive 90-minute, instructor-led training, you’ll have mastered use of Excel’s VLOOKUP, HLOOKUP and XLOOKUP functions. You’ll know when and how to use them and be able to confidently employ them to save time, work with data more efficiently and be more productive. BONUS: You’ll also get great ideas on structuring your data that will help you going forward.
Purchase this On-Demand Workshop
Mastering Excel Lookup Functions: What Every User Should Know
On-Demand $199 +
applicable taxes
more info
For the live training(s) you've selected:
You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
For the on-demand training(s) you've selected:
You'll receive a link to access the recording(s) in your order confirmation email. On-demand recordings also include a copy of the speaker's presentation and the ability to submit your questions to the expert, for up to 7 days after viewing.
You'll receive a link to access the recording(s) in your order confirmation email. On-demand recordings also include a copy of the speaker's presentation and the ability to submit your questions to the expert, for up to 7 days after viewing.
3 Workshop
Bundle $300 +
applicable taxes
more info
Take advantage of our three workshop bundle to enhance your learning beyond the training you initially selected. Our workshop bundle allows you to select three workshops (Live or On-Demand) at a discounted price.
For the live training(s) you've selected:
You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
For the on-demand training(s) you've selected:
You'll receive a link to access the recording(s) in your order confirmation email. On-demand recordings also include a copy of the speaker's presentation and the ability to submit your questions to the expert, for up to 7 days after viewing.
You'll receive a link to access the recording(s) in your order confirmation email. On-demand recordings also include a copy of the speaker's presentation and the ability to submit your questions to the expert, for up to 7 days after viewing.
One-year subscription (All Access Membership) $699 +
applicable taxes
more info
With this subscription, you will receive 1 year of unlimited access to our full library of on-demand trainings as well as priority access to trainings that are upcoming.
For the live training(s):
You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
For the on-demand training(s):
You'll receive access to our full library of on-demand trainings along with the speaker's presentation and handouts for each event.
You'll receive access to our full library of on-demand trainings along with the speaker's presentation and handouts for each event.
Full-Team Pass
Simply share the invite link with your team so you can learn and grow together!
Yours Forever
The event recording and materials are yours to rewatch and share as you choose.
