يعد هذا الكورس من أكثر الكورسات التي تحتاجها في سوق العمل وكذلك الدراسة وهو عبارة عن ثلاثة كورسات في كورس واحد أولهم كورس الاكسيل للمبتدئين، وفيه تتعلم الأساسيات العامة لاستخدام البرنامج، ثم كورس الاكسيل التأهيلي والذي يؤهلك لسوق العمل بكافة مجالاته كمستخدم عام لبرنامج الاكسيل، ويليهم كورس الاكسيل المستوى المتقدم والذي يتدرج لمستوى المحترفين حيث يؤهلك للعمل في قطاعات أكبر ومعرفة التعامل بشكل احترافي مع البرنامج.
00:00Peace be upon you and welcome to a new video explaining Excel.
00:05In this video, we will learn about something that everyone is asking for, and my customers are contacting me on Facebook, WhatsApp, and my various social media platforms.
00:17They ask me, of course we have a printing problem, but of course we have Fadi’s paper, so it’s not a problem.
00:23There are a lot of questions about printing in Excel because it is different from printing in Word.
00:29Ok, the subject of printing Excel is a very easy and simple thing. Anyway, good day. What exactly do we want to print so that we can determine its settings?
00:39For example, here I will print with you this part. I will print this part from the beginning of this column, which is column G, to column R.
00:48Ok, so I start by determining the extent that I want, and for you, for example, this data is ok.
00:55Ok, after I have specified them, I will start by pressing Control P on the keyboard, which is print, or I will tell him file.
01:03I print it and it starts to show me this shape. This is what is specified for me, that the whole thing will print completely, or the active sheets. I start looking here at the active sheets, meaning all the words that I wrote, or the things that I worked on in Excel, anything that I wrote.
01:24Consider it an active paper. Okay, I don’t want to print it all. I mean, for example, I might have 30 or 40 pages. I don’t want the most important ones.
01:32I start by specifying and telling it to print the selection. If I leave it as active papers or the entire workbook, it prints things that I don’t want.
01:40The entire book prints me silver papers. I tell it to print the selection, and it only sends me my selection.
01:46If we take here, my selection would have taken up more space than the page size.
01:52A part of my page that I had selected appeared to me, so it seemed that I had been defeated.
01:58This is of course a print count. I will not let it determine the pages here if you want from a specific range.
02:04If I don't specify, I'll leave it completely blank here in the order of the pages. If I have many pages, there will be three.
02:14Two by one or one by one, meaning that this paper will appear to me, all of this paper, for example, in
02:22I printed thirty or forty copies, then he prints the second sheet for all the copies and so on, and he doesn’t print for me, I mean if
02:29For example, if I want thirty copies, it prints one, two, three, and four pages for each copy. Then it prints...
02:34The next version, of course, is by default, so that we don’t have to distribute the pages again later.
02:41Pages on each copy and then we will stick the subject will remain comfortable, my direction will be vertical or I will unscrew vertical
02:49In the longitudinal form, it will be in the transverse form, exactly. I will laugh with you, of course. All of it. Okay, here is the size of the page itself, any four or any secret
02:59If we have the printing press that prints all these sizes, then we start by choosing the size we want.
03:06Of course, the default print we have at home is the E4. All prints are printed with it.
03:13After that, I start to define my margins. Are my margins normal, narrow, or what exactly?
03:20I tell him, for example, narrow margins. You see the space here, the margin, which is the space between the borders of the page.
03:28On the page and the beginning of the speech in it, then change the paper size
03:33The same or the same content. It could be blank. We say that the papers contain one page.
03:38One or all columns on one page or a handful of rows on one page
03:42One, what does this mean? For example, I have forty fixed commissions.
03:48If you do not show the column scale so that all the columns appear with me on the page, then, for example, if I have
03:54Okay, if I have, for example, sixty rows
03:57The sixty pages are impossible to appear with me on one page
04:01If I want them to appear on one page, it will make them uncomfortable.
04:03I tell him to contain all its rows, he builds that he narrows the distances
04:07So it appears to me on one page
04:10Or I tell him that the papers contain one page
04:13If you have, for example, seven pages
04:15Keep them on one page, whatever their size.
04:17It will appear small, it will appear big
04:19It doesn't matter
04:20Okay
04:21After that, the page settings contain something very important.
04:24Of course, the page here is in vertical or horizontal orientation. It was present from outside.
04:28The size is 80% or 90%. We start to determine it.
04:33Okay, let's take the first Mala'a as an example
04:37Two pages in width and one page in length, as we like.
04:42This paper size is made by Bra E4
04:45Quality of sales. We start by choosing the quality we want.
04:48Of course, I am not given more than one option here.
04:50Which is cancer
04:52The page number can be left as it is, because it won't work for us much anyway.
04:57And the hobby is not what we got from abroad, but here it is in detail
05:01We want a specific number from each direction, for example, upwards.
05:05From the right direction, a certain number, down and left
05:09I have it here in the header area and the page is removed. We can change it or leave it as it is.
05:16Here is a header and removes the page. If I want to write a sentence in the header and remove the page, I will tell it, for example, anything here is a dedicated header.
05:24The right section, for example, is the first page of Excel, for example. So, of course, we don’t write something like this, right?
05:40It will stay here like this. My removal header can also be told to remove custom and write what I want: right, middle and left section.
05:48After that, I will reply with a paper. I have something called rows in my printing press.
05:58Columns Column rows can have headings that specify the type of data that will be contained in them.
06:05For example, here is the series, here is the name, here is the title, here is the birthday date, and so on. So I can tell him the heads of the rows.
06:13And the columns and he says to him, “Okay, fine,” and he starts to work to sell it. Of course, I want to sell it.
06:18Do you need anything else? For example, this dark area can be controlled by me from the panel?
06:31Keys for him to sell, I tell him page numbers, this is my serial number and name
06:37The estimate is called column heads or column header. This is if I have a lot of data and I told him here from a paper.
06:46Make me row and column headings. He will start to put this heading on all pages. That means each page will be…
06:53Above it is the same header, and if there are heads for the rows, they will also come down with me. Okay, here is my print. We start by choosing...
07:00As if it had grid lines, he started to teach me here the grid lines, which are the lines
07:05What is present in the default program is that it does not print. Maybe I
07:10I tell him from here, its prints are in color, or black and white, if I don’t want its prints to be in color at all.
07:16And with it, I start by choosing the order of the pages for him. I usually leave it as it is.
07:21Down then up, okay, so it prints correctly for me. In the end, I tell it OK, and it starts to print the topic with me.
07:28A very easy and simple topic. After we have determined it, we will then choose the printer or...
07:33The edition we will print on may have a Dot Matrix that sees more than one edition, so we choose
07:39What edition will it be printed on? How many copies do we want?
07:44We can write it ourselves or specify it with the arrows and tell it to print. This way we will have finished the settings.
07:51The edition starts by printing the paper or range we want. Come on, try it.
