The videos below demonstrate this shortcut.

Video thumbnail for FILTER function with two criteria

Video thumbnail for How to use the COUNT function

Video thumbnail for How to sort an Excel Table

Video thumbnail for How to troubleshoot VLOOKUP approximate match

Video thumbnail for How to use absolute references - example 1

Video thumbnail for How to calculate the number of days between dates