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?

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

Mitzi Gibson Katz

"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 Excel by her passion: ""It's the people part of the business that keeps me involved."""