Excel Logic Formulas: IF, AND, OR, and More

Attend upcoming webinar and earn continuing education credits. Live Webinars   |   On-Demand   |   All-Access Plan Manage Preferences    |    View in Browser Excel Logic Formulas: IF, AND, OR, and More June   20 3 pm - 4:40 pm ET Presenter: David Ringstrom, author and nationally recognized instructor Credits: CPE (Credit Details) Can't attend live? By registering, you will be able to view the course live, view a recording at any time after the live presentation, or both. Viewing Options: View on your computer, tablet, or smartphone Learn More Register Today Course Description   While many Excel users rely on the IF function, they're often unaware of ways to improve the integrity of decision-making formulas. In this practical webinar, you will learn how to apply the IF function and its powerful alternatives such as IFS, CHOOSE, VLOOKUP, and SUMIF functions. Upon completion of this course, you will be able to: Transform SUM, MIN, and MAX into multi-criteria array formulas Define the pros, cons, and limitations of nesting IF functions Use the SUMIF function to summarize data based on a single criterion Compare IFNA, IFERROR, and ISERROR functions and learn which versions of Excel support these worksheet functions Compare the MIN, SMALL, MAX, and LARGE functions Use the SUMIFS function to sum values based on multiple criteria Use the IFERROR function to display something other than an #N/A error value when VLOOKUP can't find a match Identify the range of IS functions that can be used within IF statements to test for various conditions within a worksheet Use the COUNTIF function to determine the number of times an item appears on a list Apply the MINIFS function in Excel 2016 Use the IF function to compare two cells directly to return TRUE or FALSE values Avoid the complexity of nested IF statements with Excel's CHOOSE function Learn More Register Today About The Presenter   David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on 25 years of consulting and teaching experience. David's mantra is "Either you work Excel, or it works you," so he focuses on what he sees users don't, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively. Learn More Register Today All-Access Membership   ● Earn continuing education credit for no additional fee ● Access courses on your computer, tablet, or smartphone ● More than 75 live webinars each month ● More than 1,500 on-demand courses Learn More Upcoming Webinars Ethics for Tax Professionals June 11 at 1 pm ET Learn More TIN Solicitation Best Practices June 12 at 1 pm ET Learn More Fundamentals of Accounting and Finance for Non-Accountants June 12 at 3 pm ET Learn More Questions? Please call us at 703-372-0550 Our Mailing Address: Clear Law Institute | 4601 N. Fairfax Dr., Ste 1200 | Arlington | VA | 22203 Remove me from future emails. Manage email preferences. This email was sent to virginia.duffy.planetduffy@blogger.com. If you are receiving it in error, please reply to this email.