Looking Ahead

   

In Chapter 3, you've seen how to use three Excel techniques to manage data: lists, names, and filters. You've seen how to use them in conjunction with other Excel features such as the Data Form and the Sort command.

Because of the limitations of the printed page, the examples given in this chapter are necessarily brief and you've had to suspend your disbelief from time to time. (It would be unusual, for example, to apply a unique records filter to a list of 10 names.)

It's when you have hundreds and thousands of records in an Excel workbook that the techniques you learned in Chapter 3 start to become real timesavers. In Chapter 4, "Importing Data: An Overview," you'll start to see how you can quickly and automatically bring large amounts of data into an Excel worksheet from an external database.



Managing Data with Microsoft Excel
Managing Data with Microsoft Excel
ISBN: 789731002
EAN: N/A
Year: 2003
Pages: 134

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net