A good Excel analyst thinks about formats. Do these borders, colors and blocks help drive the overall narrative of your data? Or do they just make it look busy?Formatting can be a significant …
Multiply a Whole Range by the Same Cell
Here's a feature that takes advantage of the powerful "Paste Special" features in Excel. Say you've got a list of sales by employee and week. The sales reps get a 10% commission. You can easily …
Continue Reading about Multiply a Whole Range by the Same Cell →
Exc-elf?
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 …
Network Like a Southerner
Know a good way to tell a Northerner from a Southerner?When a Northerner meets you, he'll ask "What do you do? A Southerner will ask "Where are you from?"This signifies the North's emphasis on …
Add Hyperlink in Excel
Ctrl + K allows you to insert a hyperlink in Excel. Be sure to use this when linking to the site! …