Excel: Data Validation (Jun.16, 1:30-3:00 PM, via Zoom)

Course Description:

UW accounts can take this course for free; email computer.training@uwyo.edu for the promo code.

This workshop examines how to use Excel’s data validation tools to create dropdown lists and apply other rules that will make your data entry (and analysis) easier and more consistent.

Data validation in Excel allows you to create rules to help guide or enforce specific data entry into cells. Use of validation can make data entry much easier (i.e using dropdown menus) and can make your data more consistent, saving time when attempting to analyze your data with pivot tables, formulas, or other tools. Validation rules can also be used to discover problematic data. In this workshop, we will work through multiple exercises, applying validation rules that start simple but get slightly more complex as we go! 

*Prerequisites: This is an intermediate-level course. Some experience with Excel is required, including the ability to write simple formulas.

Date/Time: Jun.16, 1:30-3:00 PM (mountain)

Location: via Zoom (a meeting link will be provided after enrollment)

Instructor: Alec Muthig, UWIT Training

Important Information:

• Send questions regarding this course to computer.training@uwyo.edu
• Please make sure to connect at least 5 minutes before the class is scheduled to begin.
• Workshop fees are non-refundable (unless the class is cancelled by UWIT Training).