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 →
No more clumsy file paths! Email “Live” Hyperlinks from Office
Here's a shortcut I use that impresses people at the office.When collaborating on an Office document, people often either send an attachment of the file or send a "dead" (as in, un-linked) …
Continue Reading about No more clumsy file paths! Email “Live” Hyperlinks from Office →
Excel, Big Data, and Google Trends: What’s Going On?
Trends is a lesser-known Google tool that allows you to follow search interest of a particular topic. Here's an unscientific but interesting trend I noticed tonight. As an analyst, I live in …
Continue Reading about Excel, Big Data, and Google Trends: What’s Going On? →