يعد هذا الكورس من أكثر الكورسات التي تحتاجها في سوق العمل وكذلك الدراسة وهو عبارة عن ثلاثة كورسات في كورس واحد أولهم كورس الاكسيل للمبتدئين، وفيه تتعلم الأساسيات العامة لاستخدام البرنامج، ثم كورس الاكسيل التأهيلي والذي يؤهلك لسوق العمل بكافة مجالاته كمستخدم عام لبرنامج الاكسيل، ويليهم كورس الاكسيل المستوى المتقدم والذي يتدرج لمستوى المحترفين حيث يؤهلك للعمل في قطاعات أكبر ومعرفة التعامل بشكل احترافي مع البرنامج.
00:00In the previous video, you showed us how to perform simple mathematical operations in Excel to know the sum, calculate the subtraction of two numbers, calculate the name, calculate the path, and calculate the power.
00:13Ok, now we want to start using Excel functions to perform simple calculations.
00:20For example, we want to do the sum using Dalal, or for example, I will add all these numbers.
00:27Do you think we will use the previous equation if we start by saying the number here plus the number here plus the number here?
00:33Or if I have a hundred numbers, for example, the subject becomes very difficult, as we have something called functions in the Excel program.
00:40It makes it easier for us to do mathematical operations. If there is a large number of numbers in a subject, we start using it.
00:47Here, for example, I want to add all the numbers that are present and appear in the cell I am standing on.
00:53So I started by stopping at the cell and covering it with the Alkai group from the tab called the main bar.
01:00And I start to cover the Internet and it tells me that they are 1330
01:06Ok, I would like to know the average of the numbers here. What is their arithmetic mean?
01:12I will start using the arithmetic mean indicator from here. I will press and it will tell him the mean.
01:19And the average price is 156
01:25Okay, here I have a large group of numbers registered in the cell. I want to know how many numbers I have.
01:33I will start by telling him from here, bring me the number of numbers
01:37He tells me that there are 18 numbers.
01:41I wanted to know the highest value, or should I say the highest value? I will start by stopping at the cell and telling it the maximum, which is the highest value.
01:50Okay
01:51Can I specify it like this, please?
01:54I will set it for my term
01:57And you
02:00He will tell me that they are ninety
02:02Okay, the minimum or if the number appears
02:04I will bring the minimum from here and then
02:06He will bring me 18
02:08Of course, if I took it, and when I came to make the coffee here, I had something like Aero with me, and I told him, “Okay.”
02:14Even though I don't know how this coffee pot is written
02:17I may not know how to deal with it
02:19I will start by leaving the program completely and I will not know if I will continue
02:23Ok, how do I deal with functions if I get a message like this and I already write it?
02:29The topic is very easy, no problems. Let's understand it together.
02:34Just as we did here, these values will start to be completely deleted.
02:39And I started using my coffee pot exactly like the equation.
02:43I will tell him it is equal to
02:45What do I want to do next? I want to create a group.
02:48Not a group of Arkham's immigrants
02:51Its abbreviation is SUM
02:54Sorry for the wrong language
02:57I will open a course with the keypad key nine.
03:00After that, which is number one
03:03Which is the first number or the first empty
03:05Can I click on it for him from here?
03:07Which is empty C2
03:09And work with enough lips from the keyboard
03:11To do these two points
03:14The range guy
03:16From C2 to, for example, C22
03:19Okay?
03:20Up to C22
03:26Of course, there is no difference between Cavitel and Small
03:29And he closed the course for him with a zero shift and entered
03:31He will bring me this number
03:33I still have the shape of my coffee pot
03:37SUM which is the sum of the sum
03:40I will write him the first number
03:43The sign that you see is Kaf on the keyboard
03:46To make my range work
03:48Then the second number
03:49Or I will start to define my range like this
03:52Or I can specify from here and close my course for him and then
03:59He will give me the result as you see, the same result.
04:02Okay, maybe I don't want Mada to be online?
04:05I want a number from here, a number from here, and a number from here, whatever it is
04:09Or Rico, how do we get it?
04:11Miscellaneous numbers
04:14I tell him it equals SUM
04:16I will open a course and press the first number
04:19After that, here I have it
04:21We must be able to read and understand the form that is presented to us here.
04:26Here I have a semicolon after sleep and
04:30Which is the first number?
04:32It works like a semicolon with the letter K from the keyboard.
04:36Give me the second number and press it
04:39Then another semicolon, the third number, and so on, and we close the course.
04:43And keep pressing ENTER
04:45Fahizer Maani 226
04:48Okay, what's the difference here? Why did I use a semicolon and Marwa use a colon?
04:52The two points, guys, that's what this shape is.
04:55I saw enough from the keyboard
04:57He brings me the range, I will bring him from the first cell to the last cell
05:01Okay, if I made this shape, which is the semicolon, the letter K from the keyboard
05:06I mean I want separate values, not a range from each other, one from here, one from here, one from here, one from here, and so on.
05:12So we made the group. Okay, I want to make the arithmetic average. I will tell it to equal AVERAGE.
05:18AV
05:19People who do not memorize the words' punctuation
05:23You will find it there as another word that blooms with it after we write AV.
05:27AVERAGE and I know my range
05:31The course ended with a shift of nine.
05:33Close the course with a zero shift and enter
05:36Give me this number
05:38Ok, I want to get the number of numbers I have in this cell. I will tell it to equal
05:44COUNT
05:46COU
05:48It will blossom for me the first time, and it will open a course with me automatically.
05:52I will specify the term, so they will write to me
05:55I saw Zero and Inter
05:58Headley 21
06:00Ok, I would like to know the minimum value I should tell him to be equal to.
06:04Its minimum abbreviation value is
06:06L is short for Minimum
06:08M I N
06:09Opening a course
06:11I set my deadline, close the course and enter
06:15He replied to me with the least value.
06:17Okay, the highest value, which is the max, is equal to max.
06:20Click on it twice to open a course and specify the range
06:26I saw Zero to close the course and then
06:29This number is blooming for me
06:30We have made them very simple, and we can either bring the coffee pot we want from here, a group, an average, or the number of arks.
06:38I will break someone, or we will write them in a way that is comfortable for you and do it. The important thing is that you understand what you are writing, how it is written, so that if any error occurs, you can fix this error.
