6 hours 3 minutes
Let's now talk about grouping and grouping cells. So in this lesson, I will show you this lovely, visual aided Excel has.
And when I say this is a visual aid, this is because
this actually is intended mainly for viewing. So let's clear the filtering you we had before. Let's delete these,
extra cells we don't need.
And let's go to our old same table.
Ah, and let's look at it. And, for example, we're doing some analysis and imagine that this has, like, 100 throws or something like that,
and we're looking at just the revenue generated shift and who's sells person. So we're not really interested
in profit and every gym. Arjun. Now what we can do is we can hide them,
Uh, and we cannot hide them later.
But we also can do is we can go and group them,
and if we grouped them, they become grouped
and we can just remove them from the
and they're still here.
And also what we have here
is levels off displaying or showing what's grouped. So we have level one in which were were displaying.
We're removing from the view the group sells
and also a level two when we're where we are showing them.
Ah, the good thing about groping is that we can do that also for Rose. So we can, for example, sort this
Let's say, by shift. So it's a, uh,
afternoon shift in morning shift. Yeah, we made a mistake. So
let's click here
on Dhe do this
and this will also
make this thing bad. So let's select all of these cells
was do sorting
and we want to sort by calm sea
and we want from A to Zed
And now we can select the morning shift
and group. It's as well,
and now we can also click here on one and cook your own one,
and we get just what we wanted to look, which is
the revenue in morning shift is every afternoon shift.
So if we want to one group these so we don't need grouping anymore.
We have to show all of the table
and then select group rose or columns and click Anon group.
So let's do it. The same thing here
was do the young group and we're back where we started. So this stable is now
fully visible. Nothing is grouped off course. You can say with grouping, but it's Ah
unless it's absolutely needed. It's not really necessary.
So this is all about grouping and and grouping grows and corns in Excel.