يحتوي الكورس على مجموعة مميزة ومختصرة من الشروحات المعدة بشكل دقيق لتناسب كافة احتياجات العمل والدراسة حيث يتناول بالشرح استخدام الأدوات والدوال المختلفة مع توظيفها في نفس الوقت في مشاريع عملية مختلفة ليستفاد الدارس أقصى استفادة وكأنه قام بدراسة عدة كورسات اكسيل في نفس الوقت من خلال كورس واحد يضم (الاستخدام العام لبرنامج الاكسيل - الاكسيل المحاسبي - شرح الدوال والعديد من الأساليب المتقدمة في الاكسيل)
00:00In the previous videos, we learned how to upload our own images to an Excel spreadsheet and upload the students’ grades.
00:08In this video, we want to start making their estimates using the doyle.
00:13I have a database that I use to know his grade, whether it is acceptable, good, very good, excellent, or if this person has failed or not.
00:22I use two deltas together, delta F and delta you
00:26We already know how to use delta and now I will show you how to use delta and then we will use the recursive and and step by step.
00:35We use it to test more than one chemistry together.
00:40For example, if I want to tell him that this person’s rating is acceptable, then my test is that the acceptable rating is a category from 25 to 30.
00:50So he starts testing the two of them together, which one is bigger than and makes 25
00:55At the same time less than 30
00:57I started using Delta and tested the availability of both conditions together.
01:01In any free time I tell him to do it
01:04Open the cup
01:05I tell him that if what is here is bigger than and equal to 25
01:13I make a comma for him
01:15The same cell is also present here. I removed it by testing it to have more than one condition.
01:21Less than 30
01:23Close the door and it starts to say I should waltz
01:25This is how it is when I test the availability of both conditions together
01:27They are not here
01:29He is brighter than the 25th
01:31But not less than 30
01:33Ok, why do we use delta F with our
01:35Why don't I use delta F only?
01:37To get the grades
01:39Because I did not test the estimates with it
01:41Mine alone won't come out right for me
01:43I want to tell him, for example
01:45This person is from 25 to 30
01:47Acceptable from 30 to 40
01:49Good and from 40 to 45
01:51Very good and so on
01:53If I start, I will put it down
01:55His first condition is that he
01:57It will be greater than 25
01:59Why does only the first condition apply?
02:01If he finds anything bigger than 25
02:03This is the first appreciation
02:05What is acceptable
02:07He doesn't care anymore if there is good appreciation
02:09It is very good and so on because of all these ratings.
02:11From 25 he will not understand
02:13We will either make him confused or we will make him
02:15We are here to get out
02:17Our result is accurate
02:19We use the F-flat
02:21Why do we use the F iterator?
02:23Because we will test
02:25Our condition more than once
02:27In the same cell, there may be more than one value.
02:29So I tell him if the first value
02:31Start by giving me
02:33The first condition or the first sentence
02:35If the second value starts with you giving it to me
02:37The second estimate if
02:39The third word and so on
02:41I start by testing several conditions or
02:43Several chemicals in a single cell
02:45How do I start using Dell?
02:47Focus on him very well
02:49Here in the first cell where you want the estimate to appear
02:51I will tell him it is equal to F
02:53I will open the cup
02:55I want to test if this cell
02:57The value that contains ghayn
02:59This person is not even ready to go away
03:01Even if it is less than twenty-five
03:03Post it if he failed
03:05Even if it is from twenty-five to thirty
03:07Acceptable and so on
03:09I start to tell him if
03:11What is here is equal to
03:13Between Tansis because she is
03:15text value ghayn
03:17Start by going down
03:21Ghain as it is
03:23If it is an absence, let it go as it is, an absence
03:25Okay, if the value I have here is less than twenty-five
03:35Ok, I told him if he enters my coffee pot, I will translate the word "if" with F.
03:39To test another value, I will tell it F.
03:43Open the cup
03:44Even if those present here are less than twenty-five
03:48Full comma
03:49Start if you are practical between quotation marks
03:52Which is to write to me that this person failed
03:54The quotation mark and the letter r remain here.
03:57And my quote lock and comma
04:02Next, I want to test if this value is greater than or equal to twenty-five.
04:07I'll tell him F again and open the door
04:10You see, we Omanis open up many doors.
04:12In the end, we will close these cups every year.
04:14I will tell him F and open the door for him
04:16And this time I want to test more than one condition
04:19So use the And for him
04:21I want to test that what is here is greater than and equal to twenty-five
04:24Keep open
04:25If what is here is greater than or equal to twenty-five
04:28comma
04:29The same value that is here is less than thirty.
04:32thirty
04:34I will close the cup
04:35I must make my own comma for him.
04:37If these two conditions are met together
04:39It starts with you writing to me that this person is acceptable
04:42Which is the letter M?
04:44Since it is a letter, I make it between the two vowels.
04:51Then I'll give him my comma.
04:53And I start opening the door for him again
04:55Because I am still testing the rest of the values.
04:58If
04:59If what is here is greater than or equal to
05:04thirty
05:11Open it for him one more time because I still have conditions or values to test
05:15Open the door for him
05:16I test that what is here is greater than and equal to thirty
05:19At the same time, less than forty
05:21To be good
05:22So open all of this again
05:24You stay and I will open the door
05:26If the one who is here
05:28greater than and equal to thirty
05:31comma
05:32The same one here, less than forty
05:34Close your cup for him
05:36If it meets these conditions, it will be good.
05:38Treat it as a comma
05:40And he does it between the letters of the letter jim
05:42Then test if this person has a value higher than forty
05:51And less than forty-five
05:53It would be very good.
05:54Open the door for him again
05:55And you pampered her
05:57Open a cup for him later
05:59Open the cup
06:01I will tell him what is here
06:03greater than and equal to forty
06:05comma
06:07The same one here is less than forty-five
06:10You are the one who broke the cup
06:14I must open a comma for him
06:15I will do it between coordination
06:17This person is Jim Jim
06:19Which is very good
06:20Between the signs of coordination
06:21Then I will make a comma again
06:26I must complete it with Dalat F one more time
06:30To test if this person is older than forty-five
06:33This person will be excellent, so it will be good
06:37Here I don't need to use And again
06:40Because I will test only one thing
06:42One condition is that he is older than forty-five.
06:44Whatever the value
06:45I won't tell him that he is less than
06:47I will tell him that the one who is here is older than forty-five.
06:51At the same time, it is equal to forty, so it remains greater than and equal to forty.
06:55It is equal to forty
06:59What do you want me to do? Give me my comma.
07:01Between the two, write to me that this person is a meme, which means excellent
07:07And I start by telling him, in the end, if I don’t find any of these things
07:12Start by making me a foodie
07:14It means he won't write me any value.
07:16And just as you opened the F bracket and we said that we will close it
07:20I will start by closing it all
07:21So I closed the last part of the arch, which is the orange balloon.
07:24So, hit the cup that is facing the green one
07:26Then he hit the purple cup that he met.
07:29And so the cup of fushia that he met
07:31The green code is missed
07:33And so the black cup
07:35If only I could get the black cup
07:37I closed all the brackets
07:39Click for him
07:51This person is absent
07:52It starts to feel like my head is in a mess, I've already applied all my chemistry
07:57I want to withdraw it to apply it to other subjects.
08:01In the second semester, I will change this format here.
08:04So that it remains the same color as above
08:06So I made the estimates for the first semester.
08:10And the second semester using a recursive F function with
