O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

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

Does the Worksheet Rely on Imported Data?

Many people work with data that is compiled elsewhere as the basis for their worksheet analyses. For example, a database located either on your computer or somewhere on a network is often the repository for specific information that you extract and analyze. If this is the case, try to make it easy on yourself. Often, we use the "ad hoc" approach to working—that is, we do it quickly, when it's needed, with no particular attention paid to repeatability. If you gather information from a database, you might be able to construct queries that you can execute again and again, on whatever schedule you need, rather than starting from scratch each time. This way, you can ensure that the imported data will be structured ...

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