Currency Conversion in Excel

In this video, Everton Pires demonstrates two methods for converting currency in Excel. The first method uses data types, a feature in Office 365, to automatically update currency values. The second method involves using intelligent search within Excel to find current exchange rates. The video also discusses the requirements for using these features, including the need for an internet connection and possibly being part of the Office Insider program. Viewers are encouraged to download a worksheet to follow along with the tutorial.

What is the main topic of the video?

• Data visualization in Excel

• Using formulas in Excel

• Converting currency in Excel

• Creating charts in Excel

Which version of Office is required to use the currency conversion features?

• Office 2013

• Office 2016

• Office 2010

• Office 365

What is the first method of converting currency mentioned in the video?

• Using pivot tables

• Using formulas

• Using data types

• Using macros

Which tab in Excel do you need to go to for using data types for currency conversion?

• Home

• Review

• Insert

• Data

What is the advantage of using data types for currency conversion?

• Manual updates

• Automatic updates

• Complex setup

• Limited data

What is the second method of converting currency mentioned in the video?

• Using charts

• Using macros

• Using pivot tables

• Using intelligent search

Which search engine does Excel use for intelligent search?

• Google

• Yahoo

• Bing

• DuckDuckGo

Where do you find the intelligent search option in Excel?

• Review tab

• Insert tab

• Home tab

• Data tab

What keyword can you use in intelligent search to find the current exchange rate of USD to BRL?

• USD exchange rate

• Dollar to Real

• Dollar rate

• USD to BRL

What should you do if you have any doubts or suggestions about the video?

• Leave a comment

• Ignore them

• Contact support

• Search online