Excel Lists, Formulas and Functions
Dates: June 25, 2019
Meets: Tu from 9:00 AM to 12 N
Course Fee: $59.00
Sorry, we are no longer accepting registrations for this course. Please contact our office to find out if it will be rescheduled, or if alternative classes are available.
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
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 |
Theodore Younessi
powered by ACEweb from ACEware Systems, Inc.
Privacy
Site Map