Real-Time Currency Converter in Excel | Multiple Currencies | Web Query & Currency Data Type Methods
Автор: Chester Tugwell
Загружено: 2021-10-28
Просмотров: 82812
👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺.
https://www.paypal.com/donate/?hosted...
Thank you! 👍👍
Download the featured file here: https://www.bluepecantraining.com/rea...
Use this URL to load exchange rates: https://www.x-rates.com/table/?from=G...
In this video I demonstrate two methods for creating a currency converter in Excel; both methods are real-time meaning the exchange rate will automatically remain up-to-date.
The first method will work for you if you have Excel 365 which includes data types. The currency data type allows you to load currency exchange rates that automatically update every five minutes.
The second method uses Power Query to load a table of exchange rates from a web page. This method allows you to set your own refresh frequency.
Table of Contents:
00:00 - Intro
00:25 - Excel 365 Method Using Data Types
04:52 - Using Power Query (Old Excel)
------------------------
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
