Loading Courses

« All Courses

  • This course has passed.

Microsoft® Excel Advanced Formulas: Logical Functions

October 10, 2023 @ 2:00 pm - 4:00 pm



The numbers below include tickets for this event already in your cart. Clicking "Get Tickets" will allow you to edit any existing attendee information as well as change ticket quantities.
Tickets are no longer available

Microsoft® 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
    1. IF function
      1. AND & OR
      2. Nested IF statement
  • Conditional Aggregate Functions
    1. SUMIF and SUMIFS
      1. Mixed-cell references
  • Array Formulas
    1. The SUMPRODUCT Function
    2. 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:


October 10, 2023
2:00 pm - 4:00 pm
Courses Category:


Virtual Live

Leave a Comment

Your email address will not be published. Required fields are marked *