AccountingWEB's Top Five Excel Tips From 2013
What do accountants count on most to do their jobs well? Yes, coffee is a good answer. No, I'm not thinking of booze.
If you eliminate any and all kinds of medicating, the smart money is on Microsoft Excel. And the most frustrating thing about Excel is, you can never know enough about it. There's always another trick, another method that requires one less click, or another key shortcut (my favorite!), that makes your Excel experience that much more enjoyable.
Our resident spreadsheet wizard, David Ringstrom, has more tricks than a Las Vegas magician and we've dug up five of his most popular from the past year. It'll help you re-remember the Excel tips from 2013 that made you love spreadsheets all over again. At least for a minute, anyway.
There are numerous ways #VALUE errors can thwart your simple spreadsheet. Use these handy tips  to track down the culprits.
If you're looking for duplicate numbers in an Excel worksheet that has somewhere between 100 and umpteenthousandth rows, you'll want to read this post .
In a year full of practical Excel tips, this  may be the practical-iest.
The best thing about this Excel tip  is that it gives three options. And who doesn't love options?
Even if you've programmed your fingers to reach for Crtl+S every 10 minutes, the possibility remains that workbooks vanish from your screen unsaved. David's post from last March  has undoubtedly brought down the computer homicide rate.