- This course has passed.
Microsoft® Excel Advanced Formulas: Logical Functions
October 10, 2023 @ 2:00 pm - 4:00 pm
$99.00Microsoft® Excel Advanced Formulas: Logical Functions course will demonstrate how to use conditional formulas namely in the Logical category. In addition, aggregate functions with testing conditions will be featured. This course will also expose the user to mixed cell referencing as well as how to create array formulas.
Objective: Upon completion of this course the Excel user will be able to work with logical functions, mixed cell referencing, and arrays. Featured functions include IF, OR, AND, as well as Nested IF and the SUMIF and SUMIFS functions.
- Logical Functions
- IF function
- AND & OR
- Nested IF statement
- IF function
- Conditional Aggregate Functions
- SUMIF and SUMIFS
- Mixed-cell references
- SUMIF and SUMIFS
- Array Formulas
- The SUMPRODUCT Function
- Creating IF Array formulas
Knowledge Source Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.