تسمية ونسخ ورقة العمل في الاكسيل

Shereen Elmasry

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

Transcript

00:00Peace be upon you. I am here in a new video explaining Excel.

00:05In this video, we will learn together how to highlight and copy a worksheet.

00:11Our discrimination is either by coloring the worksheet, which is the part that I point to with the mouse, every day.

00:19It is called a complete worksheet.

00:22We can make this distinction for her by changing her color or giving her a different name so that we can return to her at some point in time.

00:30We will also know together how to copy this worksheet or move it to the Excel sheet.

00:37Ok, this is about oil. Let's see together.

00:40First of all, if I want to name my worksheet something other than “Sheet One,” which is the default name...

00:46I want to name it, for example, Ah Q One, or the first part, or whatever my name is.

00:54Right click on it

00:57And I start telling him to rename

00:59I call her Q One

01:02So I got a name

01:05The one next to it is the same thing. I start by right-clicking on it.

01:09I tell him to rename it

01:10Call it Q Tom for example

01:12Okay

01:14Ok, very nice, I have Q1 and Q2m

01:17good

01:18Yes, he says, we would like to color our tab or our worksheet.

01:24Right click on it in the same way

01:26But this time, instead of telling him to rename, I tell him to color the tab.

01:31Let it be purple, for example.

01:34Right click on the one next to it

01:37Give it a color like this

01:40And so on

01:41Ok, I wanted to give them all the same color.

01:45I will start by right-clicking on it and telling it to select all papers.

01:49So it's all set for me, right click again

01:51And I started to tell him the color of the tab

01:54And it will turn red, for example.

01:58Should I change the color of all of them to another color?

02:03So, each one has his own preferences.

02:06Ok, very nice

02:08Now we know how to name them with the custom of naming

02:10How do we color them?

02:12In their color

02:14Tab color

02:16How do we color them all at once?

02:18We will do all the paperwork for them.

02:22Now I want to take a copy of the diaspora and throw it in the file.

02:26I have this one and another one

02:29I will give you who

02:31And I will start to tell him this time to copy or paste

02:35Okay?

02:36I wouldn't want to put it in the same file or the same folder.

02:40I will bring this classifier as it is

02:42If I want to write it in another file

02:44I will like and see the classifier that will tell me

02:47His name will be E

02:48Okay? Of course we do, so he only opens one file.

02:50So answer me, the author is one

02:52Okay, I want to cut to the chase.

02:55I will start to say it to the end

02:57Okay? I'm moving now.

02:58No, I don't want to say it.

03:00I want to take a copy of it

03:02It remains with me at the beginning and the end

03:04The ambush remains

03:05Transfer or copy

03:07I will make the version that is under the DVD as it is

03:10And I start to choose his place

03:12It will be above

03:13I tell him to create a copy

03:15I still have the possibility of transferring

03:17Or copy

03:19And the transfer we did

03:21I didn't say at the end

03:23So he took the worksheet.

03:25Thrown into the devil from the other

03:27Now I want to be there twice

03:29So I start to define here

03:31Create a copy

03:32I tell him to leave

03:33I have Q1

03:35Between two cups

03:37This means the second version

03:39I have Q1

03:41good

03:43I have another way to transport

03:45I want to transfer the tabs

03:47Or change their order

03:49I start to pull the tab

03:51With the mouse

03:53Click left

03:55And I drag it by throwing it around

03:57And arrange the tabs

03:59The way I want

04:01Ok Q One

04:03Which is copied the second time

04:05I don't want this

04:07I'll start making a cricket on it

04:09And I start to say shame on him

04:11Finally

04:13If I wanted to add a new tab to it

04:15or a new worksheet

04:17I will start clicking here on the disappearing sign

04:19So he brings me a new worksheet.

04:21Okay?

04:23So we know how

04:25We work on our awareness

04:27For the worksheet

04:29How do we color it?

04:31How do we call it?

04:33How do we transfer it or make an additional copy of it?

04:35Of course, here too there are special settings for our worksheet.

04:39Can we rename it?

04:41Or move and copy the paper

04:43Or we color it

04:45And the protection that we had previously provided from below

04:47Come on, try it

04:49Come on, try it

Category

Transcript

Recommended