From the course: Excel 2016: Advanced Formatting Techniques

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Create picture links

Create picture links

From the course: Excel 2016: Advanced Formatting Techniques

Start my 1-month free trial

Create picture links

“

- In this workbook are four sheets very similar. Quarter 1, we're currently looking at right now. Here's Quarter 2, Quarter 3, Quarter 4. Exact same layout, and a summary sheet here too. Looking a little bit different, but related. Now, the summary sheet here is gathering information from those four sheets. So, for example, in cell B3 right here, I'll zoom in momentarily. In cell B3 is a formula. It's getting data from cell E3 on the Quarter 1 sheet. And as you might imagine, this is from the Quarter 2 sheet, and so on. And moving up and down, we're seeing the same kinds of formulas. Simply linkage formulas. And so any change we make on the Quarter 1, Quarter 2, Quarter 3, Quarter 4 sheets are immediately reflected not only on those sheets, but on this summary sheet as well. Now, since there are implications when we make these changes, what if we could somehow be always looking at this summary sheet? And rather than bouncing back and forth, what if we could have somewhat like a TV…

Contents