Logical Tests - Excel Formulas, Conditional Formatting, PivotTables, Power Query, and More

Logical Tests - Excel Formulas, Conditional Formatting, PivotTables, Power Query, and More

ExcelIsFun via YouTube Direct link

1. Introduction

1 of 34

1 of 34

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

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.