Guaranteed to be Good
All training experiences include a 7-day 100% money-back guarantee.
Excel Updates: New Formulas You Need to Know
Summary
Did you know VLOOKUP and HLOOKUP have been replaced in Excel?
Oh, but there’s more!
How much time and effort have you spent creating a “unique list” from an old list and a new list? And what about those what-ifs?
This workshop will teach you everything you need to know about these (and other!) new and updated formulas, including shortcuts, gotchas, and best practices.
We'll cover these updates and new formulas (found in the latest version of Excel), review in a 20-minute online lab - and have time for questions to follow.
You’ll walk away equipped to:
- Build and use new formulas with confidence and ease
- Review your own spreadsheets for areas for refinement
- Manage Excel lists more effectively
- Use updated best practices for sorting
- BONUS: All registrants will receive a quick reference eGuide containing how-to's for navigating the newest features and functions, plus dozens of useful shortcuts!
Program Highlights
Hands-On Guidance for Using Excel’s New Formulas
- Exactly what the new formulas are – and how to use them
- When to use the new formulas
- How to review your spreadsheets for errors
Learn Excel Tips and Tricks to Save Time
- Methods of “calculating text” that do not use formulas
- Shortcut for calculating multiple cells with one formula (and no fill command)
- How to view formula results on different sheet tabs with a live data feed
- The difference between applying formulas in an Excel list versus an Excel table
Answers to Your Burning Excel Questions
- What is the difference between VLOOKUP and XLOOKUP?
- What is the difference between XLOOKUP and MATCH & INDEX?
- What is the difference between applying the formulas to an Excel list versus an Excel table?
About The Speaker
Mitzi Gibson Katz has developed coveted training solutions and has educated thousands of end users for the past thirty-eight years. Mitzi holds a Master's degree in Education with an emphasis in special education classroom and administration.
Early in her career, Mitzi taught a variety of special education classes in Kansas, Montana, and Alaska. When the first personal computers were introduced into the market, Mitzi became passionate about technology. As an innovator, she made a change in careers from public school education to independent educator, where she began providing private computer training. Mitzi has been teaching software 'best practices' ever since.
What Gets Mitzi Jazzed?
According to Mitzi, "It's the people part of the business that keeps me involved. I love learning and teaching! The most fun I have professionally, is working with students as 'the light comes on'. I have always prided myself in offering 'gentle' instruction with the goal of assisting the student while they capture and retain the information." When Mitzi is not teaching, she can be found in the garden, hiking, bicycling, or skiing with her family.
Program Benefits
Whether you’re an Excel whiz or less than confident in your spreadsheet skills, this workshop will teach you everything you need to know about Excel’s newest formulas – so you can increase your efficiency and accuracy going forward.
If you'd like this program customized for your organization, call us at 1-800-964-6033.
We're certain we can fulfill your training needs, while making it fit in your budget!
Purchase this On-Demand Workshop
Excel Updates: New Formulas You Need to 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.
