Here's a nice keyboard shortcut I recently picked up. …
Continue Reading about Keyboard Shortcut: Rename Worksheet in Excel →
Why PivotTables?
You probably didn’t expect etymology in this book, but it here goes. When I probably should have been learning Excel in high school, I took a Greek class instead.I haven’t used my Greek a lot, but one …
10 Commandments for Spreadsheet Collaboration
Hell is other people's spreadsheets.There is a Russian proverb that you don't really know someone until you have shared a pound of salt with him. In the office, you don't really know someone you have …
Continue Reading about 10 Commandments for Spreadsheet Collaboration →
Excel Tip: Freeze, Formula!
I promise I didn't post this just to use this great (free!) photo from Gratisography. No, it's because this is one of the niftier Excel hacks that doesn't get much publicity.Unwinding a formula in …
VLOOKUP with a Crystal Ball
I call vlookup the "duct tape of Excel" -- it's a cheap, easy way to patch together two sets of data. Like with any patchwork solution, things can get out of order. How to avoid constantly …
Build your own Heatmap in Excel
Conditional formatting is a great tool in Excel. It sounds fancy, but if you've ever color-coded anything before, you know how conditional formatting works. Given the rules you provide Excel, it …