|
The Exchange Rates Wizard helps you in the construction of the Exchange Rates function. This window shows the amount converted and the latest refresh. |
Use Insert latest refresh (date and time) option to insert the latest date and time in which the function was refreshed. Select a cell in your worksheet and press to insert the lastest refresh. |
|
You can configure the ER refreshing data options to suit your preferences between manual or automatic (selecting how often you want to refresh the rates). |
Use the Export currency rates to create a new worksheet with all the currency rate that you found, using the Wizard tool, respect to US$ (United States Dollars). |
|
Use the Export currency codes to create a new worksheet with all the currency codes used in the function. |
Use Daily report button to save the daily currency report into a folder: Simply write a name for the file and the folder where you want to save the report, finally choose a wished format and a path. |
|
Use Arithmetic calculator button to make arithmetic operations quickly from the select cells and using its GET and PASTE buttons. |
We often lose valuable time doing repetitive tasks -if, for example, we want to hide the headings in several sheets of the Workbook, we will have to do it one at a time. |
|
Use Refresh data* to refresh the exchange rates as you want. To do it press . Your PC needs to be connected to Internet. |
You can see the current exchange rates of every active cell, simply pressing button; then click on Setting button: Choose the wished conversions: (e.g.Euros to US Dollars) Then, save the changes... |
