In this comprehensive presentation, Excel expert David Ringstrom, CPA, briefly discusses the IF function and then, in detail, takes you beyond the basics. He explains what can go awry with the IF function and ways to improve the integrity of decision-making formulas. David shares alternatives to the IF function, including IFS, CHOOSE, VLOOKUP, SUMIF, 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.
Who Should AttendPractitioners who would benefit by learning more about Excel error functions.
Instructional MethodGroup: Internet-based
NASBA Field of Study
Computer Software & Applications (2 hours)
Program PrerequisitesExperience with Excel Error Functions Recommended.