From the author of the best-selling Excel blog on Kindle, this weekly edition covers all things that are cool in Advanced Excel. Topics cover a wide range of intermediate and advanced subjects for skilled users and experts. If you are an Excel Guru or Guru-wannabee, this is the blog for you!
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…)!
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment