Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Learn Excel for Health Care Professionals
Rating: 4.1 out of 5(189 ratings)
622 students

Learn Excel for Health Care Professionals

Learn how to use Excel for your next research or quality improvement project
Created byBrady Moffett
Last updated 8/2016
English

What you'll learn

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

Course content

3 sections • 23 lectures • 1h 23m total length

  • Introduction3:53
  • Formatting Your Dataset4:14
  • Using the Find and Replace functionality2:26
  • Cut, Copy, Paste and Transpose3:36
  • Drag and Drop1:42
  • Inserting Rows and Columns2:04

    Learn how to insert a column to add patient gender in a health dataset, using right-click insert, selecting shift options for cells, rows, or columns, and labeling the header.

  • Freezing Panes2:09

    Freeze panes from the View tab to keep the top row or the first column visible as you scroll, then unfreeze to return to normal.

  • Making Sense of Dates in Excel2:55
  • Working with Dates and Times3:30
  • Working with Time2:44
  • Converting Text into Columns4:44
  • Converting from Text to Numbers2:17
  • SORT and FILTER4:43

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 this course is for:

  • 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

Report abuse