Spreadsheets are super powerful, but they have limits. This article examines four big challenges of working in spreadsheets, and shows how data science tools such as notebooks can cleverly address ...

I’ve just started exploring Excel 2016. As one of the tentpole applications for the new Office 2016, it has a raft of new features for lucky upgraders. Take a closer look with me and see what you ...

After covering a recent session on data munging with Excel, I wanted to see how those tasks could be accomplished in R. Surely anything you can do in a spreadsheet should be doable in a platform ...

This guide will walk you through the basics of automating data cleaning in Google Sheets using Python and Pandas.

Spreadsheet blunders aren’t just frustrating personal inconveniences. They can have serious consequences. And in the last few years alone, there have been a myriad of spreadsheet horror stories. In ...