Working With Lists in Excel 2016: Query Data With Database Functions

Microsoft Office Excel 2016: Part 2 (Intermediate) - Similar to advanced filters, you can use database functions. These functions allow you to find the data you are looking for and perform calculations all in one step.