In business, you're often fitting square pegs into round holes. Shipments of merchandise come in different quantities than you can display them.Join the MOD( ) squad!This Excel function will …
Four Years an Analyst
This week was a milestone. I've been in the full-time workplace for four years!Where I've ComeArmed with a bachelor's degree from a fantastic liberal arts school and a master's in finance from a …
Don’t Weight to use SUMPRODUCT
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 …
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 →