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:
Connect two worksheets
Connect two workbooks
Manage links between workbooks