11. Connecting Worksheets and Workbooks

In Chapter 7, “Understanding Functions,” and Chapter 8, “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 2016 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:

Image Connect two worksheets

Connect two workbooks

Manage links between workbooks

Connecting Two Worksheets ...

Get Excel 2016 In Depth now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.