Conditional Calculations with Excel Formulas - Comprehensive Lessons

Conditional Calculations with Excel Formulas - Comprehensive Lessons

ExcelIsFun via YouTube Direct link

) Count Sales Between Upper and Lower Limit (Frequency Table) with COUNTIFS (Alos consider how this method is different from FREQUENCY Array Function).

9 of 21

9 of 21

) Count Sales Between Upper and Lower Limit (Frequency Table) with COUNTIFS (Alos consider how this method is different from FREQUENCY Array Function).

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Conditional Calculations with Excel Formulas - Comprehensive Lessons

Automatically move to the next video in the Classroom when playback concludes

  1. 1 ) Introduction
  2. 2 ) AND Logical Test (AND Criteria)
  3. 3 ) AND Function
  4. 4 ) SUMIFS, COUNTIFS, AVERAGEIFS functions with AND Criteria
  5. 5 ) Create Names From Selection
  6. 6 ) Cross Tabulated Table for adding with 3 criteria: SUMIFS and Mixed Cell References.
  7. 7 ) Between Logical Tests, Create Monthly Sales Report with SUMIFS.
  8. 8 ) Create Monthly Sales Report with SUMIFS and EOMONTH functions.
  9. 9 ) Count Sales Between Upper and Lower Limit (Frequency Table) with COUNTIFS (Alos consider how this method is different from FREQUENCY Array Function).
  10. 10 ) D Functions (Database functions) with AND Criteria
  11. 11 ) Array Formulas with AND Criteria. Use Two IF Functions. See how to calculate Standard Deviation with two conditions or criteria.
  12. 12 ) OR Logical Test (OR Criteria)
  13. 13 ) Defined Names and Scope in an Excel Workbook
  14. 14 ) OR Function
  15. 15 ) OR Criteria looking at one column using SUMIFS and SUMPRODUCT for adding and COUNTIFS and SUMPRODUCT for counting. Function Argument Array Operations.
  16. 16 ) Average calculation with OR Criteria: AVERAGE & Array Formula (for 1 or more columns)
  17. 17 ) D Functions (Database functions) with OR Criteria
  18. 18 ) AND and OR and IF Functions for Credit Analysis for Accounts Receivable Department
  19. 19 ) IF Function & IS functions. Bank Checkbook Example.
  20. 20 ) Conditional Calculations: PivotTable or Formulas?
  21. 21 ) Summary

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.