Learn Excel Now

Conquer the Fear of Excel

  • Home
    • Our Team
  • Training
    • Custom Training
      • Custom Virtual Group Training
      • Custom Onsite Group Training
      • Consulting Services
    • Excel
    • MS Office
    • Outlook
    • PowerPoint
    • Word
    • OneDrive
    • Google
  • All-Access
  • eLearning
    • Excel Foundations
    • Micro Courses
      • Simply Excel
      • Simply Excel Pt. II
  • Resources
    • Contact
    • FAQ
    • New User Onboarding
  • Login

Excel Updates: New Formulas You Need to Know

Price: $
Share

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

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.

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 Webinar

Excel Updates: New Formulas You Need to Know

Format: On-Demand Webinar
Price: $199 + applicable taxes Buy Now

Purchase This On-Demand Webinar

Excel Updates: New Formulas You Need to Know

Format: On-Demand Webinar
Price: $199 + applicable taxes
Buy Now

Learn Excel Now helps you conquer the fear of Excel. By providing self-paced and instructor-led training and free strategies and guides, we leave no Excel mystery unsolved.

  • Home
  • Training
  • All-Access
  • Excel Foundations
  • Resources

Connect with Us

  • Facebook
  • Linkedin

Contact

Learn Excel Now
questions@learnexcelnow.com
1-484-259-7664 or 1-800-964-6033
660 American Ave
Suite 203
King of Prussia, PA 19406

Microsoft® Office Excel® is a registered trademark of the Microsoft Corporation in the United States and other countries. All rights reserved.

Copyright © 2023 ­Learn Excel Now

Terms of Service

Privacy Policy

Copyright © 2023 · News Pro Theme on Genesis Framework · WordPress · Log in

WELCOME BACK!

Enter your username and password below to log in

Forget Your Username or Password?

Reset Password

Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.

Log In