Hello! in this post I will show you how to add real time currency converter of US Dollar to Indian Rupees (USD to INR) in MS Excel sheet, we can manual insert currencies in excel sheet, but the main problem is how to get real time update of currency rate changes, this method will work all the version of MS Excel from 2003 to 2016.. lets see how to do this.
1. Open google in the desktop search for “x-rates” open the first link select the US Dollar (USD) and Indian Rupees (INR) and click on “Rates table”
2. Now come to Excel 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. The Dollar and Indian currency will display in sheet (please watch below video for more detail.. )
Watch Video tutorial… Please like, share & subscribe