Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Learn Excel for Health Care Professionals to your Wishlist.

Add to Wishlist

Learn Excel for Health Care Professionals

Learn how to use Excel for your next research or quality improvement project
4.0 (1 rating)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
14 students enrolled
Created by Brady Moffett
Last updated 8/2016
$10 $35 71% off
5 days left at this price!
30-Day Money-Back Guarantee
  • 1.5 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?

By the end of this course, you will be able to quickly and easy assemble a dataset for a research or quality improvement project, even if you aren't an expert at Excel.

These video lectures will show you how to use Excel to manage data, using examples relevant to healthcare related professions. The course starts out with the basics of entering data and using functions, and finishes with a practical example of assembling a dataset and doing preliminary statistical analysis.

Students taking this course will have skill set that will enable them to complete research projects more easily and quickly.

Who is the target audience?
  • Students, residents, fellows, and other trainees in the medical sciences who have to do a research or quality improvement project involving data
  • Anyone in a healthcare related field that is using Excel for clinical data management.
  • This is NOT a business related course - all of the lectures will be geared toward research and quality improvement in healthcare
Students Who Viewed This Course Also Viewed
What Will I Learn?
Set up a research or quality improvement dataset in Excel.
Perform basic statistical analyses on a dataset in Excel.
View Curriculum
  • A basic understanding of Microsoft products (such as opening and saving files) is all that is necessary.
Curriculum For This Course
Expand All 23 Lectures Collapse All 23 Lectures 01:23:54
Basics of Developing a Dataset
13 Lectures 40:57

Using the Find and Replace functionality

Cut, Copy, Paste and Transpose

Drag and Drop

Inserting Rows and Columns

Freezing Panes

Making Sense of Dates in Excel

Working with Dates and Times

Working with Time

Converting Text into Columns

Converting from Text to Numbers

Using Functions
7 Lectures 32:10

Using the CONCATENATE Function

Using IF Statements

Using the VLOOKUP Command

Overview of Pivot Tables

Quick Tips

Using IF and TRUE to Clean a Dataset
Introduction to Basic Statistics
3 Lectures 10:47
Descriptive Statistics in Excel

Performing a Student's t-test in Excel

R Squared Value
About the Instructor
4.0 Average rating
1 Review
14 Students
1 Course
Clinical Researcher

I am a clinical pharmacist and researcher with 15 years of experience in healthcare research.  I have a doctor of pharmacy degree and a master's in public health specializing in epidemiology.  I have over 80 peer reviewed publications in medical journals and I have mentored and advised dozens of trainees and professionals in healthcare research.  I have used Excel almost exclusively as a data management and collection tool for all of my research activities.

Report Abuse