Create a Web query for Web data from a table on the website by clicking on the Data tab and choosing the "From Web" option in Excel 2010. You can find this on the Get External Data menu in Excel 2007.

Head to Get Data > From Other Sources > From Web. Type the web URL and let Excel extract relevant data from it. You can glance over different table types. Pick one and select Load at the bottom.

There is an easy way to generate currency exchange rates in Microsoft Excel in real-time and we show you how to do it the right way.

Placing spreadsheet data into a table quickly formats it and makes it easy to work with and analyze. Here’s how to use this basic yet powerful Excel tool.

If you've have lots of data and lots of analysis to do, but little time or skill, you need Excel's Power Pivot feature. Here's how to get started with it.

Your data will be transferred into your spreadsheet, and it only took a fraction of the time it would have taken to type it all out.