Conditional Calculations with Excel Formulas - Comprehensive Lessons

Conditional Calculations with Excel Formulas - Comprehensive Lessons

ExcelIsFun via YouTube Direct link

) IF Function & IS functions. Bank Checkbook Example.

19 of 21

19 of 21

) IF Function & IS functions. Bank Checkbook Example.

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.