How to do Real Time Currency Conversion in Excel

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=j_bMat4ZSts

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... • 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

#############################

New on site