Your cart is empty.
Keep shoppingExcel Fundamentals for Healthcare
329 students
Excel Fundamentals for Healthcare
The only Excel course to use realistic, simulated EMR data. Learn data analysis, pivot tables, formulas, and more!
Created byAlex Evans, PharmD, MBA
Last updated 7/2022
English
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
Explore related topics
Course content
7 sections • 31 lectures • 2h 44m total length
Requirements
- Have a passion for learning and be interested in improving your Excel abilities
- Be ready to stand out at your organization with your newly-acquired Excel proficiency
Description
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 functions, 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 for data analysis to gain new insights into over 1000 rows of data! We'll also create charts to visualize the 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.