Did you know you can use Excel to convert currencies? It turns out there's an easy way to convert currencies inside your workbook. Use the data types menu and choose currencies.

Similarly, it's easy to forget to type the currency symbol when you're focusing on the numbers that follow, so using Excel's built-in number format converter is the way forward.

Q. We receive Excel-based reports from our European operations with the daily temperatures of our electrical generators and other equipment recorded in Celsius; what’s the best way to convert these ...