8 hours 33 minutes
in previous lesson, you have been able to learn what
a raise in Excel where sheets are,
um, what kind of rays have so single dimensional, which occupy cells grouped in single row or single comb
and two dimensional, which consists of for cells
a T least two rows and to colds.
Then you have been able to learn how to enter a constance
and, uh, especially the most important parties when they were. You do something with the Rays and Excel. When you finish typing in the cell, you press control shift enter.
In this lesson, we're going to go with step further and talk about how to use the race and functions. And let's go directly
just a reminder that the rays and formulas can be really useful in calculations and simple functions so you can use them with mathematical statistical functions, and you can also use the race within formula. Is there a constant spitting formulas if needed? But you don't have to.
So the examples we have here
are without using a race array constants in formulas.
And, uh, this is, uh, this example consistent were simple.
sales data table that might be have been entered in small company that sells furniture or furniture items.
And we have five of these. So we have table chair bar still so fun armchair,
and we have the price per unit.
And then we have quantities
entered the end of each week of how many units off each item has been sold.
And we just want to calculate the total sales for the period of four weeks
now in every example with the rays and going to try to explain to you how it's much simpler to do it with a raised in classical way without them.
So in this case,
if you want to do it the traditional way, we would have to add additional conduit, for example, monthly
Okay, this is not exactly monthly sales, but, period, the four weeks is approximately one,
and then we simply multiplied the price
off sales for all four weeks.
Close it through percenter,
and then we just multiplied this formula toe all five rows with 545 items,
and then we just
where these we get the number of 58,900 and 20
and now the same thing done with
So again it's a sum.
And then we're going to use array for this
colon. These five cells,
which are going to of course, be multiplied with
off all these.
So we're going to
track Ah, add old these. Sorry,
and make this calculation.
And then at the end of the entering, we just press control shift, enter.
Then we get the exact number.
Now, don't be wrong. When you're entering creating such formula,
you have to,
multiply a apples with apples, not apples with oranges.
So we have here
which has prices,
and then we multiply it with
we cannot do this
and then this column
and then multiplied with
because this is completely wrong. Because what were then trying to do is the plum. Multiply this
and this is not what we want to do.
Ah Ah! Sorry. Um and then we had this.
So if you would
make the formula like this
just to see how wrong this is
Apprentices with press control shift enter
and we get completely different number
now in Ah,
orderto understand. Why is this the case? Let's do devaluate formula just to see what's happening.
So we do the value it and then we have
244 51 for 5300 and 25 multiplied with.
And then we have 86 84 98
And then again, this
and then again this and then again, this
And when we have this all together,
this is the sum of the numbers.
And you understand, why is this different? So we have to understand the logic off how
these formulas work.
when you're trying to
multiply some numbers in the rays and formula, you have to put
comes to the columns, not comes to the rose.
off using raising simple functions
is this. We have ah,
not like the coach that this training, traveling dean,
and they're starting to starting the five week training program and they want to see how
this whole team has improved after five weeks off training so that they can
see if the training method is working.
So they have their results. The lengths that they have thrown at the beginning of the training period and then at the end of the training period. And we want just the average.
We don't want it to look by athlete. We don't want it to look by,
anything else, Just the average for the team.
So what are we going to do?
In traditional way, we would say improvement
and then we would
make a simple formula in which we divide
and then we subtract one meaning we don't want to see, because if we would do it without strictly when we get 105 points or seven. Now, this Atley didn't improve for 105.7%. No, he has improved, actually,
Now, we copy this formula here,
and then we calculate the average by
the wedding, some off all these improvements
and we get the number of four
out to do it with a raise.
We're going to type it very simple. Just going to say
which is basically the function that it's average,
and then we're going to use race. So we're going to Ah,
but there were is in cold. See it can be. And then it yet from the results were going to subject one.
And we don't forget to press control, shift, enter
and we get the same result. So it shows you how simplified can be the calculation in excel when using race.
Data Analyst Excel
The Data Analyst Excel Test is a premium Cybrary assessment created by iMocha and intended ...
Monitor a Web App
In this IT Pro challenge, participants get hands-on experience activating server logging and using Application ...
Learn On Demand