Practical issue: Use Excel as a window on your data sources
Create a static copy of the data
Create a dynamic link to existing data
Choose your linked PivotTable fields in Excel 2007
Link to data on a web page
Manage external data ranges
Export Excel data
Although Excel includes some functionality to help you work with data, it's generally easier and more reliable to leave data collection, processing, management and storage to packages that are designed for the job, writes Simon Hurst. But this warning doesn't mean you can't use Excel to interrogate, analyse and report on that data. Used sensibly, Excel has a range of tools that can help you get at...