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 […]

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 […]

So Long as There’s Small Business, There Will Be Small Data (and Excel)

This week, with a little time off between semesters, I’ve been helping a family member with financial reporting & analysis for his business. It’s been over a year since I worked in finance and this exercise reminds me how frustrating this can be and how critical a strong command of Excel is to modern data […]