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 …
Keyboard Shortcut: Rename Worksheet in Excel
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 …