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? →
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 …
Ctrl + ~ : An X-ray of your spreadsheet
This is one of my favorite Excel keyboard functions, used in frequency only after Ctrl + S, but not many know about it. Excel is great for easy data analysis, but it is hard to check for errors. …
Continue Reading about Ctrl + ~ : An X-ray of your spreadsheet →