ExcelZone Compendium: Advanced data entry tips. By Simon Hurst
We already have an Excel Zone Compendium for Data Entry Basics. This digest looks at some more advanced techniques for working with data, particularly linking Excel to external data sources and using Data Validation and Excel form controls.
Spreadsheets are good at a whole range of things, but there lack of inbuilt structure doesn't make it very easy to control and manage the entry and storage of large quantities of data.