Time
6 hours 3 minutes
Difficulty
Beginner
CEU/CPE
6

Video Transcription

00:00
Let's now talk about grouping and grouping cells. So in this lesson, I will show you this lovely, visual aided Excel has.
00:10
And when I say this is a visual aid, this is because
00:14
this actually is intended mainly for viewing. So let's clear the filtering you we had before. Let's delete these,
00:25
um,
00:27
extra cells we don't need.
00:29
And let's go to our old same table.
00:32
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,
00:42
and we're looking at just the revenue generated shift and who's sells person. So we're not really interested
00:50
in profit and every gym. Arjun. Now what we can do is we can hide them,
00:57
Uh, and we cannot hide them later.
01:00
But we also can do is we can go and group them,
01:06
and if we grouped them, they become grouped
01:11
and we can just remove them from the
01:15
screen
01:17
and they're still here.
01:19
And also what we have here
01:22
is levels off displaying or showing what's grouped. So we have level one in which were were displaying.
01:32
We're removing from the view the group sells
01:36
and also a level two when we're where we are showing them.
01:41
Ah, the good thing about groping is that we can do that also for Rose. So we can, for example, sort this
01:53
table,
01:53
Let's say, by shift. So it's a, uh,
01:57
afternoon shift in morning shift. Yeah, we made a mistake. So
02:01
let's click here
02:04
on Dhe do this
02:07
and this will also
02:08
make this thing bad. So let's select all of these cells
02:14
was do sorting
02:15
and we want to sort by calm sea
02:20
and we want from A to Zed
02:23
And now we can select the morning shift
02:28
and group. It's as well,
02:30
and now we can also click here on one and cook your own one,
02:36
and we get just what we wanted to look, which is
02:39
the revenue in morning shift is every afternoon shift.
02:45
So if we want to one group these so we don't need grouping anymore.
02:50
We have to show all of the table
02:55
like here
02:57
and then select group rose or columns and click Anon group.
03:02
So let's do it. The same thing here
03:06
was do the young group and we're back where we started. So this stable is now
03:10
fully visible. Nothing is grouped off course. You can say with grouping, but it's Ah
03:19
unless it's absolutely needed. It's not really necessary.
03:25
So this is all about grouping and and grouping grows and corns in Excel.

Up Next

Intro to Excel

This basic Excel training course will give you knowledge of Excel and the ability to use this software to do elementary calculations, file manipulation, data manipulation, to create charts, pivot tables and templates.

Instructed By

Instructor Profile Image
Milan Cetic
IT Security Consultant
Instructor