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 January   25 1 pm - 2:40 pm ET Presenter: David Ringstrom, CPA, author and nationally recognized Excel 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 Course Reviews: View Testimonials 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 Course Reviews from Past Attendees 100% of attendees recommend this webinar. "The slides were very helpful." "David is amazing." "Learned new ways of using functions I already use." "I enjoyed learning about the many various formulas" 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,300 on-demand courses Learn More Upcoming Webinars Creating an Effective and Efficient Travel and Entertainment Expense Reimbursement Policy January 23 at 1 pm ET Learn More Implementing Revenue Recognition – Topic 606 January 24 at 1 pm ET Learn More Quantifying Unreported Income in Litigation January 24 at 1 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.