Course Description:

Special: UW accounts can take this course for free; email computer.training@uwyo.edu for the promo code by Jun.29.

This workshop sets a foundation for efficient formula-building in Excel, introduces multiple useful functions and tips, and prepares you for more advanced formula workshops. Topics include:

• Getting started with formulas (understanding formula syntax)
• Best-practices for building efficient, dynamic formulas
• When to use relative vs absolute (locked) cell addresses
• Common functions
• Using the function library
• Cross-worksheet formulas
• Common mistakes and error messages

Please note that this course is designed for those with minimal to moderate formula experience and is not an advanced formula-writing class. For intermediate-advanced training, see our Excel Research Skills (online), VLOOKUP, and IF classes.

Prerequisites: none

Date/Time: Jun.30, 1:30-3:30 PM (mountain) plus a 30-minute optional but recommended practice exercise immediately following class

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).