How to do Real Time Currency Conversion in Excel
Автор: Anders Jensen
Загружено: 2020-10-14
Просмотров: 38362
This video tutorial shows, how to do real time currency conversions in Microsoft Excel with live exchange rates from the European Central Bank. You'll learn how to do a REST API call in Excel and parse the recieved JSON with Power Query.
You could also watch:
🔵 How to do progress circle charts in Excel (must watch): • How to create a Progress Circle Chart in E...
0:20 Present the Excel Currency Exchange Case
We have a column in Excel, which we want to apply live currency rates to.
0:38 Use an API
We use the an API with live currency rates from the European Central Bank. When we call the API we get the result in JSON format.
1:40 Data from an API in Excel
We use From Web and apply Power Query to it and get the data in a table. Let's update the currency rates each minute (change it in the properties).
Connect with me:
🔔 Subscribe - http://www.youtube.com/user/klogeande...
💼 LinkedIn - / andersjensens
👥 Facebook - / andersjensenorg
💌 Email Newsletter - https://andersjensen.org/email-newsle...
#microsoft #excel #powerquery
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: