Excel Fundamentals for Healthcare
Master the fundamentals of Excel for healthcare professionals and gain confidence in analyzing data from EMR systems. Learn advanced functions and techniques to stand out at work and create project management tools. Ideal for healthcare providers, pharmacists, and quality leaders looking to extract meaningful insights from Excel for business decision making.
What you’ll learn
- MASTER the fundamentals of Excel, so you feel comfortable working with a variety of data sets
- Gain an understanding of advanced Excel functions, like MATCH, visuals, and Sparklines, to stand out at work and solve even the most difficult problems
- Be capable of using Excel for data analysis, so you can answer nearly any question asked of you about the data set
- Be capable of using Excel to create project management tools for quality improvement and measurement
Welcome to Excel Fundamentals for Healthcare!
This course was created to improve your ability to work in health care and use Excel to analyze data from your EMR or EHR. It is also designed to show you how to use Excel to manage projects.
It is intended to give you a solid foundation of the basics of Excel, while also introducing you to advanced Excel functions that are powerful for providing in-depth insights into your healthcare organization’s data.
This course is best for learners who work in health care and have either never used Excel before or have used it, but would like to become more familiar with its features and gain confidence applying it to real-life scenarios.
This course purposely DOES NOT last hours and hours, teaching every single function Excel has or going in-depth into functions you would be unlikely to encounter on a regular basis.
It DOES focus on being concise and teaching the most important, high-impact Excel functions and techniques YOU NEED for your health care job.
This is the only course on Udemy to teach from simulated, realistic EMR data!
The simulated EMR data set used in this course contains 1000 rows, with two tabs representing two different sample reports that might come out of an EMR system, so you get practice working with data that will look very similar to your organization’s.
This course is divided into the following sections:
Excel fundamentals: Here, we’ll start from zero and go through formatting, the basics of formulas, and some of the most useful yet simple formulas in Excel that I used on a near-daily basis in my role as a healthcare project manager and data analyst.
Advanced functions: Now the fun begins as we delve into more advanced functions that unlock your ability to really delve into the data. Learn how to effectively use the MATCH function to compare two data sets, how to use visuals to win over your audience at the next presentation, and more!
Putting it all together – Data Analysis: In this section, I’ll use our data sets so you can see, in realtime, how to use what you’ve just learned to gain new insights into over 1000 rows of data!
Putting it all together – Project Management: Finally, we’ll start with a blank Excel file and use what we’ve learned to create a beautiful project management tool so you can keep your next initiative on track!
Who this course is for:
- Healthcare providers, pharmacists, and other professionals who want to improve their ability to extract meaningful data from Excel.
- Anyone who works in the healthcare industry in data collection, analysis, or project management.
- Healthcare quality leaders that must lead and evaluate quality improvement projects.
- Healthcare executives and administrators, to gain a strong foundation in Excel for business decision making.
User Reviews
Be the first to review “Excel Fundamentals for Healthcare”
You must be logged in to post a review.
There are no reviews yet.