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.
• 13 students enrolled
$19
$35
46% off
Take This Course
  • Lectures 23
  • Length 1.5 hours
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 8/2016 English

Course 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.

What are the requirements?

  • A basic understanding of Microsoft products (such as opening and saving files) is all that is necessary.

What am I going to get from this course?

  • Set up a research or quality improvement dataset in Excel.
  • Perform basic statistical analyses on a dataset in Excel.

What 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Basics of Developing a Dataset
Introduction
Preview
03:53
Formatting Your Dataset
Preview
04:14
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
Section 2: Using Functions
Introduction to Using Functions
Preview
04:32
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
Section 3: Introduction to Basic Statistics
Descriptive Statistics in Excel
05:17
Performing a Student's t-test in Excel
04:28
R Squared Value
01:02

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Brady Moffett, 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.

Ready to start learning?
Take This Course