Full course description
Course Description:Explore Excel tips, tricks, specialty functions, and more that could help your research projects. Specific topics include:
- Using common research functions (mean, median, mode, standard deviation)
- Quick statistical summaries
- Simple unit conversions
- Truncating and rounding numbers
- Separating populations into tertiles and quartiles
- Correlation coefficients and statistical significance
- Special example/exercise of using named ranges on a dataset to rapidly build an analysis sheet
- Special example/exercise of using VLOOKUP to automatically classify data
- And more!!!
Prerequisites: This is an intermediate-level class. Participants should have a working knowledge of Excel and be able to write basic formulas. Please note that due to the short duration of this workshop, we will not be covering the concepts or mathematics, and will just be focusing on Excel functionality, thus a working understanding of the topics will be helpful.
Date/Time: Sept.25, 2:30-4:30 PM
Location: Information Technology Center, room ITC171
Instructor: Alec Muthig, UWIT Training
- Send questions regarding this course to
- Please make sure to arrive at least 5 minutes before the class is scheduled to begin.
- If you are not on campus and would like to attend this course remotely via Zoom, please email a request to Remote course attendance is not available for all workshops, and may have specific requirements. at least 24-hours before the listed start time.
- Workshop fees are non-refundable (unless the class is cancelled by UWIT Training).