Category Archives: Excel

Weird Excel Calculation Bug

Excel has a “bug” where calculations whose results are near 2^16 (65,536) may not be correctly displayed. * Microsoft – http://blogs.msdn.com/excel/archive/2007/09/25/calculation-issue-update.aspx * Chance News 30 – http://chance.dartmouth.edu/chancewiki/index.php/Chance_News_30 What’s interesting to me is not the bug, per se, but the fact… More On: Weird Excel Calculation Bug

Posted in Excel | Leave a comment

Excel 2007 New Conditional Formatting Tricks

If you have Excel 2007, you can add value bars or color coding to your cells depending on their value. It could be handy for some of those reports we write. http://www.databasejournal.com/features/db2/article.php/3690046

Posted in Excel | Leave a comment

Manipulating Names in Excel

Some days, I spend a surprising amount of time massaging data in Excel in order to move them from database to another. On this round, I was working with names (sometimes all capitals, sometimes not), plus the original source had… More On: Manipulating Names in Excel

Posted in Excel | Leave a comment