عمل روابط داخلية وخارجية واذرار في برنامج الاكسيل

Shereen Elmasry

يعد هذا الكورس من أكثر الكورسات التي تحتاجها في سوق العمل وكذلك الدراسة وهو عبارة عن ثلاثة كورسات في كورس واحد أولهم كورس الاكسيل للمبتدئين، وفيه تتعلم الأساسيات العامة لاستخدام البرنامج، ثم كورس الاكسيل التأهيلي والذي يؤهلك لسوق العمل بكافة مجالاته كمستخدم عام لبرنامج الاكسيل، ويليهم كورس الاكسيل المستوى المتقدم والذي يتدرج لمستوى المحترفين حيث يؤهلك للعمل في قطاعات أكبر ومعرفة التعامل بشكل احترافي مع البرنامج.

Transcript

00:00Peace be upon you, welcome to the last video explaining Excel.

00:04In this video, we will learn together how to create internal and external links and how to damage them in Excel.

00:11What does this mean?

00:13I mean, I have an Excel file now.

00:16This file has papers under it, as you can see.

00:21Okay?

00:22If I wanted to make a link between them, for example, the data here is private

00:27Or what is the relationship between the data in the feasibility of the two or the feasibility of the one or the two sheets?

00:33So I created a link, meaning it's like an internet link. When I click on it, it takes me to the relevant topic.

00:40How do I do this? I dream of seeing each other.

00:43For example, here I will write him any word

00:48Oh, for example, are the salaries for the month of April okay?

00:54I counted the salaries for the month of April when I clicked on it.

01:00My devil opens my April salaries and I have a specific cell

01:05Where do I start? Right click on the cell.

01:08A list of options appears to me.

01:11I will choose the link, this is the last thing

01:13This looks like a crime to me

01:17Here, of course, it must be present on an existing file, page, or web page.

01:23If I want to connect to a file on my device

01:28I assume that my link wants to open another Excel file for me, which is the one that contains the April salaries.

01:34I will choose the salaries of April for anyone in the countries

01:37Of course, this is not a salary, nor a joke, nor anything

01:41These are video files for the course.

01:44Or choose any knitting and tell them I agree.

01:47Do you see what I do?

01:49When I click on it, it is supposed to open the second file, but of course I will not click on it now.

01:56I wanted to remove the click from where and I will go and tell him to visit the sensitization link

02:01Okay, very nice. This way we made a link to a file on my device.

02:06Of course, I want the link to be inside my file in another workflow and another workflow.

02:12Who is clicking on it? Engagement

02:16I will kill the infidel somewhere in the document.

02:20And the timing is forced, so if it pays up

02:22Table two OK, I opened Table two again, so from Table two settings OK

02:27I will tell him, for example, in the cell

02:33for example

02:35MN9

02:39Ok, here is the tattoo

02:41inserted one

02:43Cell M9 in Table Two

02:47Very nice, this is a very easy topic

02:49No, I don't want it in M2 or M9

02:51I want her to go, for example

02:53I have 5

02:55I will come back and make a modification to it

02:57How do you find someone on it?

02:59Marati I will say it is a liberation of popular connection

03:05He brings me something like this, so I tell him that the cell

03:07What I want is D5

03:09And he says, "Agree."

03:11He answers it

03:13D5 cell traveler

03:15Very beautiful

03:17How do I make a link again?

03:19Click me

03:21I'll tell him, "Excuse me, we'll remove it first."

03:23Click who am I? I don't have a link at all

03:25Click who I'll tell him about the engagement

03:27And this link I choose if it is a file

03:29On my device I choose it

03:31Or a place in this document

03:33I choose it in any of their worksheets.

03:35And I choose the cell to open on

03:37And he says, "Agree."

03:39I would like to edit the link at any time

03:41Click on who

03:43And I started to tell him to edit the connection

03:45branching

03:47I will change it

03:49For example, it opens in another cell or opens in another worksheet.

03:51And he says to him, "Okay."

03:53I wanted to remove it completely

03:55Click on him and I will tell him to remove the link

03:57branching

03:59It has internal and external links.

04:01We want to make buttons inside the program

04:03Or inside Excel

04:05What should I do?

04:07Or do you remember last time?

04:09We took all kinds of drawers

04:11From the Insert Shapes tab

04:13Here I choose the shape I want

04:15And this is how it looks

04:17Choose the color I want to tell you

04:19For example, this color is not a solution.

04:25Choose an example for him

04:27This color

04:29Okay?

04:31So take a color with me

04:33I will write here what I narrated in April

04:35Excuse me, my job is to write in English

04:39Narrated in April

04:43Very sweet

04:45Narrated in April

04:47I love that he stays

04:49Button or button with me

04:51Of course, with its own settings.

04:53I will start by changing the font color.

04:55Or leave it where it is

04:57Okay?

04:59Each one or his own

05:01Leave the writing in the text

05:03Can I make it a little bigger?

05:05Give it like this

05:07This is my button or button

05:09I want to leave him

05:11Button with a buckle

05:13When I click on it, it opens something specific for me.

05:15Link from

05:17Same shape, I tell him it's related

05:19And press

05:21For example, this link opens for me

05:23The point of one is to say okay to him

05:25Look when he comes to stand on it

05:27Give me the shape of a hand

05:29As soon as I click it opens the cell for me

05:31What I told him about it is yes and no

05:33In the use of one

05:35I can

05:37This connection and destiny that I

05:39I work on it, I regret it or I

05:41Do it edit link for what

05:43I called him a liar

Category

Transcript

Recommended