دمج البيانات في الاكسيل

Shereen Elmasry

يعد هذا الكورس من أكثر الكورسات التي تحتاجها في سوق العمل وكذلك الدراسة وهو عبارة عن ثلاثة كورسات في كورس واحد أولهم كورس الاكسيل للمبتدئين، وفيه تتعلم الأساسيات العامة لاستخدام البرنامج، ثم كورس الاكسيل التأهيلي والذي يؤهلك لسوق العمل بكافة مجالاته كمستخدم عام لبرنامج الاكسيل، ويليهم كورس الاكسيل المستوى المتقدم والذي يتدرج لمستوى المحترفين حيث يؤهلك للعمل في قطاعات أكبر ومعرفة التعامل بشكل احترافي مع البرنامج.

Transcript

00:00In Excel, I have the ability to start performing calculations on more than one range at the same time.

00:06And I start to choose what to do these calculations

00:09I also have the ability to change the range on which I work for calculations.

00:14In a very easy way, without an office in my hands, anything

00:17I start by choosing the range in which I want to display the results of the mathematical operations.

00:22Then from the tab called Data, click on Merge.

00:26I choose what I want to do in my time. I want to make a group, for example.

00:31So I determine the range for which I create the group, for example, these two numbers are the first range.

00:37I will start making it an addition that will be included in all references.

00:42And for the second term, I will start to decide what I want.

00:46For example, the numbers I have

00:50In this way, I start to tell him again to do something for me

00:54So I have two ways now

00:57Okay, then I'll tell him I agree.

00:59So I need these two numbers

01:02The first number 250 is the combination of the numbers 170 and 80.

01:05The second number 170 is the group of 80 and 90

01:09Ok, very nice

01:10Can I specify another time and tell him that he came to do the arithmetic mean for me, for example?

01:15I specify the range I want or the same range

01:18So, give me the arithmetic mean of 170 and 80.

01:22The arithmetic mean of 80, 90 and 85

01:27Back to merging again

01:29As far as I could tell,

01:32And make him suffer

01:33I go back and change the mathematical operation that I want. I tell him, for example, the result is Darb.

01:37I choose what I want here from the first range

01:401800 and 3600 I added it

01:44Choose another range 30 and 60

01:47And add him

01:49After that, I still have two more

01:52I started to tell him I agree

01:54The result appeared with me

01:55This is the product of the numbers I chose.

Category

Transcript

Recommended