Analytics & AI for Modern Excel
Sad or not, I've placed most of my life around the frame of my undergraduate career (BH and AH, "Before Hillsdale" and "After Hillsdale.")So I'm often reminded of how many years have passed …
Continue Reading about Grad School: 5 Changes I’ve Noticed Since Returning →
A reader had a group of items separated by commas which he wanted to turn into a vertical list. In this video I show how to transform the data using text-to-columns and paste special: …
Continue Reading about Excel Tip: Turning a comma-separated group of items into a vertical list →
Longtime blog readers know that I am ambivalent toward networking events. I explain my position in my course on networking for analysts. So a friend was surprised when I suggested we meet at a …
Continue Reading about Stop Asking “What Do You Do!” Try This Instead. →
Subscribe and get more tips for the awesome analyst. Plus, your free ebook.The return to higher education can be brutal. So much reading and writing, so much unstructured time to manage. It's quite …
Continue Reading about Why “Treating It Like a Job” Is a Bad Idea →
In our last information systems seminar, we discussed the concept of "rigor vs. relevance." That is, how do you research with scientific rigor while maintaining managerial relevance?These are …
Continue Reading about Low-and-Low, or: Is It Really Rigor vs. Relevance? →
Most of my work has been about how you as an analyst can impress at interviews. But we should look at this from the other side of the table, too. How can you protect yourself from getting into a …
Continue Reading about 5 Questions to Ask Before Taking that Analyst Job →
