Description
In this presentation, author and Excel expert David H. Ringstrom, CPA, will guide participants through a comprehensive exploration of beginning to advanced logic functions and related formulas. Topics covered include the IF and IFS functions, as well as nested IF functions. You’ll see how to troubleshoot formulas with the Evaluate Formula feature. David will compare the IFERROR and IFNA functions so that you know the best practices for each. Other functions covered include IS functions, AND, OR, SUMIF, SUMIFS, COUNTIF, COUNTIFS, MIN, MAX, SMALL, LARGE, and MAXIFS. Attendees will gain valuable insights and practical knowledge to enhance their Excel skills and improve efficiency in their day-to-day tasks.
Learning Objectives:
• Identify the menu that contains the Evaluate Formula command.
• State how many levels of IF functions you can nest.
• Recall the purpose of the AND worksheet function.
To complete this course participants need to: View the video and complete an assessment exam with a minimum passing grade of 70% or higher.
Upon course completion a course evaluation form is provided for your feedback.
You have 1 year from the time of purchase/enrollment to complete the course.
Our Refund Policy can be found at: https://cpeprime.com/cancellation-and-refund/