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