I am currently trying to create a currency converter in MS Excel, I know about the HELLOEURO function that imports the information but I was wondering if there is a more simple way.
I am due to teach a lesson of students are a similar age to myself with very basic excel knowledge, I am not very keen on the program myself that’s why I need some help.

I was wondering, is there a way where I could manually get them to set up a sheet containing the exchange rates and another sheet in a named table, then on the interface sheet they select one of the currencies and put in the amount they wish to change, and then select another currency and it will convert this money in to the correct currency? Or am I doomed to using HELLOEURO?

Any suggestions, information will be much appreciated.