8 hours 33 minutes
So let's start with how to work with the Rays in Excel.
So in this lesson, I'm going to talk about what? Our dear raising excel and what are the array? Constance.
So my definition in Excel
arrays a set or collection of cells that can be operated on collectively.
so a raise can be one dimensional, like a single row or single called,
and they could be to them and show consisting of more rows and columns.
But they have to Group B group, so you cannot have, for example, cold A and see when the rate has to be a B or A B, C or B C. But A C is not possible.
and you can create a rate Constance by typing in a single cell. But this array constant is going to spread across multiple cells.
in excel, there is no need to specially define array.
So if you're using a rainha function, it is just important that use correct sells for you. But there were you doing and to enter it in a special, and we're going to talk about it
so formulas with the rays can be single cell formulas or multi cell for once, and the vehicles owned. Going to see examples of that
and the typical use of a raise is combining into functions.
So let's start with the basics.
So let's say we want to make horizontal array. We're going to select a couple of cells, for example, is safe four of them,
we're just going to type
equals. And then we're going to open curvy brackets.
And then we're gonna just type one comma to come a three. Come on, four.
It is not necessary that you enter
numbers or whatever
constant separated by commas
in this field. And I'm going to explain to you how it looks a little bit later if you do it in another way. But anyway, you close the curry brackets and then you press, and this is the most important thing. We're working with the race. You don't press, enter you press control shift, enter
and then you have a ray.
And if you look at the cells, they all contain the same content that you have entered in first cell,
where you type the array for vertical array. It can be
it is the same way off, Anthony. Pretty much
so. You're select cells
and then you type equals you open career bracket and for example, we're now entering text and we're going to say
to use the
There is the
But I have intentionally made the mistake in this just to show you that you shouldn't use comma,
you should use a semicolon because in order to separate
Rose in excel, you need to use semi colon.
So this is a typical mistake that everybody is making when they start working with the race
and they by default goto separating elements in array with comma. And this is yes, the case with
horizontal rays. But when you doing vertical raise, the separator is Sammy Cohn. So I have entered this array constant, and then I can press control shift into her again.
And this is what we get to the end.
Two dimensional re
is entered in the same way. So let's do it very simply,
Two by two
equals career. Break it
and then one comma two and then semicolon. This way we're telling Excel, go into next row and then three
four Close the curry brackets and we type control shift, Enter.
And we have a mistake because we have entered,
one common to many.
And this is what I want to tell you. So excel will warn you if you're typing something that doesn't fit
the XL. Ah, logic off designing a raise. So you have to go and correct It is not going to offer you out to correct like with some functions.
So you correct in the new place. Control, shift, enter.
And here it is.
And the other thing about the race and why are they so interesting is if I want to change this cell and I just want to type five here.
What I'm going to get is also an error which says you cannot change part often array.
This is very, very important thing, and we're going to talk about the importance of it
later during this course. But they suggest for you to understand what I'm talking about.
So you have to press cape, go back to original, and if you want to change this cell, you have to select again. Entire array constant, and it's time of two to type five and again to press control shift enter.
And now you have your worry corrected.
Also, if you select four cells
and you type equals career, break it. 123
and then you close
and press control shift enter.
So you have entered three,
uh, fields in the four field horizontal ary.
What you get is this.
So it's there to remind you that you haven't entered all the numbers you need to fill
the ray you have selected.
It can be corrected later, off course by again selecting this
comma leading to another number.
I have to before
control shift, enter. And now you get it right.
So imagine you, You already have
data entered in worksheet and you want to make
array constant out of it.
So what you do, you select the equivalent
selection of cells somewhere else,
and then you go here and then you type equals,
and then you just select these cells you already have entered in your data sheet
in your press control shift, enter.
And now this is an array
which is linked to this data. So if you put here number nine instead of F
you will get it automatically changed here.
What is also very important about this is that here you cannot change anything,
so you'll get an error and you'll say, Cancel you revert back to the old thing. So if this is summer in another worksheet and you keep it kibun
and you're giving this to somebody else to just do calculation on the date that they cannot change them, they cannot easily manipulate them. And what is most important, they cannot change his data by mistake or by
just not paying enough attention to what they're doing.
So if you were giving some Excel sheet for your students to do some practice with it, you can protect the road data that you're using,
uh, from accidental manipulation.
And now we're going to close this. Listen,
So you have learned in this lesson how to use it. Sell Constance