Harry Potter fan? Think of Excel as your data's house elf. An Exc-elf, as I say.Tonight I am reading Guerilla Data Analysis Using Microsoft Excel. Excellent book: you can tell the authors have been …
Randomly Sort a List in Excel
At work I often graph individual physician statistics against each other but want to do this anonymously. To do this, I sort my source data randomly.Be sure to subscribe to the newsletter for more …
Add Hyperlink in Excel
Ctrl + K allows you to insert a hyperlink in Excel. Be sure to use this when linking to the site! …
What day is it? Excel knows.
Ever been in such flow with your spreadsheet that you forgot what day it is? Here's a nice keyboard shortcut. Ctrl + ; will insert today's date. …
More Filtering Fun
Yesterday I quoted a tip on filters from "Learn Excel from Mr. Excel," a great read. Filters are a powerful Excel feature. They allow you to hone in on your data. The only problem is they're a little …
Filter on just part of a tab in Excel
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 →