Главная
Study mode:
on
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
Description:
Dive into an extensive video tutorial on logical tests in Excel, covering a wide range of topics from basic concepts to advanced techniques. Learn how to use Excel formulas, conditional formatting, PivotTables, and Power Query to perform various logical operations. Explore single condition, AND, OR, and complex logical tests, as well as their applications in functions like COUNTIFS, SUMIFS, and FILTER. Discover how to implement logical tests in cross-tabulated reports, quality control processes, and financial analyses. Practice with real-world examples, including creating monthly sales reports, assessing credit worthiness, and extracting data from CSV files. Gain hands-on experience with downloadable Excel files and supplementary materials, and conclude with challenging homework problems to reinforce your newly acquired skills.

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

ExcelIsFun
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Business Intelligence #Power Query #Data Science #Data Analysis #Spreadsheets #PivotTables #AVERAGEIFS #COUNTIFS
0:00 / 0:00
1 of 34

1. Introduction