Excel Basics - SUMIFS, COUNTIFS, AVERAGEIFS Functions Calculations With One or More Criteria

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

Learn advanced Excel functions for conditional calculations in this comprehensive 35-minute video tutorial. Master SUMIFS, COUNTIFS, and AVERAGEIFS functions to perform complex data analysis with multiple criteria. Explore real-world examples, including analyzing class grades, calculating sales figures, and evaluating assembly line performance. Discover how to leverage Excel tables for automated calculations and gain insights into the new MAXIFS and MINIFS functions in Office 365 Excel 2016. Perfect for business professionals and students looking to enhance their Excel skills for data-driven decision making.

Syllabus

) Introduction.
) Review of SUMIFS and COUNTIFS examples we hjave already done in this class..
) What is an AND Logical Test.
) Example 1. Goal: Count How Many BUSN Classes You Had With a Grade of 3 or Higher. COUNTIFS Example..
) Excel and Access are NOT Case Sensitive.
) Example 2. Goal: Add Total Credits for BUSN Classes in the Year 2017. SUMIFS Example..
) Example 3. Goal: Average Grades for BUSN Classes in the Year 2017. AVERAGEIFS Example..
) Example 4. Goal: Add Total COGS for Quad Product in the Year 2017. SUMIFS Example..
) Example 5. Goal: Add Total Sales for each Product in the Year 2017. SUMIFS Example with Relative and Absolute Cell References. .
) Example 6. Goal: Count number of Sales Great Than 2000 for each product in the year 2017. COUNTIFS function with 3 Criteria..
) Example 7. Goal: Add Sales for each Product automatically with the SUMIFS function and the Excel Table feature..
) Example 8. Goal: Count how many times an Assembly Line Post fell below the required Less Than 10 second assembly time. COUNTIFS Function..
) Example 9-10. Goal: Find Min Time for Each Assembly Line Post. See the New MAXIFS and MINIFS Functions in Office 365 Excel 2016..
) Summary - Conclusion.