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 …