Many Excel spreadsheets use the IFERROR function to handle errors, but this masks critical structural and data issues.

Calling all spreadsheet enthusiasts! Are you a whiz with formulas, a master of formatting, and a champion of data organization? Put your Microsoft Excel skills to the test with this exciting GK quiz.

It's marginally more efficient: While the difference is negligible, the double-unary operator can be more efficient in ...

You're currently following this author! Want to unfollow? Unsubscribe via the link in your email. Follow Robin Madell Every time Robin publishes a story, you’ll get an alert straight to your inbox!

Last month I turned the tables and challenged JofA readers to answer another reader’s Excel question, as follows: Q: I have created an Excel template in which I enter employee information and pension ...

Microsoft Corp.'s Excel 2007 spreadsheet program is going to have to relearn part of its multiplication table. In a blog post, Microsoft employee David Gainer said that when computer users tried to ...