### 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

Milan Cetic

Instructor