Tuesday, October 25, 2011

Use Excel for Exchange Rates of Currency



So, you are getting ready for that trip to Europe, (or wherever in the world you are going), and you would like to download the most up-to-date currency exchange rates directly into the Excel workbook you are using for your trip planning. Piece of Cake!

Here is what you do in Excel 2003:
1) Select cell A1
2) Go to Data / Import External Data / Import Data and choose MSN MoneyCentral Investor Currency Rates
3) Click OK

Bamm! In a few seconds, you will have the exchange rates from countries feom Argentina  to Venezuela!

If you are using Excel 2007 or 2010:

1) Select cell A1
2) Go to Data / Get External Data / Existing Connections and choose MSN MoneyCentral Investor Currency Rates
3) Click OK

Does that Rock or What? I see that today you can get 1,883 Columbian Pesos for one US Dollar today(sounds like a bargain to me…)!

No comments:

Post a Comment