7:52
1101. VLOOKUP() for Starters
7:15
1102. VLOOKUP w. TRUE vs. FALSE
6:00
1103. VLOOKUP w. TRUE - applications
2:45
1104. HLOOKUP() vs. VLOOKUP()
3:38
1105. MATCH() - Basics
3:46
1106. MATCH() match_type -1 vs. 0 vs. 1
5:52
1107. 2-D Lookup (Vertical + Horizontal) - VLOOKUP w. MATCH
1:19
1108. 2-D Lookup - VLOOKUP w. MATCH - Framework
3:48
1109. 2-D Lookup - VLOOKUP w. MATCH - Common Mistake #1
2:20
1110. 2-D Lookup - VLOOKUP w. MATCH - Common Mistake #2
6:12
1111. 2-D Lookup - VLOOKUP w. MATCH - Practice Exercise
6:48
1112. 2-D Lookup (Horizontal + Vertical) - HLOOKUP w. MATCH
4:18
1113. INDIRECT() - Basics
1114. INDIRECT() w. Range Naming - Applications
1115. 3-D Lookup - VLOOKUP() w. MATCH() w. INDIRECT() - Question
7:10
1116. 3-D Lookup - VLOOKUP() w. MATCH() w. INDIRECT() - Answer
3:27
1117. Reverse Lookup - Question
8:13
1118. Reverse Lookup - INDEX() w. MATCH() - 1 of 2
6:06
1119. Reverse Lookup - INDEX() w. MATCH() - 2 of 2
4:27
1120. SUMIFS() Conditional Summation (1 criteria)
4:11
1121. SUMIFS() Conditional Summation (2 criteria)
5:19
1122. SUMIFS() Conditional Summation (3 criteria) w. date range
5:30
1123. SUMIFS() Condition based Selective Cumulative Running Total
6:09
1124. COUNTIFS() - SingleMultiple Criteria Duplicate Count, Instance No.
3:20
1125. COUNT() vs. COUNTA() vs. COUNTBLANK() vs. COUNTIFS()