Beyond VLOOKUP: Mastering Advanced Excel Formulas

Date Held: August 24, 2011

Start Time: 11:00AM PT

End Time: 1:00PM PT

Credits: 2 CPE Hours

Look-up formulas are far superior to manually pointing to specific data elements in a spreadsheet. Many users rely on VLOOKUP to return data from other locations in a worksheet, but is that the most efficient approach?
In this session, Excel expert David H. Ringstrom, CPA explores alternatives like MATCH/INDEX, SUMIF, COUNTIF, as well as using SUMPRODUCT to look up values based on multiple criteria. David will focus primarily on Excel 2007 and 2010, but will answer questions specific to earlier versions. Alternate instructions for Excel 2003 and earlier are included in the handout where applicable.

Who Should Attend
Practitioners who may benefit from working more efficiently in Excel.

 



Other areas of interest