Excel Dexterity: Logic Functions (video)

  • Credits: 2
  • Format: Self-Study Video
  • Field of Study: Computer Software
  • Author/Speaker: David Ringstrom
Course ID: Advanced Preparation: Experience Level:
DR-617.21 None Overview
Published Date: Program Prerequisites: Other Course Formats:
© June 2020 Basic Understanding of Technology N/A

In this fast-paced presentation Excel expert David Ringstrom, CPA begins with a brief discussion of the IF function and then quickly moves beyond the basics. You'll see the pros and cons of nesting multiple IF functions together, along with that include IFS, CHOOSE, VLOOKUP, SUMIF, and several other worksheet functions. You'll also see techniques useful in confirming that complex formulas, such as nested IF functions, are working properly.

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He’ll draw to your attention any differences in Excel 2013, 2010, or 2007 during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.

Topics include:
  • Using the SUMIF function to summarize data based on a single criterion.
  • Learning about the IFNA function available in Excel 2013 and later.
  • Viewing the pros, cons, and limitations of nesting IF functions.
  • Discovering the capabilities of the SUMPRODUCT function for calculating payroll and other amounts.
  • Returning the inverse of a TRUE/FALSE test by way of Excel’s NOT function.
  • Reconstructing spreadsheet data to use VLOOKUP as a better alternative to nesting IF functions.
  • Discovering the capabilities of the SUMPRODUCT function for calculating payroll and other amounts.
  • Facilitating decision-making within Excel formulas by way of the IF function.
  • Understanding when you might wish to use ISERROR or ISNA instead of IFERROR.
  • Streamlining the decision-making process with the IFS function in Office 365.
  • Employing the SUMIF function to sum values related to multiple instances of criteria you specify.
  • Employing the SUBSTITUTE function as an alternative to complex formulas based on the IF function.

Learning Objectives:

After reading the course material, you will be able to:

  • Recall the maximum number of criteria pairs that the SUMIFS function permits.
  • Identify the worksheet function that enables you to determine whether at least one logical test returns true.
  • Identify the versions of Excel that offer the IFNA worksheet function.

Who Should Attend:
  • All Certified Public Accountants (CPAs)

Qualifies and Approved with all State Boards of Accountancy and the following sponsorship’s: