Teaching analytics with modern Excel
As I have been fumbling my way through learning Python, online forums and communities have fascinated me. Why are some forums strict to the point of rudeness and others nearly a yes-man …
Continue Reading about Excel’s Online Communities: Interview with Alex Powers →
Ah, online code forums.They can be a great place to give and receive advice cordially.But sometimes the vibes can be a bit.... harsh.I hadn't spent too much time on code forums before this semester. …
Continue Reading about Down Goes the Ladle: Understanding Code Forum Culture →
Why is Domo not the answer? What does playing the bass have to do with developing a spreadsheet? Watch and learn! I had a spirited conversation with Oz du Soleil and Alex Powers on Alex's It's Not …
Continue Reading about From Reddit to Slap Bass: It’s Not About The Cell Live! →
"You don't really know a person until you have shared a pound of salt with him." -Russian proverb"You don't really know a coworker until you have shared a spreadsheet with him." - georgejmount.com …
Continue Reading about You don’t really know a coworker until… →
Download the exercise file here.Let's say you need to come up with a seating chart. Using RANDBETWEEN, you may get duplicate entries for the same number, or missing numbers.Using RAND in conjunction …
Continue Reading about Generate Unique, Non-Repeating List of Numbers in Excel with RAND and RANK →
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( ) …
