Assign Cell Color Fills to Custom Keyboard Shortcuts in Excel

When exploring a workbook, I like to color-code cells so that I remember what I need to do with that information. Red cells indicate I need to take action on something, while green means all systems go. Yellow means either neutral, or that I haven’t decided yet! That’s my system, anyway. And maybe you have your […]

R for Excel Users: The XLView() Function

It’s time for another post about R. I’ll admit, these days most of my work is done in R. But, I still love using Excel, and I really do enjoy teaching and blogging about it. Fortunately, these two platforms work great together… they collide, in a good way. And XLView() is a great example. Subscribe […]

Get Real-Time Cryptocurrency Prices from Yahoo! Finance to Excel

I’ve been a casual student and advocate of cryptocurrencies since ca. 2014, but recent news has attracted me (along with everyone else and their Uber driver) to them more seriously. Subscribe to my newsletter for your free ebook, “The Beginner’s Guide to Getting Hired with Excel.” This afternoon, I wanted to find a way to […]

Making Easy, Flexible Histograms with PivotTables

The first commandment of data analysis: KNOW THY DATA! It’s always smart to get a feel for your data’s distribution. Histograms offer a great way to visualize the distributions of a variable of interest. Download the exercise file here. A histogram is a bar-chart visualization where the data is grouped into ranges. While Excel offers […]

Innovation and the Liberal Arts: Guest Post for Hillsdale College

Central Hall, Hillsdale College, Hillsdale, MI Ah, guest posting. It’s something that you’re supposed to do as a blogger. They give you access to new, bigger audiences who are eager to find new authors. Sometimes I find the right outlet difficult. The economics of blogging allows your voice to be so niche and unique that the […]