Learn Excel for Health Care Professionals
2.5 (2 ratings)
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.
17 students enrolled
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
2.5 (2 ratings)
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.
17 students enrolled
Created by Brady Moffett
Last updated 8/2016
English
Current price: $10 Original price: $35 Discount: 71% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
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
Requirements
  • A basic understanding of Microsoft products (such as opening and saving files) is all that is necessary.
Description

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
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
02:26

Cut, Copy, Paste and Transpose
03:36

Drag and Drop
01:42

Inserting Rows and Columns
02:04

Freezing Panes
02:09

Making Sense of Dates in Excel
02:55

Working with Dates and Times
03:30

Working with Time
02:44

Converting Text into Columns
04:44

Converting from Text to Numbers
02:17

SORT and FILTER
04:43
+
Using Functions
7 Lectures 32:10

Using the CONCATENATE Function
03:13

Using IF Statements
07:07

Using the VLOOKUP Command
06:21

Overview of Pivot Tables
05:45

Quick Tips
02:08

Using IF and TRUE to Clean a Dataset
03:04
+
Introduction to Basic Statistics
3 Lectures 10:47
Descriptive Statistics in Excel
05:17

Performing a Student's t-test in Excel
04:28

R Squared Value
01:02
About the Instructor
Brady Moffett
2.5 Average rating
2 Reviews
17 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.