Excel Updates: New Formulas You Need to Know
On-Demand Recording
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?
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!
ABOUT THE SPEAKER
Register Now
FOR ONLY $99
Receive all the valuable tools, guidance, and materials as if you attended live!
Get access to all of our workshops plus much more with a subscription to Resourceful Pro Insider.
Get
Guaranteed to be Good
All training experiences include a 7-day 100% money-back guarantee.
HRCI CREDITS
This program has been approved for 1 (HR (General)) recertification credit hour toward aPHRTM, aPHRiTM, PHR®, PHRca®, SPHR®, GPHR®, PHRiTM and SPHRiTM recertification through the HR Certification Institute. Learn more at hrci.org
