Teaching analytics with modern Excel
Healthcare produces massive amounts of data. Use data visualization to make meaning of it all. This is an introduction to some of the most powerful data visualization principles I've learned as a …
Continue Reading about Excel for Healthcare Preview: Intro to Data Visualization →
This is a preview of my forthcoming course on Excel for healthcare.Why an Excel course on healthcare? Because less time fumbling with data means more time running a better practice.Are you a …
Continue Reading about Excel for Healthcare: About me … and you →
I'm happy to share my tentative curriculum for a new course on Excel for healthcare professionals.The motivation to blog about Excel was for analysts in general but more specifically for healthcare …
Continue Reading about Course Preview: Excel for Healthcare Professionals →
The WEEKDAY( ) function will return a number representing the day of the week for any date.In this example, I will show you how to use this to transform an on-call calendar from a slow, manual …
Continue Reading about Excel for Healthcare Tip: Calculating On-Call Points with WEEKDAY( ) →
Healthcare data may be the reason I started this blog.I have been a business analyst at a hospital for nearly three years now. Healthcare is fascinating. The data -- it's just challenging. While …
Continue Reading about Why is healthcare data so messy for business analysts? →
In this video I show how to take a PDF from CMS (Centers for Medicare & Medicaid Services), convert it to Excel, and transform it into a Pivot Table-friendly table with just a few keystrokes.Check …
Continue Reading about Converting a CMS Table to Excel to analyze HCPCS codes →
