New Excel Crush: WEEKDAY

Function: WEEKDAY Awesome?: Super awesome and easy to use. What’s it do?: It spits back the number based on the day of the week your date is. ¬†(ex. Sunday=1, Monday=2, etc). Today I found a new Excel function called WEEKDAY!¬†Since I work in healthcare, I used it on a scheduling file that documented the fields “appointment create date” and “appointment […]

» Read more

WTF Excel data

Hello. Do you know how to use a search engine (ex. Google)? Congrats! I just saved you money and saved your lovely time. Please don’t pay anyone to show you how to use Excel. No good at it? Here are some tips: Have a real problem to solve- I know this is technically hard to achieve if your goal is […]

» Read more

Data are hard

First posts are fairly difficult. Perhaps not as difficult as extracting data and then knowing what to do with it. Data are hard. Yes, “data” is the plural form of datum. I work a lot with data and this blog is a dump of irritations, successes and new exciting things. I also work in healthcare quality so expect all things […]

» Read more