Delving into Excel Logical Functions: IF, AND, OR, and Beyond

Duration: 120 Minutes
Many Excel users rely on the IF function to perform logical tests of formulas, but they're often unaware of other functions that can be used to improve the integrity of decision-making formulas. In this comprehensive presentation, Excel expert David Ringstrom, CPA, introduces the IF function and then goes beyond the basics. You'll learn what can go awry with IF as well as alternatives to the function. David's contention is that if you find yourself nesting more than a couple of IF functions, there's probably a simpler and more resilient approach you can take.
Excel Logic Formulas and Functions
Instructor: David H. Ringstrom
Product ID: 504841
David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He draws your attention to 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.

Objectives of the Presentation
  • Improve the integrity of decision-making formulas in Excel spreadsheets
  • Learn alternatives to the IF function
  • Understand the pros, cons, and limitations of nesting IF functions
  • Recall how to avoid complex IF statements
  • Apply the COUNTIF function to determine the number of times an item appears on a list
  • Define when to use the IFERROR function or the IFNA function vs. the IFERROR function
Why Should you Attend
Learn about Excel logic formulas and functions.

Areas Covered
  • Using the COUNTIF function to determine the number of times an item appears on a list
  • Seeing the pros and cons of using the F9 key within Excel's formula bar to evaluate a portion of a formula
  • Moving through formulas in slow motion with the Evaluate Formula feature
  • Discovering the range of IF functions that can be used within IF statements to test for various conditions within a worksheet
  • Returning the inverse of a TRUE/FALSE test by way of Excel's NOT function
  • Testing for two or more alternate conditions by way of the OR function
  • Comparing two cells directly to return TRUE or FALSE if they're both exactly the same or not without using IF
  • Discovering the capabilities of the SUMPRODUCT function
  • Viewing the pros, cons, and limitations of nesting IF functions
  • Avoiding the complexity of nested IF statements with Excel's CHOOSE function
  • Transforming SUM, MIN, and MAX into multi-criteria array formulas
  • Testing for two or more conditions at once with Excel's AND function
Who will Benefit
  • Accountants
  • CPAs
  • CFOs
  • Financial consultants
  • Controllers
$300
Recorded Session for one participant
Get life time access with download option!
Book this course
Pay Now
  $450.00 Training CD
Free shipment within 4 Working Days of placing the order. Get life time access for unlimited participants.
  $550.00 Flash Drive
Free shipment within 4 Working Days of placing the order. Get life time access for unlimited participants.
For multiple location please contact our customer care team +1-510-857-5896.
How it works
Live Session - How it works
  • Login to onlinecompliancepanel with your registered username and password https://www.onlinecompliancepanel.com/login
  • The webinar joining link, username and password for joining the webinar will be updated on your OCP Account 24 hours prior to the webinar
  • Presentation handouts in Downloadable PDF format will be updated on your OCP Account 24 hours prior to the live session
  • Login to the audio conference on the scheduled date and time
  • Get answers to your queries through interactive Q&A sessions via chat at the end of the session
  • Download the Certificate of Attendance and Purchase Invoice from your OCP Account 24 hours after the completion of the session
  • Please let us know your thoughts and views at the end of the webinar, your valuable feedback will help us improve
Recorded Session - How it works
  • Login to onlinecompliancepanel with your registered username and password https://www.onlinecompliancepanel.com/login
  • Upon purchase of the recorded session a link will be updated on your OCP Account within 24 hours
  • Please click on the link to access the Recorded Session
  • Presentation handouts in downloadable PDF format will be updated on your OCP Account within 24 hours of the purchase of the product
  • Download the Certificate of Attendance and Purchase Invoice from your OCP Account after 48 hours of the product Purchase
  • Please share your valuable Feedback at the end of the session
Instructor Profile:
David H. Ringstrom is a CPA and owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet consulting firm that he started in 1991. David speaks at conferences and presents dozens of webinars annually on Excel and other topics. He has written numerous articles on spreadsheets, some of which have been published internationally. He has served as the technical editor for other 30 books on accounting software, and is the Tech Editor-at-Large for Accounting WEB and Going Concern. David offers Excel training and consulting services nationwide.
View More