Using online data on Microsoft Excel 2010
Importing data is not a new thing for people who’ve been using Microsoft Excel 2010. However, the beauty of this application Microsoft Excel 2010 is that you can also use data that’s available on the internet. You don’t have to manually input any values on the application. Using online data on Microsoft Excel 2010 is an easy job. Let us see how one can do it without any trouble.
Importing data from the web
When you need to import data from the “web” it’s a simple process. To begin the process, click on the ‘Data’ tab. There you would see the option called ‘From Web’, select that option. Once you select that option, a small window would pop up on the screen. This screen is nothing but a web query which would retrieve the data that you need. There in that window, you need to give in the address of the website that you need the data from. When you give the address on the window, a preview of the webpage will be displayed to you on the screen. Check if the data that you want to import is present on the webpage. Then click import.
Downloading the data
Once you click the option ‘Import’ Microsoft Excel 2010 will import the data from the address of the webpage that you’ve given in the previous step. The data is downloaded and a window to show you the progress of the download is displayed on the screen. After the download is complete, Microsoft Excel 2010 will ask you about the location of the data. You can choose the cells that you want to place the data in, in this step and then press ‘Ok’ to continue. Once you press ‘Ok’ Excel 2010 would import the data and then it will display the information on the sheet.
Cleaning the data
Some unnecessary data might also have been copied from the webpage which needs to be cleaned. You can delete the data that you do not require from the cells where the data has been copied in Microsoft Excel 2010. And now, the sheet is ready to be used. Without having to manually input any data in Microsoft Excel 2010. This would be an easy feature that would come handy when you already have huge amount of data ready on a webpage that you need to use in Microsoft Excel 2010. That way, you don’t have to manually input anything at all. Just keep refreshing the data every time you open the sheet so that the data would be synced with what’s present on the internet.
See? This is a simple job but a great feature that would save a lot of time for the users and make their Microsoft Excel 2010 experience, a great one!