Grouping Items in an Other Category

If you're modifying a list of items and wanted to categorize them in a few category names and have everything else in some general Other bucket it's fairly easy to do with the SWITCH function. Better to do this than using nested IF functions, which can get pretty long. Check out the video to see how it works.

Lookup Two Tables to Bring Back Matches in Both

This video will cover the INNER JOIN merge capability in Excel Power Query. This type of join returns records from two reference tables that have matching values in both tables. We are basically looking for matching records from two tables and only those records that have a common field ( or key) are brought back in a results table. In INNER JOIN comes from SQL and it's among the different join types available. It's nice that it comes with Power Query so you don't need a fancy database like Oracle, SQL Server or MySQL.

Use the MAXIFS and MINIFS Functions

If you've got Excel 2016, you've got the MINIFS and MAXIFS functions. They let you find the minimum (lowest) and maximum (highest) values based on one or more conditions (criteria). The criteria can be numeric or text and this video will show you how.