Time
6 hours 3 minutes
Difficulty
Beginner
CEU/CPE
6

Video Transcription

00:00
another function off Excel, That is ah, kind of similar to grouping is ah, our sub totals. And
00:10
in this lesson, I'm going to talk about how to create some tokens,
00:14
so
00:16
Aah Subtitles
00:18
function
00:20
Bye.
00:21
The name It's clear Generating sub totals off certain Ah,
00:28
by the certain parameter in itself And so we need a different kind of table to explain Subtitles and look ATT
00:37
This table here would represent some kind of sales data are so basically, we have a product code. We have a location where it was sold and the quantitative was sold in each and every turn shut for each and every brother code. So
00:54
Ah, if we click, uh,
00:57
here
00:59
and we think on sub total
01:02
we get this dial box in which it tells us for a change in product code or in this case, what we're going to use his location sold.
01:14
He was function some and somewhat. Ah, and then where do you wouldn't have subtitles to be added to which column in this case quantity.
01:23
Now, in order for this to work because you see here it says at each change in location sold,
01:34
the only way it will work is Ah, if location sold, column is sorted. So what's cancel
01:42
this for a moment? Let's go here.
01:46
Let's get consort.
01:48
And we just want to sorted based on location sold.
01:53
So now it is sorted. So we have
01:56
a couple of cities here Austin, Berlin, Charleston, London.
02:00
And, um
02:01
now we can go and click
02:04
on sub total.
02:06
So for each change in location sold, used functions some
02:12
and what do we want to sum? Of course. We want some quantities. So we could be okay.
02:19
We got a display, which is similar, like if we were groping
02:23
Combs
02:24
is Ari Rose. So we have Austin, and then we have Austin Total
02:31
and we have here the quantities of products that were
02:38
sold in Austin.
02:38
And then we have Total
02:43
Member So some awful these numbers here
02:46
and if you look here with some is 9545 which is exactly what these subtitle is.
02:54
And then we have it again for Berlin and Charleston
02:59
and London. And then again, we have grand total in the end.
03:02
So you see these three numbers here? So subtitle gives us three levels off complexity of you
03:12
So this one which we get immediately after we performed the subtitle function, is number three.
03:19
If you click on number two, what we get is we get on Lee Sum totals and grand total.
03:25
And if you click on the one
03:28
we get only grand total. So let's be country.
03:32
And also you can remove some of these. So So, for example, we don't want to look at Berlin and we don't want to look at details off
03:40
Charleston and we're now seeing on Lee the data for Austin and London. But we are seeing subtitles for every location. So this is how it works. So this is
03:53
this is useful function again. Like most of the function in data tab, they are mostly there to help you analyze data, especially if you have a lot of them. So you have seen we have quite a lot off data that goes, Ah ah,
04:12
Out off What? You can look in one screen,
04:15
so either you. So if we go back and expand these,
04:20
if you want to analyze this, you have to scroll upon down.
04:25
So these subtitles help you remove that need and you can just look att what's important to now. If this stable would be a more complex, it would be even more useful than in this room. So this is all about sub totals,
04:44
and let's move on to the next lesson.

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