Once the data has been loaded, any Excel calculation or function can be performed. StrikeIron also has a licensed professional version of the service for Excel.

NOTE: This post was written before Data Explorer was renamed as Power Query. All of the content is still relevant to Power Query. Last week I showed how you could use the WebService() function in ...