Practitioners who can benefit by using a variety of lookup functions to work more efficiently in Excel Areas Covered Perpetual licensed versions have year numbers, such as Excel 2021, Excel 2019, and so on. Conversely, the perpetual licensed versions of Excel have feature sets that don't change.

Microsoft 365 is a subscription-based product that provides new feature updates as often as monthly. David also provides an Excel workbook that includes most of the examples he uses during the webcast. David draws your attention to any differences in the older versions of Excel (2021, 2019, 2016 and earlier) during the presentation as well as in his detailed handouts. In many cases you're only a few mouse clicks away from transforming overwhelming lists of data into meaningful reports.ĭavid demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Microsoft 365 (formerly Office 365) version of Excel.

Lookup functions are only the start, though. You'll also get a preview of the new XLOOKUP function being added to Office 365. In this comprehensive presentation, David reveals alternatives to VLOOKUP, including the HLOOKUP, INDEX and MATCH, SUMIF, SUMIFS, and IFNA. 90 Minutes Recorded Webinar Purchase Options OverviewĮxcel expert David Ringstrom, CPA, explains helpful ways you can improve the integrity of your spreadsheets using Excel’s lookup functions and pivot tables.

Advanced excel 2021