Online Registration

Excel Lists, Formulas and Functions (Akron Campus)

Dates: August 9, 2021

Meets: M from 1:00 AM to 4:00 PM

Location: Akron Campus, Polsky Building 451C

Course Fee: $59.00

Covering formulas, check errors, evaluate formulas.
You will work with lists, learn about range names and how to use them in logical functions and lookup functions. In addition, you will learn about date and time functions, including finding the day of the week and the week number.

Logical Functions
- IF Functions
- Nested IF Functions
- AND Functions
- OR Functions
- NOT Functions

Database functions
- SUMIF / SUMIFS
- AVERAGEIF / AVERAGEIFS
- COUNTIF / COUNTIFS

Lookup Functions
- VLOOKUP Functions
- HLOOKUP Functions
- FIND and LEN Functions
- MATCH Functions
- INDEX Functions

Date and Time Functions
- Time Dates
- NOW Functions
- WORKDAY Functions
- NETWORKDAYS Functions
- Finding the Day of the Week
- Finding the Week Number

Formula Auditing
- Data Validation
- Protecting Sheets
- Formula Auditing

Fee: $59.00
Hours:3.00
CEUs:0.30

Akron Campus, Polsky Building 451C

225 South Main Street
Akron, OH 44325
www.uakron.edu

Theodore Younessi

Share

Email Information to Friend Print