I've compiled the best image quotes I have made for the blog. Topics range from business analytics to entrepreneurship. All are meant to inspire the savvy analyst.Check out the collection here. …
Excelstentialism and Systems Blogging
One thing I've grappled with frequently on this blog is whether I am an "Excel blogger."It is probably increasingly clear that I do not primarily write about Excel. This is especially true …
Continue Reading about Excelstentialism and Systems Blogging →
Excel Tip: Find and Conditionally Format Greatest Range Difference
This is a template that I used today in working through a statistics problem. In the video we will cover-finding the greatest and smallest values in a range with MAX and MIN-a simple IF …
Continue Reading about Excel Tip: Find and Conditionally Format Greatest Range Difference →
The Confidence Interval Economy: Mistakes and Career
Excellent piece yesterday by Rob Collie at PowerPivotPro about seeing yourself as a Michelangelo of data.This is a topic that I discussed many times that I am totally on board with. I have argued to …
Continue Reading about The Confidence Interval Economy: Mistakes and Career →
Grad School: 5 Changes I’ve Noticed Since Returning
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 →
Excel Tip: Turning a comma-separated group of items into a vertical list
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 →