Subscribe to the newsletter for more Excel tips and tricks. Plus, your free ebook!I read Seth Godin's We Are All Weird this afternoon. Highly recommended -- in fewer than 100 pages, Seth covers how …
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? →
I Got My Space Back (the Power of Routine)
I got my parking space back today. A snow bank had been occupying it. But with spring here, the space returns to its rightful owner. With my space back, my day has improved dramatically. I have …
Continue Reading about I Got My Space Back (the Power of Routine) →
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 →