Get Amazon Seller Reports data into Excel via MWS API, using VBA or Power Query

How can I get Amazon Seller Reports data into Excel by making use of MWS API, using either VBA, or PowerQuery, or both?

Basically, I want to achieve the same functionality that is demonstrated at MWS Scratchpad:

http://ift.tt/QkPOLf