fbpx Skip to content

MrExcel Tips and Tricks Videos

Become an Excel Pro in no time with insightsoftware’s Excel Tips and Tricks Video Series, led by MrExcel himself.

Take Your Excel Reporting to New Heights

Gain Access to Live Reporting in Excel with these Solutions

Real-time, secure, accurate, refreshable reports that allow you to spend more time analyzing data and less time preparing them.

Is Webinar Mrexcel Nov2019 Resource

What’s New in Excel for Financial Professionals?

Microsoft has announced several new calculation functions for Excel, from a better XLOOKUP function to new dynamic array functions SORT, FILTER, UNIQUE, and SEQUENCE, to a new geography and stock function FIELDVALUE. While these functions are already in Excel for Office Insiders, you should expect them to arrive in your subscription of Office 365 soon.

During this one-hour webinar, Microsoft MVP Mr. Excel will demonstrate:

  • How XLOOKUP is faster and less error-prone than VLOOKUP
  • XLOOKUP’s ability to return all 12 months in a single formula, which is exciting enough to make the INDEX/MATCH people switch
  • How to return geography and stock price information using FIELDVALUE
  • Sort and filter with a formula using SORT, FILTER, and UNIQUE
  • How the lowly SEQUENCE function will super-charge all calculation functions in Excel.

Want to learn more about our Excel-based solutions?