From the course: Excel: Creating a Basic Dashboard
Join today to access over 23,100 courses taught by industry experts.
Create and manage cell links - Microsoft Excel Tutorial
From the course: Excel: Creating a Basic Dashboard
Create and manage cell links
- [Instructor] Dashboard summarized data from other worksheets and often other workbooks. In this movie, I will show you how to create formulas that include links to cells in other workbooks and also other worksheets within the active workbook. I will also demonstrate how to create a hyperlink to allow users to go to specific destinations on the web. My sample that I'll start with is 02_01_Links and you can find that in the chapter two folder of the exercise files collection. I also have a second file open and I'll use Alt + Tab to switch to it. And it is warehouse data, which you should also open and you can find in the exercise files folder as well. So I'll press Alt + Tab to go back and I'm on the elements worksheet of 02_01_Links. In cell B3, I want to create a link to a cell that summarizes gift basket revenue. And I happen to have that in a table on the support table's worksheet of the 02_01_Links workbook. So I will…
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.