Completed
1. Introduction
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