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.
