Time
6 hours 3 minutes
Difficulty
Beginner
CEU/CPE
6

Video Transcription

00:00
final part in the story of former thing cells and sheets and Excel is one about creating tables
00:07
so tables
00:09
It sounds a little strange because everything in except is a table, but tables in AC cellar objects that have more properties than just group of cells
00:21
and to create table. It's really simple. So you just click within the space you want to create, make a table off or you can just go and like this. Let's just zoom in a little so you can see better.
00:36
Or you can just select cells that you want to create table and to create into table,
00:42
and you could conform with stable. And then you get all these tiles that could be light, medium dark. You can create a new style. We're not going to bother about that to this moment, and you just click here
00:58
and it gives you the range for your table. Any has the option that your table can have Heather or not. In this case, we do have a better here,
01:08
so we're just going to click okay and we get a table
01:12
and you see the style every second line has been, Ah, in a different background color. It has a little line below, so it's a really nice and easy to look and turn to navigate through.
01:29
But in addition, so this is not just the formal thing.
01:32
It has also added some filters here for each actually buried filters for each of the column. So it is like doing former thing of a table over of a group of cells and then adding filters.
01:45
But also, when you select the table to get this
01:48
very nice, stable tools that can give you some things like, for example, total ro u have banded rose. You can switch it on or off. It's very simple. You can have total Arrgh
02:02
and it will ah adds total in ah, in
02:07
any comb that has numbers in it because you see, here we have text in every other calm. You can have First column last column bandit columns.
02:19
So
02:21
you can, for example, exclude bended rose and get bended. Comes to have bowled bended rows and columns. Makes no sense.
02:27
You can change styles whenever you feel. For example, if you don't like the color,
02:36
the blue background so you wanted to turn it into orange,
02:39
it works fine. So you can
02:43
you can customize your table very easily,
02:46
and then the filter is coming too.
02:50
Their power. So, for example, this is ah, inventory list of species in a company.
02:55
And you have PC types 1234 to 5. Which means basically that they have been purchased in different
03:04
time periods. So they're not the same model you could also have here. The model name I was just didn't
03:13
find important for us to have
03:15
a ll these different models here.
03:19
And then you have a building in which is located on the floor. So if you're going to do the inventory off,
03:28
your PC is just to check if they're still in place there.
03:32
Ah, and you want to create the list for somebody that is going there, for example, of security guard checking it after work, you can say, Okay, you're in charge of building three,
03:45
and that's it. And then you get all off
03:51
the units there with their inventory codes.
03:54
Um, so it's ah, fourth floor
03:59
and so on. And you can also soared smallest to largest. So basically
04:04
so that that person can go first on the first floor and check this five and then on the second floor, these two and then on the third floor, fourth floor, fifth floor, a total number of units of 51. And in this case, you have created very easily, and very simply, the list for
04:24
that can be printed and given to a prison to go out there
04:28
and check the inventory. Check if the all these species have their tags, and
04:32
if you print it nicely enough, they will have space here for some comments. For example, if something is physically damaged, broken or whatever,
04:42
so thistle about tables and tables have more use, which will be explained in the
04:51
one of the modules after this one, when we go and create people two tables.
04:59
So this is it for,
05:01
uh, this lesson. And unless next lesson, I'm just going to do a short recap off everything you have been able to learn this module

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