Full course description
This workshop covers the use of very powerful conditional functions in Excel which can greatly increase the flexibility of your formulas by allowing for variable outcomes. 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, SUMIF/AVERAGEIF/COUNTIF(S), IFERROR, and logical operators (AND/OR/NOT). We will practice with financial, organizational, and research data. (**Prerequisites: at least a basic working knowledge of Excel spreadsheets and simple formulas.)
Date/Time: July 6, 9:00-11:00 AM
Location: Information Technology Center, room ITC173
Instructor: Alec Muthig, UWIT Training
- Send questions regarding this course to email@example.com.
- 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 firstname.lastname@example.org at least 24-hours before the listed start time. Remote course attendance is not available for all workshops, and may have specific requirements.
- Workshop fees are non-refundable (unless the class is cancelled by UWIT Training).