Teaching analytics with modern Excel
I don't know about you, but I'm always impressed when I'm filling out a contact form online, enter in my phone number 5551238776 and see it transformed to (555) 123-8776.It's not much, but it shows …
Continue Reading about Setting cells to phone number format in Excel →
Hidden rows in Excel are sketchy. They're part of the reason why some people hate Excel.They give Excel a bad name.The most famous example of hidden cells gone horribly wrong was Barclays not …
I really enjoyed this piece by Robert Kosara on "spreadsheet thinking vs database thinking." Describing the former as "short and fat" and latter as "long and skinny," Robert documents why …
Continue Reading about Spreadsheet Thinking, or Bad Thinking? →
Last night I called in to a Blab hosted by Bob King starring Oz du Soleil. I mentioned some of the inconsistency and false logic I see with data. The pretty dashboards and statistics are the easy …
Continue Reading about Messy Data Horror Stories! I Brought My Own to Share →
Conditional formatting is great for making quick sense of your data visually. It's a good idea to check for duplicates when receiving a dataset like this one. The next step of course is to figure out …
Usually when you apply a filter to your Excel workbook it applies to the whole data tab. Sometimes you don't want this. Here is a great workaround from "Learn Excel 2007 through Excel 2010 From …
Continue Reading about Filter on just part of a tab in Excel →
