Beyond VLOOKUP: Mastering Advanced Excel Formulas
Posted by accountingweb on Mon, 12/06/2010 - 09:28 2404
Many users rely on VLOOKUP to return data from other locations in a worksheet, but is that the most efficient approach? Excel expert David H. Ringstrom, CPA explores alternatives like MATCH/INDEX, SUMIF, COUNTIF, as well as using SUMPRODUCT. For more about presenter David Ringstrom and upcoming Excel webcast dates on this topic go to: http://www.cpelink.com/instructor/detail.php?i=73&s=f38j2xd
Voice of the Editor
Results from a recent AICPA survey disclosed the two top priorities for CPA firms as they plan for the future: bringing in new business and finding talent. Our goal at Sift Media is to help our readers deal with the issues most important to them. One way in which we are doing this is through the launch of our new recruitment/placement service, Going Concern Jobs. Check it out today for your talent needs.