In this presentation author and Excel expert David Ringstrom, CPA shares several worksheet functions with you that will enable you to sum data in a variety of ways. Techniques include maximizing the statistics that appear on Excel’s Status Bar, using the AutoSum feature, and future-proofing the SUM function. David will also compare the SUBTOTAL function with the Subtotal feature, contrast SUMIF and SUMIFS, demonstrate SUMPRODUCT, and much more.
Learning Objectives:
• Identify how to improve the integrity of SUM-based formulas in Excel.
• State what SUMIF returns if a match cannot be found.
• Recall the maximum number of criteria pairs that the SUMIFS function permits.
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/