Decision Making with Logic Functions -Video

Price: $29.99

CPE Credits: 2.0

Category: , ,

Course Number: VCXLGCDR

logic functions

Course Description:
Excel expert David Ringstrom, CPA, begins this comprehensive on-demand webcast with a brief discussion of the IF function and then goes beyond the basics. He explains what can go awry with the IF function and ways to improve the integrity of your decision-making formulas. David shares alternatives to the IF function, including IFNA, MINIFS, SUMPRODUCT, and others. David’s assertion is that if you’re nesting more than a couple of IF functions, there’s probably a more refined and resilient approach you can take.

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 covered:

  • Learning about the MAXIFS function available in certain versions of Excel 2016.
  • Understanding when you might wish to use ISERROR or ISNA instead of IFERROR.
  • Auditing portions of a formula by using the F9 key to temporarily convert part of a formula to a value.
  • Streamlining the decision-making process with the IFS function in Office 365.
  • Testing for two or more conditions at once with Excel’s AND function.
  • Employing the SUBSTITUTE function as an alternative to complex formulas based on the IF function.
  • Comparing the MIN, SMALL, MAX, and LARGE functions.
  • Using the COUNTIF function to determine the number of times an item appears in a list.
  • Discovering the capabilities of the SUMPRODUCT function for calculating payroll and other amounts.
  • Employing the IFERROR function for situations where VLOOKUP returns #N/A.
  • Reconstructing spreadsheet data to use VLOOKUP as a better alternative to nesting IF functions.
  • Mastering the IFERROR function to display alternate values in lieu of a # sign error.

Delivery Method: Online QAS Self Study.

Level: Intermediate.

Version: David teaches from Excel 2010 in this presentation but every aspect of the material applies equally to Excel 2007, 2013, and 2016.

Prerequisites: A familiarity with Excel.

Advanced Preparation: None

AuthorDavid Ringstrom,CPA

Publication: October, 2018

Format:  On-demand webcast. Powerpoint handout covering video is included as well.
Run-Time: 1 hr; 45 minutes

Passing Grade: 70%

Exam Policies: Exam may be retaken. Course must be completed within one year of purchase.

CPE Sponsor Info : NASBA/QAS #109234. Click here to view specific state approvals.

By the end of the course participants should be able to:

• Recall the maximum number of criteria pairs that the SUMIFS function permits.
• Identify the function that can multiply cells together and provide a sum of the result.
• Name what the SUMIFS function returns if a match cannot be found.

 

 

Course Description:
Excel expert David Ringstrom, CPA, begins this comprehensive on-demand webcast with a brief discussion of the IF function and then goes beyond the basics. He explains what can go awry with the IF function and ways to improve the integrity of your decision-making formulas. David shares alternatives to the IF function, including IFNA, MINIFS, SUMPRODUCT, and others. David’s assertion is that if you’re nesting more than a couple of IF functions, there’s probably a more refined and resilient approach you can take.

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 covered:

  • Learning about the MAXIFS function available in certain versions of Excel 2016.
  • Understanding when you might wish to use ISERROR or ISNA instead of IFERROR.
  • Auditing portions of a formula by using the F9 key to temporarily convert part of a formula to a value.
  • Streamlining the decision-making process with the IFS function in Office 365.
  • Testing for two or more conditions at once with Excel’s AND function.
  • Employing the SUBSTITUTE function as an alternative to complex formulas based on the IF function.
  • Comparing the MIN, SMALL, MAX, and LARGE functions.
  • Using the COUNTIF function to determine the number of times an item appears in a list.
  • Discovering the capabilities of the SUMPRODUCT function for calculating payroll and other amounts.
  • Employing the IFERROR function for situations where VLOOKUP returns #N/A.
  • Reconstructing spreadsheet data to use VLOOKUP as a better alternative to nesting IF functions.
  • Mastering the IFERROR function to display alternate values in lieu of a # sign error.

Delivery Method: Online QAS Self Study.

Level: Intermediate.

Version: David teaches from Excel 2010 in this presentation but every aspect of the material applies equally to Excel 2007, 2013, and 2016.

Prerequisites: A familiarity with Excel.

Advanced Preparation: None

AuthorDavid Ringstrom,CPA

Publication: October, 2018

Format:  On-demand webcast. Powerpoint handout covering video is included as well.
Run-Time: 1 hr; 45 minutes

Passing Grade: 70%

Exam Policies: Exam may be retaken. Course must be completed within one year of purchase.

CPE Sponsor Info : NASBA/QAS #109234. Click here to view specific state approvals.

By the end of the course participants should be able to:

• Recall the maximum number of criteria pairs that the SUMIFS function permits.
• Identify the function that can multiply cells together and provide a sum of the result.
• Name what the SUMIFS function returns if a match cannot be found.

 

 

  • Your website was easy to navigate and informative.” “This was my first use of your resources but I’m sure it won’t be my last. Thank you for your excellent course material and succinctly stated instructions which expedited order and payment of course selection, completion of exam, and immediate availability of Certificate of Completion. A great experience. Thanks.

    - Draper

  • “It is rare that i can actually say that I enjoyed a CPE course but I found this one informative and very interesting, relying more on the author’s examples and not just quoting tax code!  [Healthcare Reform: The affordable Care Act Tax Provisions]

    - Thomas

  • “Thank you for a high quality CPE resource. As a CPA in a small nonprofit, I find your library quite helpful to meet my needs. I appreciate the service.”- 

    - Cheryl