6 hours 3 minutes
final part in the story of former thing cells and sheets and Excel is one about creating tables
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
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.
Or you can just select cells that you want to create table and to create into table,
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
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,
so we're just going to click okay and we get a table
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.
But in addition, so this is not just the formal thing.
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.
But also, when you select the table to get this
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
and it will ah adds total in ah, in
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.
you can, for example, exclude bended rose and get bended. Comes to have bowled bended rows and columns. Makes no sense.
You can change styles whenever you feel. For example, if you don't like the color,
the blue background so you wanted to turn it into orange,
it works fine. So you can
you can customize your table very easily,
and then the filter is coming too.
Their power. So, for example, this is ah, inventory list of species in a company.
And you have PC types 1234 to 5. Which means basically that they have been purchased in different
time periods. So they're not the same model you could also have here. The model name I was just didn't
find important for us to have
a ll these different models here.
And then you have a building in which is located on the floor. So if you're going to do the inventory off,
your PC is just to check if they're still in place there.
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,
and that's it. And then you get all off
the units there with their inventory codes.
Um, so it's ah, fourth floor
and so on. And you can also soared smallest to largest. So basically
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
that can be printed and given to a prison to go out there
and check the inventory. Check if the all these species have their tags, and
if you print it nicely enough, they will have space here for some comments. For example, if something is physically damaged, broken or whatever,
so thistle about tables and tables have more use, which will be explained in the
one of the modules after this one, when we go and create people two tables.
So this is it for,
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
LPI Linux Essentials
LPI Linux Essentials practice exam helps to prepare for the LPI Linux Essentials 010-160 certification ...
Being an intermediate level user of Excel can help save a user hours of work ...
9 CEU/CPE Hours Available
Certificate of Completion Offered