Beyond VLOOKUP: Mastering Advanced Excel Formulas
Posted by accountingweb on Mon, 12/06/2010 - 09:28 2319
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
Even though any accounting auditor would tell you it seems like there are an awful lot of tax accountants out there, surely one-third of the country isn't made up of tax preparers, so it's rather startling news to learn that one-third of Americans like to do their taxes. Who knew?