From the course: Excel: Tips and Tricks (2023)
Join today to access over 24,700 courses taught by industry experts.
Create linked dynamic and linked static images
From the course: Excel: Tips and Tricks (2023)
Create linked dynamic and linked static images
- In this workbook, we're looking at a sheet called 1stQuarter. And notice that the sheet to the right of it, there's 2ndQuarter, 3rdQuarter, 4thQuarter. All of the colored numerical cells here are formulas. So imagine this is a planning type document. These numbers are speculative. We're seeing projections for the first quarter in the next year; second quarter, same idea; third quarter, same idea; fourth quarter. Different numbers in each case, the formulas are in those yellow cells. And by the way, a quick reminder, if you click anywhere in any of these worksheets and on the Home tab, go to Find and Select, click Formulas, only those colored cells are highlighted. Those are the cells with formulas. Now, on the Summary sheet here, each of these cells is a formula. All those colored cells are formulas. As I click one of these here in Cell B3, and I'll zoom in on this using Control in the mouse wheel. That…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.