Using API Keys in Excel

How to query an API in Excel using an API Key from the OpenWeather channel Video Content: 00:06 - Introduction to API keys + Github API catalogue 01:40 - OpenWeatherMap API 03:40 - OpenWeatherMap API Documentation 05:25 - Excel Power Query, building our parameters for the API call + using the API key 08:12 - Generating results from our API call 10:37 - Transforming the results of the API returned data 17:55 - Loading our data into a table in Excel 19:54 - Closing remarks and Conclusion 22:15 - Outro #api #apidevelopment #powerquery #apimanagement #excel #exceltutorial #exceltutorialforbeginners #exceltips