Microsoft Excel 56 Linking Sheets and Workbooks

SimpleTutorials

Microsoft Excel is a powerful spreadsheet application used for organizing, analyzing, and visualizing data. In this course, you will learn the essential skills you need to get started and become confident in using Excel.  In this video lesson, we will learn about Linking Sheets and Workbooks in Microsoft Excel

Transcript

00:00So over here, you can see that I have this particular data right here. And let's say

00:09what I want to do now is take a reference to this data into another sheet. So I'm just going to go

00:15around over here and onto file and click on new sheet right here. Or you can do this with an

00:20existing sheet as well. So what you can actually do right here now is let's say for example,

00:24press equals right here just like this. And let's say for example, take this cell as a reference,

00:29you can go ahead and click. And then what happens is that you can see that it takes the reference

00:34from that particular cell, press enter. And now you can see the value right here just like this,

00:40you can go around and see that it says $$ right here just like this. So let's go ahead and remove it,

00:46press enter. And now if I were to click and drag, you can see the other data right here from this

00:51particular cell as well. You can even go ahead and click and drag and see the data right here.

00:56So whenever I go ahead and make any changes right here just like this, then what happens is that I

01:02have the change right here just like this as well. So that is how you can go ahead and link out sheets

01:07in workbook inside of Excel sheet in Microsoft Excel. So hope you found this video useful. Be sure to hit

01:17the like button, don't forget to share this out with your friends and family and for more contents like

01:23these, do follow simple tutorials.

Category

Transcript

Be the first to comment

Recommended