Course Description:

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

This workshop covers the use of very powerful "branching" or conditional functions in Excel which greatly increase the flexibility of your formulas. Use these functions to calculate total expenditures within specific funds, determine a variable’s value based on specific criteria, and more! Functions to be covered include: IF, IFS, SUMIF(S)/AVERAGEIF(S)/COUNTIF(S), IFERROR, and logical operators (AND/OR/NOT) – with a few special tricks thrown in! We will practice with financial, organizational, and research data.

This class will help you find out how to work these formulas into your spreadsheets! (2 hour session + 30 minute optional practice lab)

Prerequisites: To participate, you should have at least a basic working knowledge of Excel spreadsheets AND some experience writing basic formulas.

Date/Time: May 6, 1:30-3:30 PM (mountain) plus a 30 minute optional practice exercise

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

Instructor: Alec Muthig (UWIT)

Important Information:

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

Enroll inExcel: IF Functions (May 6, 1:30-3:30 PM, via Zoom)