How to Use Excel Currency Conversion

Contributor

By Anthony Smith
eHow Contributing Writer

Article Rating: (0 Ratings)

Use Excel Currency Conversion

A currency conversion spreadsheet is a feature of Microsoft Excel that allows you to compare dollars with dinars --- or any other world currency.

How to Exchange Currency
The best way to exchange money is by going to a state certified bank and doing an honest and smooth exchan… More
About Foreign Currency Exchange
The Foreign Exchange market, where foreign currency changes hands and is set at a certain value, is one of… More
How to Exchange Currency in the USA
When traveling abroad, you will need money in the currency of the country you plan to visit. In the U.S., … More
Best Currency Exchange Rates
Find the best currency exchange rates by looking at whether a country is making more money than it is spen… More
How to Compare Currency Exchange Rates
Comparing currency exchange rates requires an appreciation of the immediate and long term effects of inter… More
About Foreign Currency Trading
Foreign currency trading is investing funds into the currency from one country in the hopes that the value… More
What Determines the Foreign Exchange Rate?
To determine the foreign exchange rate for different currencies, check the local paper for exchange rates,… More
How to Convert Euros to U.S Dollars
Knowing how to convert the euro to U.S. dollars (USD) can be useful for travel or investing in currencies.… More
How to Convert Dollars to Euros in Google
In order to convert dollars to euros, go to Google's text entry area and type "ten dollars in euros" to ge… More
Dollar to Peso Conversion
Mexico's national currency is the peso. Due to Mexico's relatively weak economy, the dollar has traditiona… More
About Mexican Currency
One of the top traded currencies in the world, the Mexican Peso has a long and varied history, but in rece… More
How to Use Excel Currency Conversion
A currency conversion spreadsheet is a feature of Microsoft Excel that allows you to compare dollars with … More
How to Exchange Money in New York City
Though it is possible to get American currency from your bank before leaving your home country, you are mo… More
Why Do Exchange Rates Vary From Day to Day?
Exchange rates can vary from day to day because they are tied to the economy and the rate of inflation of … More
How to Use Google as a Currency Converter
Google is more than just a search engine. Follow these steps to use Google as a currency converter.… More

Difficulty: Moderate

Instructions

Things You'll Need:

Computer with Microsoft Excel

Step 1

Open Excel and start a new workbook. In cell A1, type in "Currency to be converted." In cell A2, type in "Amount." In cell A3, type in "Today's conversion factor." In cell A4, type "Currency converted to."
Step 2

Format all of the above cells (A1-A5) as text cells.
Step 3

In cell B7, type in "=B2*B3." In cell C7, type in "=B4."
Step 4

Open your web browser and go to the following website:
http://www.x-rates.com/d/USD/table.html
From the table on the right-hand side, click on the currency from which you want to convert.
Step 5

Scan down the table that appears and locate the currency to which you are converting, and record the conversion factor from the first column next to it.
Step 6

Return to the spreadsheet and enter the appropriate values in column B for the corresponding labels in column A. The conversion factor you recorded in step 5 goes in cell B3. Excel does the rest, and the calculated currency conversion is displayed in cells B7 and C7.