Have you ever wanted to incorporate data from online resources into your Excel spreadsheets, such as stock quotes, weather, Bing Search results or even Twitter feeds? With new Webservice functions, ...

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.

At the Build 2018 developer conference that's taking place these days in Seattle, USA, Microsoft announced support for custom JavaScript functions in 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 ...

The following samples show how to build the simplest Office Add-in with only a manifest, HTML web page, and a logo. They will help you understand the fundamental parts of an Office Add-in. For ...

Transform-Data-by-Example is an Excel add-in that helps you find the desired transformation function easily. All you need to do is to provide a few examples of the desired output, and ...