Buzz
Microsoft introduces various cloud data connectivity options for Excel, including stock market data and geographic locations, similar to the 2 demo models showcased at the Ignite conference. For example, if you create a list of companies, the application will recognize and provide barcode icons, stock prices, and various other information. If you wish to compile a list of locations, the application can display information about these locations for you, such as population, area, and more.
Microsoft launches new cloud data connectivity options for Excel
These pieces of information are utilized within functions rather than spreadsheets. For example, if column A1 is Hanoi, you can use the A1.Ha Noi function to view the population of Hanoi.
- Download Excel 2016 here
- Download Excel 2013 here
- Download Excel 2010 here
- Download Excel 2007 here
- Download Excel 2003 here
Alternatively, you can also utilize other information such as Zip codes, states, countries, cities, ... Stock data will be updated each time you refresh the spreadsheet.
Typically, an Excel file with thousands of rows of data will inevitably contain many duplicate entries. If done manually, you'll spend a considerable amount of time. The method of filtering duplicate data in Excel that we've shared will help you save time to focus on other tasks.
Microsoft also adds some new features to Excel Online. Users can create Pivot Tables, delete rows and columns to format data, and can use images from local storage instead of just on OneDrive.
Microsoft has made significant efforts to develop its own applications and services. Previously, Microsoft's security software and antivirus programs were rated relatively low. However, in the latest tests, Microsoft's antivirus software tops the list of best antivirus software, showing the efforts and dedication of the Microsoft development team over time.
