O'Reilly logo

Microsoft® Office Excel® 2007 VISUAL™ Quick Tips by Denise Etheridge

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

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. ...

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