Beyond VLOOKUP: Mastering Advanced Excel Formulas
Posted by accountingweb on Mon, 12/06/2010 - 09:28 2342
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
What would you do if one of your clients won the lottery? We asked several accountants to weigh in with their advice for the lucky Powerball winner, and the tips we received are useful for anyone who receives a windfall, whether it's a lottery win, an inheritance, a big bonus on the job, or a killing in the stock market.