Learn Excel Episode 241: Old Accountant's Trick

Posted in Companies, Podcasts on July 01, 2008


Learn Excel Episode 241: Old Accountant's Trick

Today, I am appearing at the IMA Continuing Education Workshop in Kent Ohio. There will be a few hundred serious accountants in that room with me today, and most of them will know this trick. Today, we have a spreadsheet where someone added manual subtotals to the worksheet. Rather than building a formula to point just to the totals, there is a cool trick that uses a bit of algebra to solve the problem. Episode 241 will show you how.

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel