16. Connecting Worksheets, Workbooks, and External Data

In Chapters 10, “Understanding Functions,” and 11, “Using Everyday Functions: Math, Date and Time, and Text Functions,” you find out how to set up formulas that calculate based on values within one worksheet. You can also easily connect a worksheet to several other worksheets or connect various workbooks. Excel 2013 offers easier-than-ever ways to connect a worksheet to data from the Web, data from text files, or data from databases such as Access.

In this chapter, you discover how to do the following:

• Connect two worksheets

• Connect two workbooks

• Manage links between workbooks

• Connect to Web data

• Connect to text data

• Connect to Access data

• Manage connections

Connecting Two ...

Get Excel® 2013 In Depth 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.