How to Make a Currency Converter with Microsoft Excel

Video: How to Make a Currency Converter with Microsoft Excel

Video: How to install adobe reader on windows 7 | Download adobe acrobat reader| adobe reader win 7 32 bit 2024, May

2024 Author: Jason Gerald | [email protected]. Last modified: 2024-01-19 22:11

This wikiHow teaches you how to create a currency converter with Microsoft Excel. If you only want to convert one currency to another, you can use Excel's simple multiplication formula. However, if you are using Windows, you can install the Kutools add-on for Microsoft Excel. This add-on allows you to convert currencies at the latest exchange rates automatically. Although the process is more complicated, Kutools conversion results will be more accurate than manual conversion results.

Step

Method 1 of 2: Performing Manual Conversion

Step 1. Use a search engine to find out the current exchange rate

Enter the keyword currency converter in the address bar or search bar of your browser, then select the currency you want to compare in the box at the top of the search results. The current exchange rate will appear on the screen.

For example, if you want to compare the rupiah to the US dollar, select Dollars in the box at the top of the search results, and Indonesian Rupiah in the box below.

Create a Currency Converter With Microsoft Excel Step 2

Step 2. Click the green icon with a white X to open Microsoft Excel

Create a Currency Converter With Microsoft Excel Step 3

Step 3. Click the Blank workbook option in the upper left corner of the Excel window

If you are using a Mac, click New > Blank Workbook

Create a Currency Converter With Microsoft Excel Step 4

Step 4. Create an exchange rate conversion table by following these steps:

Enter the name of the first currency in the field A1 (for example USD).
Enter the first currency value in the column B1. The value of this first currency is "1".
Enter the name of the second currency in the field A2 (for example Rupiah).
Enter the rate in the column B2.

Create a Currency Converter With Microsoft Excel Step 5

Step 5. Enter the name of the home currency in column D1

For example, if you want to convert US dollars to Indonesian rupiah, enter USD on column D1.

Create a Currency Converter With Microsoft Excel Step 6

Step 6. Enter the currency value in column D

For example, if you want to convert 10 dollar values to rupiah, enter each value on the line D2 until D11.

Create a Currency Converter With Microsoft Excel Step 7

Step 7. Enter the name of the destination currency in column E1

For example, if you want to convert US dollars to Indonesian rupiah, enter IDR on column E1.

Create a Currency Converter With Microsoft Excel Step 8

Step 8. Click column E2, then enter the formula


=$B$2*D2

and press Enter.

After entering the formula, you will see the conversion result in the column E2, right next to the original currency value.

Create a Currency Converter With Microsoft Excel Step 9

Step 9. Apply the formula to the entire second currency column

Click cell E2, then double-click on the small green square in the lower-right corner of the cell. Excel will convert the currency according to the conversion value you entered, and the result of the conversion will appear in the second currency column.

Method 2 of 2: Using Kutools for Excel

Create a Currency Converter With Microsoft Excel Step 10

Step 1. Visit the Kutools download page at

Kutools is only available for Windows computers.

Create a Currency Converter With Microsoft Excel Step 11

Step 2. Click the Free Download Now link in the middle of the page, then click the button Save or select a download location if prompted.

Kutools will be downloaded to your computer.

Create a Currency Converter With Microsoft Excel Step 12

Step 3. Double click the brown box icon to start the Kutools installation process

Create a Currency Converter With Microsoft Excel Step 13

Step 4. Click the box in the installation window to select a language, then click OK

Create a Currency Converter With Microsoft Excel Step 14

Step 5. Follow these steps to complete the Kutools installation process:

Click Next.
Click Accept twice, then click Next.
Click Next twice.
Click Install.

Create a Currency Converter With Microsoft Excel Step 15

Step 6. Click the green icon with a white X to open Microsoft Excel

Create a Currency Converter With Microsoft Excel Step 16

Step 7. Click the Blank workbook option in the upper left corner of the Excel window

Create a Currency Converter With Microsoft Excel Step 17

Step 8. Enter the initial currency value in column A

For example, if you have 20 dollar values that you want to enter, enter each value into the cell A1 until A20.

Create a Currency Converter With Microsoft Excel Step 18

Step 9. Select all cells containing currency values by clicking on the first cell and dragging the cursor to the last cell

Create a Currency Converter With Microsoft Excel Step 19

Step 10. Copy the data

Click the Home tab, then select Copy in the Clipboard section on the left of the toolbar to copy the data.

Create a Currency Converter With Microsoft Excel Step 20

Step 11. Paste the data into column B

Select cell B1, then click the clipboard-shaped Paste button in the left corner of the toolbar Home.

Make sure you click the clipboard icon, instead of the arrow below it

Create a Currency Converter With Microsoft Excel Step 21

Step 12. Select the data in column B

Just click the column head B to select all the data in it.

Create a Currency Converter With Microsoft Excel Step 22

Step 13. Click the Kutools tab near the top of the Excel window

Create a Currency Converter With Microsoft Excel Step 23

Step 14. Click the Currency Conversion button in the Ranges & Content option

It's in the toolbar at the top of the page.

Create a Currency Converter With Microsoft Excel Step 24

Step 15. Click the Update rate button in the top left corner of the page Currency Conversion to update exchange rate data.

Make sure your computer is connected to the internet before performing this step

Create a Currency Converter With Microsoft Excel Step 25

Step 16. Select the source currency in the window on the left of the Currency Conversion page

For example, if you want to convert dollars to rupiah, choose Dollars.

Create a Currency Converter With Microsoft Excel Step 26

Step 17. Select the destination currency in the window to the right of the Currency Conversion page

For example, if you want to convert dollars to rupiah, choose Rupiah.

Create a Currency Converter With Microsoft Excel Step 27

Step 18. Click OK

Excel will convert the currency values in the column B to the value of your destination currency.

You can try Kutools for free. However, to continue using Kutools, you will have to purchase a license in the Extended Office store

Tips

Currency rates may change at any time. Make sure you confirm the rate before doing manual calculations

3 Ways to Replace the Catalyst Converter

The Catalyst Converter, which is responsible for recirculating unburned gas back into the engine and cleaning car exhausts, is the key to emission control in your car. If damaged, the car will cause more pollution, and reduce fuel efficiency.

How to Make a Business Card with Microsoft Word (with Pictures)

Want to create business cards quickly, but don't have expensive design software? Microsoft Word provides the tools you need to create and print business cards. Use templates to make business cards easy, yet personal, or create business cards from scratch.

How to Make Newspaper With Microsoft Word (with Pictures)

This wikiHow teaches you how to create a newspaper using features in Microsoft Word. Once you've designed your newspaper shape, you can create it using Microsoft Word on both Windows and Mac. Step Part 1 of 2: Designing a Newspaper Step 1.

How to Connect a DTV Digital Converter Box and Antenna

As of June 12, 2009, all televisions in the US must be capable of receiving DTV digital television broadcast signals. Analog televisions that cannot receive digital DTV signals will not be able to display most television channels without the aid of a digital converter box (DTV converter box) which accepts digital signals over the air and converts them into analog signals so that television broadcasts can be shown on television.

How to make your girlfriend want to make love to you

Has your love affair lasted long enough and are you ready to take it to the next level? Some people think that sex is normal, but others think of it as something special to do with a special person. While you shouldn't be pushy, you can try to calm your boyfriend's fears and reassure him that you're someone he can fully trust.