Highlights of this course:
Addresses solutions in Excel for real-life problems of working with healthcare data
Over two hours of video training — download them, yours to keep forever
Downloadable exercise files — follow along with the course
Discussion forum — ask questions and talk about the course with the instructor and other students
Healthcare is probably the most complex industry, so it should follow that its data is hard to handle.
In my three years of experience as a healthcare business analyst, here’s what I found most difficult.
Excel can solve these pain points.
This course is best for:
– Current healthcare administrators and analysts looking to make sense of their data
– Nurses, physicians, and other clinical providers who are moving into managerial roles
– College and medical students who want a distinctive skill set as business leaders
Why exactly is healthcare data so messy, and how can Excel help?
Payroll is the most significant operating expense of a hospital. Yet there’s often no consistency or control in how people are scheduled. We will cover how to build schedules and payroll reports in Excel.
Healthcare revenue is difficult to analyze. What departments or codes are they coming from? How are the collections? Trends can change on a dime. PivotTables can keep up. We’ll cover how to analyze revenue with PivotTables.
Data often comes from legacy systems in hard-to-use formats. We will cover how to transform this into ready-to-use data with Excel.
Dashboards and visualizations can make data easier to understand and act upon. But with poor design and project management principles, they will fail miserably. We’ll cover the basics of dashboards in Excel.
You know Excel — what’s next? I’ll share some thoughts on what the future means for healthcare analysts.
Armed with a liberal arts degree and a master’s from a leading business school, I set out into the world to become an amazing analyst.
Over the past few years I have worked on projects ranging from Canadian retailing to neurosurgeon compensation. Through this experience, I’ve noticed patterns of what makes a good analyst.
Specifically, I’ve seen the best and worst in Microsoft Excel and data analysis. My online training is meant as a resource for recent grads and others who want to advance their career through Microsoft Excel, data analytics, and business economics.
I've been featured on Excel TV, the Smart Data Collective, Brazen Careerist, and other blogs about business analytics and career development.
Contact me at firstname.lastname@example.org