يحتوي الكورس على مجموعة مميزة ومختصرة من الشروحات المعدة بشكل دقيق لتناسب كافة احتياجات العمل والدراسة حيث يتناول بالشرح استخدام الأدوات والدوال المختلفة مع توظيفها في نفس الوقت في مشاريع عملية مختلفة ليستفاد الدارس أقصى استفادة وكأنه قام بدراسة عدة كورسات اكسيل في نفس الوقت من خلال كورس واحد يضم (الاستخدام العام لبرنامج الاكسيل - الاكسيل المحاسبي - شرح الدوال والعديد من الأساليب المتقدمة في الاكسيل)
00:00In the previous video, we learned how to calculate the academic credits for university subjects.
00:07We can calculate it for the first and second semesters.
00:11Now we are going to start calculating the violations and the Prophet’s subjects.
00:15Of course, this is an obvious question that anyone might have, and why didn’t I withdraw the warnings and have them be applied once for the violations as well?
00:23Because the issue with the violations is different
00:27Meaning, if a person has any irregularities and gets a low score, it will be considered acceptable.
00:31If he gets a passing grade, he will be considered accepted.
00:35Either you pass or fail
00:37But no matter how high the grades are, it will not be counted for him because his grades are like this, because he took his chance on it the second or third time.
00:45Here we will start by putting random numbers from the fifty.
00:49For example, forty-nine and here twenty-three
00:55In order to calculate the special grade for the student, I will start by telling him, “If the student was absent in the exam and got a G, then I will start by writing down the absence as it is a G.”
01:05Okay, if it is bigger than him, it is equal to twenty-five
01:08I will start by sending down his grade to anyone who is not accepted, whatever his grade is, whichever is higher than twenty-five.
01:14Otherwise, this person will fail.
01:17So I start calculating it using the recursive F. I will tell it to be equal to F.
01:21Open a course
01:23I will tell him the value here if it is equal to what is between the dots.
01:31Start by adding the letter ghain between the diacritics.
01:35I will take it as a Capy Beast so that I do not have to change the language every now and then.
01:38Okay, if he is not good, he might be present for the exam. So I will start by making a comma for him.
01:43So I start a chapter for him
01:45And it started for him again
01:47And the conquest of Kos
01:49He said to him that the one here is greater than and equal to 25
01:52So start doing this person is lam
01:56So I give him a comma and between the two clauses is a lam.
02:00after that
02:02So I start with a comma for him and what is between the two parts is a lam.
02:05Then I start a chapter for him and what is between the two parts is a lam.
02:09So I will start a quotation mark for him.
02:11And he closed it with a charming chapter
02:15And green
02:17So I started a chapter for him
02:36And he closed the chapter for him
02:37I will write them the first failed subjects
02:43Here are the absence materials
02:48I wrote him the failed and absent subjects.
02:51I will start teaching them
02:53And the spice is called Home
02:55I will change their direction
02:57Rotate Text Up
02:59To be like the rest of the materials
03:01I will start calculating how many subjects a student has failed or missed
03:08I'll start by closing it at the estimates part.
03:11I will do the rest of the absent subjects
03:14I will consider it like a failed or absent material
03:17I will calculate it by counting F
03:20Count F modifies cells that contain a specific value.
03:24I will specify it for her
03:26I will calculate the failed subjects
03:29I will make the whole concept of Iraq
03:30I will make the full prefix
03:31Count F
03:35He asked the perfect one about the extent
03:37I will make him bru courts
03:39after that
03:41I will separate it
03:43ulcer
03:53By lung
03:55For absence
03:57I will start again the same thing I say equals count if
04:01I open a course and I know about the backward subjects, the first semester subjects, and the second semester subjects.
04:07This is all my stuff.
04:09After that, my comma or semicolon
04:12I choose my criteria or condition
04:15Which is the cell that contains the letter ghayn?
04:17Or write him the letter ghayn between the accent marks
04:20Lock the cup and enter
04:22I think he has one failed subject and two absences.
04:26So we have calculated the backward and failed subjects. Come on, let's get closer.
