Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
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)
652 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
English [Auto],

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

    Learn how to structure an Excel health care data set with labeled top-row headers, vertical data values, and a codebook that defines data types, units, and collection sources.

  • Formatting Your Dataset4:14

    Format cells and apply conditional formatting to prepare clean data sets for analysis, choosing number formats, alignment, borders, fills, and protection, and using rules to highlight values.

  • Using the Find and Replace functionality2:26

    Learn how to use the find and replace functionality in Excel to convert M and F gender data to 1 and 0, accelerating data analysis in health care datasets.

  • Cut, Copy, Paste and Transpose3:36

    Learn to cut, copy, paste and transpose in Excel to reposition data labels from the middle to the top left or across the top, changing orientation.

  • Drag and Drop1:42

    Learn to auto-fill sequential patient IDs in Excel using the little green box to recognize patterns and fill the rest for large datasets.

  • 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

    Learn to compute patient age at the clinic visit in Excel by subtracting date of birth from the clinic visit date in a dataset, convert to years, and format results.

  • Working with Dates and Times3:30

    Learn to use excel date functions to calculate patient age as of today and to break the admin date into year, month, day, and weekday, then fill down for records.

  • Working with Time2:44

    Learn how Excel treats times as portions of a day, convert them to numbers, and compute time differences from admitted time to seen times by multiplying by 24.

  • Converting Text into Columns4:44

    Use text to columns to split a clinic date into month, day, and year. Choose delimited data with backslash as the separator, insert extra columns, and finish by formatting results.

  • Converting from Text to Numbers2:17

    Learn to identify numbers stored as text in health care data and convert them to numbers using Excel's convert to number option, ensuring accurate arithmetic and statistics.

  • SORT and FILTER4:43

    Discover how to sort data by age and gender, then filter by blood glucose values in Excel, including greater than 150, to identify specific patients.

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