How To Install Kutools In Excel

Download Article

Download Article

This wikiHow teaches yous how to create a currency conversion reckoner using Microsoft Excel. If you lot just want to convert one currency value to another currency's value, you can use Excel's multiplication formula to apply the conversion rate to existing data, which is a uncomplicated procedure. If yous're using a Windows estimator, you lot tin also install the Kutools plugin to convert big numbers of currency values with up-to-engagement conversion rates; this process is more advanced, but it is also more than accurate.

1. 1

   Expect upwards your current conversion rate. Open a web browser and type currency converter into the address bar, then select the currencies you want to compare in the drop-downwards boxes at the height of the search engine'south results. This will give you the current conversion charge per unit.

   • For example, if you lot wanted to see the conversion rate for euros to U.s. dollars, y'all would select Euros for the top box and Dollars for the bottom box.

2. 2

   Open up Microsoft Excel. It's a greenish app with a white "X" on it.

   Advertisement

3. 3

   Click Blank workbook . You'll discover this option in the upper-left side of the window.

   • On Mac, click the New tab then click Bare Workbook.

4. 4

   Create a chart with your currency conversion information. To do so:

   • Blazon the offset currency'southward name into A1 (east.one thousand., "Dollars").
   • Type the get-go currency'south value into B1. This value should be "i".
   • Blazon the second currency's name into A2 (due east.g., "Euros").
   • Blazon the conversion charge per unit into B2.

5. 5

   Type your starting currency's name into D1. For example, if you're converting dollars to euros, y'all would type "Dollars" into the D1 jail cell.

6. 6

   Type the currency values y'all wish to convert into the "D" column. For instance, if you lot accept ten dollar amounts that yous desire to convert to euros, you would enter each dollar value in a cell from D2 through D11.

7. 7

   Type the conversion currency's name into E1. To use the previous example, you might type "Euros" hither.

8. 8

   Click E2, then type in =$B$ii*D2 and press ↵ Enter . This will display the converted equivalent of your starting currency in cell E2, which is directly to the right of the starting currency equivalent.

9. 9

   Utilize the formula to the residue of the 2nd currency'southward cavalcade. Click E2 once again to select information technology, so double-click the little light-green foursquare that appears in the bottom-right corner of the E2 prison cell. Your second currency'southward cavalcade will fill up up with conversions of the currency values from the starting currency cavalcade.

   Advertisement

1. 1

2. two

   Click Free Download Now . Information technology'south a link in the center of the page. Doing and so will download Kutools to your computer, though you may need to click Salvage or choose a download location depending on your browser.

3. 3

   Double-click the Kutools setup file. It resembles a brown box.

4. 4

   Select a linguistic communication, then click OK . Click the driblet-down box to pick a language.

5. 5

   Follow the on-screen prompts. To end installing Kutools:

   • Click Next.
   • Click the "Accept" box and click Side by side.
   • Click Next twice.
   • Click Install.

6. 6

   Open Microsoft Excel. It'south a greenish app with a white "X" on it.

7. 7

   Click Bare workbook . Yous'll find this option in the upper-left side of the window.

8. eight

   Enter your starting currency values in the "A" column. For example, if you have 20 dollar values you desire to catechumen, y'all'll place each individual value in cells A1 through A20.

9. ix

   Select the starting currency data. Click the A1 cell and drag all the way down to the last full cell.

10. 10

    Copy the data. Click the Dwelling tab, then click Copy in the "Clipboard" section on the left side of the toolbar.

11. 11

    Paste the data into the "B" column. Click the B1 cell, then click the Paste push button. This button resembles a clipboard in the far-left side of the Home toolbar.

    • Brand sure yous click the clipboard icon and not the arrow below it.

12. 12

    Select the information in the "B" column. Simply click the B column header to select all cells in the "B" column.

13. 13

    Click the Kutools tab. This is near the height of the Excel window.

14. fourteen

    Click Currency Conversion . It's in the "Ranges & Content" group of options in the toolbar at the elevation of the folio.

15. 15

    Click Update rate . It'due south a push button in the upper-left side of the Currency Conversion page. This will ensure that your currency rate is as accurate as possible.

    • You volition need to take an Net connexion for this to work.

16. sixteen

    Select your data'south current currency. Do and so in the window on the left side of the Currency Conversion page.

    • For example, if you're converting from dollars to euros, you would select Dollars here.

17. 17

    Select the currency yous want to convert your information to. Practise this in the window on the right side of the Currency Conversion page.

    • For example, if you're converting from dollars to euros, you would select Euros here.

18. 18

    Click OK . This will convert the values in the "B" column to the currency you chose to catechumen to.

    • Kutools isn't gratis to utilize forever. If y'all want to continue to utilize Kutools, you'll accept to purchase it from the Extended Office store.

    Advertisement

Ask a Question

200 characters left

Include your email address to go a message when this question is answered.

Submit

Advertisement

• Currency charge per unit changes all the fourth dimension, and so brand sure y'all confirm the current currency rates earlier assembling a transmission estimator.

Advertisement

• Failing to update your currency converter's conversion values will issue in inaccurate data.

Advertisement

Nearly This Article

Article Summary X

1. Install KuTools for Excel.
2. Open a bare workbook in Excel.
3. Enter the values to convert in column A.
4. Copy the data into cavalcade B.
5. Select the information in cavalcade B.
6. Click KuTools and select Currency Conversion.
vii. Click Update rate.
eight. Select your currencies and click Ok.

Did this summary help you?

Thanks to all authors for creating a page that has been read 672,315 times.

Is this article upward to engagement?

Source: https://www.wikihow.com/Create-a-Currency-Converter-With-Microsoft-Excel

Posted by: adamstright.blogspot.com

Share this post