In this post I will try to show you how to add real time currency converter in Microsoft Excel, not only this you can also calculate and update all currencies in excel sheet, this method will work all the version of MS Excel from 2003 to 2016.. lets see how to do this.
1. Open google in your brower type and search for “x-rates” open the first link select the currency and click on “Rates table”
2. Open MS Excel sheet click on “Data” click on “From web” copy the x-rates’s url and paste it in “Address” and click on “Go” click on arrow mark the table will be selected, now click on “Import” and “ok” wait for few seconds.
3. All selected currencies will add to excel sheet (watch below video to know how to do calculation and update currency regularly)