Add Exchange Rate

The Office 365 version provides a great new feature; Data Type.

1. With this tool, you just have to fill in geographic data or financial data in your cells and Excel connects to a database
2. Once you are connected, you can return any information in relationship with your cell's value

For instance, if you want to have the exchange rates between 2 currencies, here are the steps

• Write in your cells Currency1/Currency2
• Go to ribbon Data > Stocks
• The / is not compulsory. you can use any separator; like space, -, | , ...

And when you see the stock icon, you are connected 😀👍

What are the details behind the link?

1. Once the icon is added to your cells
2. Put your cursor on the icon
3. Then, you visualize all the information related to the exchange rate between the 2 currencies

You can notice that many information could be returned 😯😎

Return the last Exchange rate

Now, how to return the last Exchange rate between 2 currencies?

1. Click on the little rectangle in the upper right corner of the cell
2. Select the property Price

As an alternative method, you can also write a formula

1. Start with the equal sign
2. Select the cell with the currencies
3. Add a period. This opens the list of properties
4. Double-click on the property you want to add and that's it.

In both situations, the formula is

=E2.Price

Copy the formula for the other currencies

When you copy the formula for the other exchange rate between 2 currencies, you could have a problem.

Not only do you copy the formula, but also the format, on the currency unit 😯 To avoid any mistakes

1. Select a cell with the triangle in the upper left corner
2. Click on the option Update Format