Chapter 9. Extending Excel
In Excel, you can do more than create and maintain workbooks and worksheets. Through data exchange, you can extend Excel in two ways. First, you can use data from other programs within Excel and thereby apply Excel's extensive worksheet capabilities to other programs' data. Second, you can use Excel data within other programs, thereby extending your ability to use, analyze, and present your Excel data.
This chapter focuses on the many techniques for integrating Excel with Word, PowerPoint, and Access, querying Websites, importing data, and querying Access databases from Excel.
With queries, you can bring non-Excel data, such as a Microsoft Access table, into Excel. As you create a query, you can sort and filter the data. ...
Get Microsoft® Office Excel® 2007 VISUAL™ Quick Tips now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
