Expediting Excel: IF, AND, OR, and More Logic Functions
07 May 2019
- 01:00 PM to 02:30 PM EST
90 Minutes

David shares alternatives to the IF function, including IFNA, MINIFS, SUMPRODUCT, and others. David asserts that if you’re nesting more than a couple of IF functions, there’s probably
a more refined and resilient approach you can take.

 

Expediting Excel: IF, AND, OR, and More Logic Functions

Acclaimed Microsoft Excel expert David H. Ringstrom, CPA, is the president and owner of Accounting Advisors Inc. based in Atlanta, Georgia. David founded Accounting Advisors in 1991 as a consulting-services business, but in 2009, he began teaching for continuing education providers as well.

There is no webinar video currently available. Please check back soon.

Expediting Excel: IF, AND, OR, and More Logic Functions
Presented by David H. Ringstrom, CPA
Event Date/Time: 03/19/2019 1:00 PM Eastern
Duration: 90 minutes

Overview:

Excel expert David Ringstrom, CPA, begins his presentation with a brief discussion of the IF function and then takes you beyond the basics. David explains what can go awry with the IF
function and describes ways you can improve the integrity of your decision-making formulas. He also shares alternatives to the IF function, including IFNA, MINIFS, SUMPRODUCT, and
others. David asserts 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 the subscription-based Office 365 version of Excel. David draws your
attention to any differences in the older versions of Excel (2019, 2016, 2013, and earlier) 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. Office 365 is a subscription-based product that provides new-feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel have feature sets that don’t change. Perpetual licensed versions have year numbers, such as Excel 2019, Excel 2016, and so
on.

Who Should Attend:
Practitioners who would benefit by learning more about Excel’s logic functions and decision- making formulas.

Topics Typically Covered:
• Employing the IFERROR function for situations where VLOOKUP returns #N/A.
• Learning about the IFNA function available in Excel 2013 and later.
• Auditing portions of a formula by using the F9 key to temporarily convert part of a formula to a value.
• Employing the ISERROR function to determine if a formula returns a # sign error as the basis for triggering alternate calculations.
• Comparing two cells directly to return TRUE or FALSE if they’re exactly the same or not without using IF.
• Understanding the risks and complications of nesting too many levels of IF functions.

• Reconstructing spreadsheet data to use VLOOKUP as a better alternative to nesting IF functions.
• Streamlining the decision-making process with the IFS function in Office 365.
• Stepping through formulas in slow motion with the Evaluate Formulas feature.
• Returning the inverse of a TRUE/FALSE test by way of Excel’s NOT function.
• Incorporating comparison operators within SUMIF to sum numbers based on range criteria, such as greater than, less than, and so on.
• Employing the SUBSTITUTE function as an alternative to complex formulas based on the IF function.

Learning Objectives:
• Recall how to avoid complex IF statements.
• Apply the AND function to test for two or more conditions at once.
• Define when to use the ISERROR function or the ISNA function vs. the IFERROR function.

Level: Intermediate
Format: Live Webcast
Instructional Method: Group: Internet-Based
Program Prerequisites: Some Experience with Logic Functions

 

What You Get
• Training Materials
• Live Q&A Session with the Speaker
• Participation Certificate
• Earn 100 Loyalty points with every booking. You can redeem one live webinar with 300 loyalty points.

Who can Benefit
This session is aimed at anyone who uses Microsoft Outlook and is looking for a way to get back those precious hours!

At the Q&A session following the live event, ask a question and get a direct response from our expert speaker

Important Note
1. For Live webinar attendee, you can find webinar joining details at user dashboard. (Create an account)
2. Live webinar attendees can download the participation certificate & credit points from dashboard after approval.
3. For Web download - You can download recorded video & handouts from user dashboard after Live webinar session.

You may also like

HR Certification Institute Approved Provider

Proskilleducator.com is an HRCI Approved Provider and can assign recertification credit hours (based on HR Certification Institute standards) to HR-related continuing education events, including qualification for PHR, SPHR or GPHR recertification credits. The use of this seal is not an endorsement by HR Certification Institute of the quality of the program. It means that this program has met HR Certification Institute’s criteria to be pre-approved for recertification credit.

SHRM Approved Recertification Provider

"proskilleducator.com" is recognized by SHRM to offer Professional Development Credits (PDCs) for the SHRM-CPSM or SHRM-SCPSM.  Our program is valid for PDCs for the SHRM-CPSM or SHRM-SCPSM. For more information about certification or recertification, please visit www.shrmcertification.org