Excel Lookup Functions – 2 Part Web Series (Module 2)
October 10, 2018 - Online Event ON CAWebinar Compliance
info@webinarcompliance.com
Phone:416-915-4438\58
In this valuable presentation, Excel expert David Ringstrom, CPA, explains helpful ways you can improve the integrity of your spreadsheets using a variety of Excel’s lookup functions. While many users rely on the VLOOKUP function to return data from other locations in a worksheet, it isn’t always the most efficient function to use. David reveals alternatives to VLOOKUP, including the HLOOKUP, INDEX and MATCH, SUMIF, SUMIFS, SUMPRODUCT, IFNA, MAXIFS, and OFFSET functions.
This website uses cookies to ensure you get the best experience on our website. Learn more