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 …
“The End of College” and the Future for Analysts
I read Kevin Carey’s The End of College, a surprisingly controversial book. Carey lists the flaws of American higher education and predicts how "creative destruction" will upend it. These …
Continue Reading about “The End of College” and the Future for Analysts →
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 →
The Unified Theory of Analysts
When looking for my first full-time job, I knew I wanted to be an “analyst.” But there were so many analyst titles – financial business, and systems, to name a few. How are they all alike and …
Five Ways to Find a Tribe
I’ll be unique and call Seth Godin's Tribes influential. The book shows that connections fuel today's economy, and success depends on finding your network. The problem: I have not found my tribe. …
What I’ve Learned from Self-Publishing
I've self-published a number of Kindle e-books as part of my blog. This has been one of the most challenging and rewarding parts of the blog. A few lessons: People love free content... I had heard …
Continue Reading about What I’ve Learned from Self-Publishing →