Excel's greatest strength -- and its greatest weakness -- is the ease of users to manipulate the basic data. Done well and the capability affords flexibility; done poorly and you are left with …
Pivoting on Text in R (vs. Excel)
This post follows a previous tutorial on pivoting on text in Excel. In this post I will reproduce the exercise in R. This way you begin to see the similarities and differences of the program and begin …
Pivoting on Text in Excel: Awards by Player PivotTable
This post is inspired by a Mr. Excel tutorial on using "text instead of numbers in a Pivot Table." Our goal is to create a Pivot-Table like report that creates a comma-separated list …
Continue Reading about Pivoting on Text in Excel: Awards by Player PivotTable →
Why Your Next Worker Should Be a Blogger
A major theme of this blog has been getting "Hired with Excel." This was motivated by my own experience as a liberal arts grad, seeing the importance of Excel for my employment prospects. Knowing one …
Continue Reading about Why Your Next Worker Should Be a Blogger →
How Fiction Makes Me a Better Analyst
It is my hope that this blog goes beyond simple tips and tricks into helping people become more fluent in data and, by consequence, innovation. One of my first and still favorite blog posts was on …
Continue Reading about How Fiction Makes Me a Better Analyst →
Creating the Future with the Liberal Arts
Recent college graduates are in the envious position of entering the best labor market in decades. But, in the spirit of Mark Twain, I encourage new workers not to let their job get in the way of …
Continue Reading about Creating the Future with the Liberal Arts →