Connect Power Query to a Dynamic Dropdown List

Can Excel’s Power Query (Get and Transform) be used as contents for a dropdown list in Excel? And what would be a good use for it?

That came across my mind recently and this video is the result of that inquiry. You’ll see COUNTIFS, Dropdown boxes, Fill-Down, and everything!

For an intro to Get & Transform (Power Query) try my Lynda.com course:
https://www.lynda.com/Excel-tutorials/Excel-2016-Get-Transform/608994-2.html
Website: http://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336
My old blog: http://datascopic.net/blog-2-2