|
Do you know how to use the Excel Logical functions such as IF, AND and OR? They are super useful if you need to calculate some values based on some logical criteria.The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. But, many excel users are often unaware of other functions that can be used to improve the integrity of decision-making formulas. In this 120 minutes 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. Participants will also be provided with an Excel workbook that includes most of the examples he uses during the webcast.
Key Learning Objectives
- 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
|
|
|
|
|
|
|
|
David H. Ringstrom
David 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.
|
|
View More
|
|
|
|
|
