O'Reilly logo

Excel 2010 Financials Cookbook by Andre Odnoha

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Importing data lists from the Web

It is often necessary to collect data from web-based sources due to updates and other modifications. An example of a web-based data list would be a list of currency conversion amounts. It is possible to go to the Web, find the currency that you need and to record the information manually; however, due to daily updates and multiple currency conversions, the process can be costly and time-consuming.

In this recipe, you will learn how to import data from the Web. While the steps used to perform this data import are native to Excel, this recipe has been included within the building on section due to the external use of data and the new functionality of this process within Excel 2007 and Excel 2010.

How to do it... ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required