Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Basics of Developing a Dataset|
Formatting Your DatasetPreview
Using the Find and Replace functionality
Cut, Copy, Paste and Transpose
Drag and Drop
Inserting Rows and Columns
Making Sense of Dates in Excel
Working with Dates and Times
Working with Time
Converting Text into Columns
Converting from Text to Numbers
SORT and FILTER
|Section 2: Using Functions|
Introduction to Using FunctionsPreview
Using the CONCATENATE Function
Using IF Statements
Using the VLOOKUP Command
Overview of Pivot Tables
Using IF and TRUE to Clean a Dataset
|Section 3: Introduction to Basic Statistics|
Descriptive Statistics in Excel
Performing a Student's t-test in Excel
R Squared Value
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.