Purna Duggirala is known to Excel users worldwide as Chandoo. His site,Chandoo.org, is my go-to Excel resource. Chandoo has a variety of Excel media from blog posts and videos to full online …
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 →
;;; And I’m Through With You
Here's a nice Excel shortcut. Say you want to leave data in a cell but wish to make it invisible. You can do this by going to the Format Cells menu (keyboard shortcut: Ctrl + 1), selecting Custom, …
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 …
Highlight Every Cell Containing a Formula
Checking for data accuracy is tricky in Excel. In this blog, I have been presenting some of my tips. This is a great one for more visually-oriented users. We have a simple inventory model below. …
Continue Reading about Highlight Every Cell Containing a Formula →