Traveling with Excel

With the Internet and ever-expanding jet travel, it is axiomatic to say that we are in an “Ever-Shrinking World”. National Currencies have frequent fluctuations, of course, and our friend Excel Can Help!

So, let’s say you have scheduled a business/pleasure trip to Japan, 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. It Couldn’t Be Easier!

If You are Using Excel 2007 or Excel 2010:

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

If You are Using the Older (but still serviceable) 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

Presto! In a few seconds, you will have the exchange rates for Australian Dollars to Venezuelan Bolivars!

Okay, You World Traveler, You – Is that Cool or What? I see that today you can get 78 Japanese Yens for one US Dollar (sounds like a bargain to me…)!