Recently I downloaded a large number of RTF files. Wanting to analyze this text data in R, I first needed to strip RTF encoding. In this video I use the striprtf library to loop through a folder of …
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 …
Continue Reading about Assign Cell Color Fills to Custom Keyboard Shortcuts in Excel →
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 …
Continue Reading about R for Excel Users: The XLView() Function →
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 …
Continue Reading about Get Real-Time Cryptocurrency Prices from Yahoo! Finance to Excel →
Making Easy, Flexible Histograms with PivotTables
This post accompanies my segment on MyExcelOnline's "Best Excel Tips of 2017 Podcast." The first commandment of data analysis: KNOW THY DATA! It's always smart to get a feel for your data's …
Continue Reading about Making Easy, Flexible Histograms with PivotTables →
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 …
Continue Reading about Innovation and the Liberal Arts: Guest Post for Hillsdale College →