Completed
31. Complex Logical Tests to assess Custom Credit Worthiness in an Accounts Receivable Department. See AND and OR functions, Spilled Boolean Math Formula, IF function and FILTER function
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Logical Tests - Excel Formulas, Conditional Formatting, PivotTables, Power Query, and More
Automatically move to the next video in the Classroom when playback concludes
- 1 1. Introduction
- 2 2. What is a Logical Test in Excel?
- 3 3. Examples of six most common types of logical tests with Filter Feature and PivotTable
- 4 4. Examples of Single Condition, Contains and NOT Logical Tests
- 5 5. Description of AND Logical Test and OR Logical Test
- 6 6. Description of a Complex Logical Test
- 7 7. Comparative Operators
- 8 8. Comparative Operators Examples
- 9 9. IS functions
- 10 10. Boolean Values
- 11 11. 22:34 Single Condition Logical Tests: 1 PivotTable, 2 Worksheet Formulas, and 3 Power Query Grouping feature in Power Query at
- 12 12. AND Logical Tests: AND function, Spilled Array and FILTER function
- 13 13. Boolean Math Operators and Math Operators: AND = Multiplication, OR = Addition
- 14 14. AND Logical Test in FILTER function
- 15 15. AND Logical Tests using Any Non-Zero Number as TRUE
- 16 16. COUNTIFS, SUMIFS, AVERAGEIFS, MINIFS, MAXIFS with an AND Logical Test.
- 17 17. Mixed Cell Reference For Conditionally Formatting a Row.
- 18 18. AND Logical Tests in Cross Tabulated Reports, Worksheet Formulas and PivotTable
- 19 19. AND Logical Tests in Quality Control using COUNTIFS function
- 20 20. Between Logical Test to create Monthly Sales Report and Frequency Distribution
- 21 21. OR Logical Tests on One Column and Two Columns: OR function, Spilled Formula, Average formula and FILTER function
- 22 22. XMATCH function to run an OR Logical test and a Compare Lists Logical Test. Spilled Array, FILTER function.
- 23 23. Adding with an OR Logical Test using SUMIFS inside SUM function
- 24 24. Conditional formatting a Row with an OR Logical Test
- 25 25. NOT Logical Test in Spilled Array and COUNTIFS function
- 26 26. Contains Logical Test in Spilled Array and COUNTIFS function
- 27 27. IF Function
- 28 28. IF and IS functions to create checkbook ledger
- 29 29. IFS function to create label in an Income Statement Report
- 30 30. Power Query with Complex Logical Test to extract records from a csv file
- 31 31. Complex Logical Tests to assess Custom Credit Worthiness in an Accounts Receivable Department. See AND and OR functions, Spilled Boolean Math Formula, IF function and FILTER function
- 32 32. 9 Amazing Homework Problems
- 33 33. Summary and Conclusions
- 34 34. Closing and Video Links