Filter by Parameter and Dynamic Drop-Downs with Power Query | Everyday Office

Power Query is Excel's new ETL (Extract, Transform, and Load) tool. It's used to pull data in from many different sources, then 'transform' the data in any ways necessary before 'loading' it into your spreadsheet. As you're transforming the data, you may want to provide Power Query some variable information - this can be a 'parameter.' In this exercise, we create a dynamic drop-down menu from the data, then use the user-selected option as a parameter to filter the data. With a simple macro to refresh the data, you now have an easy-to-filter subset of the larger dataset you're bringing in.
Everyday Office is the media arm of Knack Training, a software and professional development training and consulting company headquartered in Orlando, FL. More content can be found on:
www.knacktraini...
www.knacktraini...
Check the playlists on the Everyday Office channel for more tutorials in the areas you are having the most trouble with.