يحتوي الكورس على مجموعة مميزة ومختصرة من الشروحات المعدة بشكل دقيق لتناسب كافة احتياجات العمل والدراسة حيث يتناول بالشرح استخدام الأدوات والدوال المختلفة مع توظيفها في نفس الوقت في مشاريع عملية مختلفة ليستفاد الدارس أقصى استفادة وكأنه قام بدراسة عدة كورسات اكسيل في نفس الوقت من خلال كورس واحد يضم (الاستخدام العام لبرنامج الاكسيل - الاكسيل المحاسبي - شرح الدوال والعديد من الأساليب المتقدمة في الاكسيل)
00:00In the previous video, we started drawing or planning our practical application.
00:06I continued talking after we finished filming the video.
00:10Now we will start together to modify the form of the words in front of us.
00:14For example, here I have to start by making this on two columns
00:19I will make a margin center for her
00:21I will take the format of this cell that has been merged and want it to be for all the cells next to it.
00:27After I stop it, I press something called Format Painter from the tab called here
00:33I will start by specifying all the cells next to it because they are all double cells.
00:39She starts to take the same layout as hers. In this way, it is possible to also expand the space a little so that his needs are not apparent.
00:46I will start by seeing if I have an extra column, a missing column, or anything wrong.
00:54Until I make sure that everything is fine with me, I will return to the total from the beginning.
01:00There will be a debit and a credit in each box, so I will start by creating a debit and a credit for him.
01:05From this shape, I will start to pull it and the cell spoons next to it so that it does not appear again.
01:16Nice or stay like this with me in all debtor and creditor
01:22I will start after that. I want this month to have a specific name that I will stress about.
01:28And I started by naming her January, for example.
01:32So now I have the month of January. I start by entering its data, for example, here in the city, fifty or fifty thousand.
01:42So, what numbers do I start putting in and I start writing to him that this statement is such and such. If I want to write an explanation for myself, I don’t want to, that’s it, no problem.
01:53I have something called difference
01:56I will start to envy the difference between the debtor and the creditor. Do I have debts and the debtor has one, or is one of them higher than the other?
02:05I will start by doing it with a small pasta equation. I will start by telling him it equals
02:10existing in the creditor
02:13Because I want the creditor to be equal to the debtor, so I made him equal to the debtor again and then
02:19I will start by saying that he should give me a waltz
02:21Okay, if both have the same value?
02:25It will be true for me
02:27Ok, I have macaroni signs in Excel.
02:30Bigger than
02:31I saw Zain from the keyboard
02:33Smaller than what I saw and from the keyboard
02:35Of course we know it
02:37It is not equal to what is smaller than and in front of it is bigger than
02:40So I start by using the equation of the macaroni, any symbol between them
02:44I start in the function with equals
02:48After that, the cell that I want to make macaroni for
02:51I choose the symbol I want
02:53For example, larger than the other cell
02:56So I start by pressing Enter.
02:58It blooms with logical values.
02:59true or false for pasta
03:01True if they both meet the condition I want, for example, that the first is greater than the second or that the first is equal to the second
03:07and false if this condition is not met
03:10So we have finished this video and we were able to work together on the rest of the original visualization arrangements.
