On-Demand WebinarWhat’s New in Excel for Financial Professionals?
Watch Webinar
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…
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.
About Mr. Excel
Bill Jelen, the world’s foremost spreadsheet wizard, now known internationally as “Mr. Excel.” His web site (MrExcel.com) is the premier source for Excel tips and solutions and had over 10 million page views last year.