Weighted averages aren't intuitive, but they come up in business all the time. Fortunately, Excel has a quick function for calculation weighted averages. If you're a student, you may be more familiar …
Mark Twain, Data Analyst
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 …
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 …
Find String Length with LEN()
The other day at work I was presented with a list of physicians for whom I needed to find some information. This was necessary only for physicians with ID numbers over 3 characters long.Rather than …
Happy boss > Fancy formula
Chandoo runs a great Excel site at chandoo.org. I really like his site because he frames Excel problems from the viewpoint of a real life data analyst. He's been one and he knows what makes analysts …