A topic of interest to me as a liberal arts grad is the similarity between good writing and good data work.Mark Twain famously said, "I didn't have time to write you a short letter, so I wrote a long …
Don’t be dim… use MID()!
MID( ) is intimidating for such a short function.But when you're in the process of data "wrangling" -- that is, transforming it for more useful analysis -- it can be very useful.Many numbers in …
Healthcare Analyst: The Wrangling Fox
Something I haven't written much about -- and that I'm asked about often -- is my work as an analyst at a public health system in Ohio. I plan to write on it more, so if you've got any questions or …
Continue Reading about Healthcare Analyst: The Wrangling Fox →
Hip, Hip, COUNTA( ) !
I was ready to toast this function at work today.Presented with a list of encounters by physician, I wanted to know how many cells in the array were blank. This meant that we did not have data for …
Y U No…
After receiving three reports before noon on Monday that were not printer-ready, I had to take a time-out for this:Keep in mind that many older coworkers still prefer printed documents. And …
Excel: Lego for Grown-ups
I love using Excel because it's so flexible and adaptable. There's no better vehicle for quick, easy data analysis.Chandoo of chandoo.org often emphasizes the importance of playfulness and interaction …