Download the exercise file here. Requires Excel 2013 or greater. These are new functions in Excel. You can import .XML data straight from the web into Excel with the WEBSERVICE( ) and FILTERXML( ) …
A Theory of Creativity: Or, Why 2016 Really Sucked
To my audience....Here we are, the last laps of 2016.Forget the year's headlines. Sporting events. Celebrity deaths. How much do they really affect you? (Being a proper blog, we tend away from …
Continue Reading about A Theory of Creativity: Or, Why 2016 Really Sucked →
So, you want to work in hospital administration?
It's a slow week, the last week of the year. Time to break down gift boxes, heat up leftovers, and reflect on the year gone by. It seems like a lifetime ago that I left my job at a hospital to …
Continue Reading about So, you want to work in hospital administration? →
I ordered Chinese takeout… then this happened
The other day the family ordered Chinese takeout.Normally one of us would take out a notepad and scribble notes, which often became illegible and ran across multiple pages. There has to be a better …
Continue Reading about I ordered Chinese takeout… then this happened →
To Good Friends and Good Spreadsheets!
Can you believe it? We are approaching the final week of 2016.It's been a big year here at the blog. Some highlights:Appeared at Excel.TV in the springReleased an ebook of my top essays in the …
Continue Reading about To Good Friends and Good Spreadsheets! →
Generate Random Qualitative Data in Excel with CHOOSE()
What's the only thing better than real data? Fake data! Well, at least sometimes -- such as for conducting training or testing models. Subscribe to the newsletter for more Excel tips and tricks. …
Continue Reading about Generate Random Qualitative Data in Excel with CHOOSE() →