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.
Comments