Full course description
University of Wyoming students and employees can receive a $10 discount on this course. Email computer.training@uwyo.edu for the discount code.
This research-oriented online course provides over three hours of video demonstration, as well as instruction sheets and practice files, so that you can expand your toolkit and learn to more efficiently collect, analyze, visualize, present, and publish your data using Microsoft Excel. Enrollment includes a certificate of completion as well as continued access to the course for future reference.
Specific topics include:
- Essential Excel functionality
- Data preparation
- Special cell addresses & ranges
- Research formulas, functions, and named ranges
- Categorizing data using VLOOKUP
- IF functions for variable calculations
- PivotTables for summary analysis of research data
- Presenting data tables in PowerPoint (including the ability to slowly reveal data)
- Data visualizations (including custom error bars)
- Using charts in presentations
- Exporting high-quality charts for publication (beyond Excel's standard low resolution)
- Captioning figures in a manuscript or report
- Statistical analysis add-ins
- Identifying outliers
- And more!
Pre-requisites: An understanding of basic Excel functionality is recommended prior to starting this intermediate+ level course.
Instructor: Alec Muthig
Testimonials:
“This was really helpful to me, and I'm going to recommend it to all of my students collecting data to write reports and give presentations for larger projects. I think it could really help students working on dissertations especially because of the simplicity of Excel vs the power provided by an SPSS, or trying to code in R. As for my own research, I can see how I will use my new knowledge to be able to initially look at data in different ways before importing into another software, if needed.” ~ JoeS