Hi folks, welcome to our new lecture.
Open Powerpoint
Go to Tab Sources
Table Table reach
Table vis
Table reach
Go insert
you can insert any picture which is offline what is meant
by these things all these icons which you can see here
these are called placeholders when we talk about table, if
you want to insert a table you can insert a table through
placeholder so it is
not that there is only one way to insert a table there can
be different ways to insert a table we will see all those
different ways let's see this placeholder if I click on
this these dialog books will open see what is written in
this dialog book it is
written here number of columns 5, number of rows 2 if you
don't know what are columns and rows let's create this
I will show you again what are columns and rows as soon as
I click on ok a design like this is created on my screen
now we will talk about rows and columns the things which
you can see horizontally that is row and the things which
you can see vertically
that is columns and in cell let's talk about row here you
can see a horizontal line this is called row so how many
rows we inserted we inserted 2 rows so first row is this
one second row is below this one we inserted 5 columns so
columns means the vertical
lines let's count 5 columns so first row is this one second
row is this one third row is this one fourth row is this
one and last row is this one so we inserted 2x5 table or
you can say 5x2 table here you can see boxes first box is
this one second box
is this one third box is this one so these boxes are called
cell if you have seen our excel video we have defined cell
and active cell for now you can understand where rows and
columns intersect for example first row is this one and
second row is this
one so we have seen how we can insert table through
placeholder let's see how we can insert table through
placeholder first of all you have to remember where you
have to go you have to go to insert
tab when you go to insert tab you will see table when you
click on table you will see many things first of all you
can see many boxes here is insert table here is insert
table draw table excel spreadsheet let's count all boxes
10
10 10 10
in this slide, we go to insert tab again and go to table
and insert table again.
so, it is not like we are going back and forth.
this is the same thing we did with placeholder.
whenever we clicked on placeholder, it was same as before.
now, here you can increase or decrease the number of
columns.
similarly, you can increase or decrease the number of rows.
for example, I can increase from here and decrease from
here.
so, if you want, you can do like this.
I know that number of columns is 5.
just now, we inserted a table of 5x5 by using boxes.
now, here I want the same table.
so, I can say that I want 5 columns and 5 rows.
so, I will put 5 as count of number of rows.
as soon as I put 5, I have to do simple OK.
while doing OK, you can see that
How much sale did Rahul do in January, we did 1200 and in
February we increased it to 1500 and in March it declined
to 1000 and in April it again increased to 1600.
In Nishant's case we did 1500 and then it declined to 1200
and then 1000 and in last it increased to 890.
In Komal's case we did 2000 and in March it increased to
2600 and in February it increased to 3000 and in March it
again increased to 1500.
In Anjali's case we did 2300 and in March it declined to
1200 and in April it again increased to 3000 and in March
it again declined to 1000 and in April it again increased
to 3000.
In Nishant's case we did 2000 and in March it again
declined to 3000 and in April it again increased to 3000
and in March it again declined to 3000 and in April it
again increased to 3000.
In Table tools you can see two tabs, first tab is design
tab, in which you can design your table, you can apply
different styles, if I talk about layout then you can see
many functionalities in layout.
In table tools you can see two tabs, first tab is design
tab, in which you can apply different styles, if I talk
about layout then you can see many functionalities in
layout.
In table tools you can see two tabs, first tab is design
tab, in which you can apply different styles, if I talk
about layout then you can see many functionalities in
layout.
In table tools you can see two tabs, first tab is design
tab, in which you can apply different styles, if I talk
about layout then you can see many functionalities in
layout.
In table tools you can see two tabs, first tab is design
tab, in which you can apply different styles, if I talk
about layout then you can see many functionalities in
layout.
In table tools you can see two tabs, first tab is design
tab, in which you can apply different styles, if I talk
about layout then you can see many functionalities in
layout.
In table tools you can see two tabs, first tab is design
tab, in which you can apply different styles, if I talk
about layout then you can see many functionalities in
layout.
In table tools you can see two tabs, first tab is design
tab, in which you can apply different styles, if I talk
about layout then you can see many functionalities in
layout.
In table tools you can see two tabs, first tab is design
tab, in which you can apply different styles, if I talk
about layout then you can see many functionalities in
layout.
In table tools you can see two tabs, first tab is design
tab, in which you can apply different styles, if I talk
about layout then you can see many functionalities in
layout.
In table tools you can see two tabs, first tab is design
tab, in which you can apply different styles, if I talk
about layout then you can see many functionalities in
layout.
In table tools you can see two tabs, first tab is design
tab, in which you can apply different styles, if I talk
about layout then you can see many functionalities in
layout.
In table tools you can see two tabs, first tab is design
tab, in which you can apply different styles, if I talk
about layout then you can see many functionalities in
layout.
In table tools you can see two tabs, first tab is design
tab, in which you can apply different styles, if I talk
about layout then you can see many functionalities in
layout.
In table tools you can see two tabs, first tab is design
tab, in which you can apply different styles, if I talk
about layout then you can see many functionalities in
layout.
5th row is same color as 5th row.
Similarly, here in columns also.
That is, the color of alternate columns is same.
For example, 1st row is same, then 3rd row is same, 5th row
is same.
So, we have to go here and make banded columns.
As soon as I made banded columns, see here, this color, and
this color, and this color, are same.
Whereas, the other colors, this one and this one, are same.
So, what happens is, the color of alternate columns is
changed. The color of alternate columns is highlighted.
For example, these three are highlighted.
I will draw a header here.
This is done.
So, we understood how to use table style options.
After that, let's move on to table styles.
Now, in table styles, many colors are given to style your
table.
For example, here, colors are given for best match for
documents.
Here, light colors are given.
Here, medium colors are given.
Here, dark colors are given.
For example, I want this color.
So, I take my table here.
Now, these are pre-sets.
For example, if you hover here, then you will get to know
that this is dark style, 1, x, 4. So, as soon as you click
here, that style will be applied on your table.
If you want to apply any other style, then you go here.
After going here, as soon as this one is done, I did this.
Now, it looks normal.
So, you can use any style of table in this way. After that,
if you go to clear table, then in clear table, you can use
any style of table. For example, you can use any background
of your display.
For example, here is a slide.
What is the background of this slide? It is white color.
Now, you can select here.
For example, I like this one.
So, I will click here.
Now, you can see how it will look like.
So, this is table style.
So, here you can see many styles of table.
So, you can use any style of table and apply it. Now, let's
go to next option.
In next option, you can see shading.
Let's go to shading.
Here, you can see some colors.
For example, let's select a row.
For example, I select this one.
I want to change the shade of this row.
So, I go to design.
After that,
I go to shading.
Here, you can see theme colors.
Now, you can select any color from them.
For example, I select this one.
So, this is our color.
Now, let's go back.
I don't like this theme color.
So, I can select standard color.
For example, I select yellow color.
After that,
I don't like this yellow color.
So, I go back to shading.
Here, you can see no fill.
Means, you don't need any color.
You can select any color.
No fill means, if you don't select any color, you can see
transparent color.
You can see transparent color.
Let's go back to shading.
Here, you can see more fill color.
So, what is this more fill color? We have seen this before.
Here, you can see some standard color.
In hexagonal shape.
Now, in hexagonal shape, you can select any color.
As soon as you click, you can see new color.
Here, you can see current color.
You can increase or decrease transparency.
Here, you can see current color.
If you increase transparency, you can see white color.
If you decrease transparency, you can see actual color.
You can see green color.
Let's go back and go to shading.
Here, we will go to more fill color.
Then we have custom here.
I don't like the color in hexagonal shape.
Because, that color also has limit.
Now, from limited colors, there is only one color, which is
not good.
So, here, you can select any one color. As soon as you
click,
Now go to shading tab and select Morphine color and reduce
the transparency of this color to 0% and click ok.
Now you can see green color is there.
The more transparency you will reduce the color will not be
applied.
And the more transparency you will reduce the color to 0%
or 10% then you will see green color like this.
Go back to design tab and select shading tab.
And here you will find eye dropper.
Eye dropper means you have applied many colors.
Like I have applied this color but I don't know what is the
value of RGB.
What is the value of red, green, black, blue.
So I go to shading tab and select eye dropper.
See this color is same as eye dropper.
What is the value of eye dropper? You can apply this color
to any color you like.
So this is the value of eye dropper.
Suppose I want to insert a picture in this cell.
In this cell.
So you have to click here and go to shading tab.
After going to shading tab you will click on picture.
Now here you will find offline picture and online picture.
I go to offline picture.
And I have inserted this picture.
As soon as I insert this picture you will see this picture
in background.
What is other than this?
Let's see other than this.
I go back to design tab and select shading tab.
And here I see other than picture gradient.
Now gradient means when we mix two colors that is gradient.
So I can select one color from here.
Like I have selected dark variant or light variant.
So you can select any color from here.
Like I have selected this one.
So you can see this color will come like this.
Let's see what we can do in next cell.
So let's go back to shading tab.
After going to shading tab you will find texture tab.
I have got many options in texture tab.
Now I can select any texture from this texture tab.
Here at last you will find more texture options.
So suppose I want this texture.
So here you will find this texture.
will make
a
video on
I don't know why it is not working here, let me try again,
draw table we have done, eraser remove specific border in
table to create merge cells, so what we do is, we erase
this border and erase this border and see if it is erased,
yes it is erased, so
we erased this, so we erase this, so we erase this, so we
erase this, so we erase this, so we erase this, so we erase
this, so we erase this, so we erase this, so we erase this,
so we erase this, so we erase this, so we erase this, so we
erase this, so
we erase this, so we erase this, so we erase this, so we
erase this, so we erase this, so we erase this, so we erase
this, so we erase this, so we erase this, so we erase this,
so we erase this, so we erase this, so we erase this, so we
erase this, so
we erase this, so we erase this, so we erase this, so we
erase this, so we erase this, so we erase this, so we erase
this, so we erase this, so we erase this, so we erase this,
so we erase this, so we erase this, so we erase this, so we
erase this, so
we erase this, so we erase this, so we erase this, so we
erase this, so we erase this,
so we erase this, so we erase this, so we erase this, so we
erase this, so we erase this, so we erase this, so we erase
this, so we erase this, so we erase this, so we erase this,
so we erase this, so we erase this, so we erase this, so we
erase this,
so we erase this, so we erase this, so we erase this, so we
erase this, so we erase this, so we erase this, so we erase
this, so we erase this, so we erase this, so we erase this,
so we erase this, so we erase this, so we erase this, so we
erase this,
so we erase this, so we erase this, so we erase this, so we
erase this, so we erase this, so we erase this, so we erase
this, so we erase this, so we erase this, so we erase this,
so we erase this, so we erase this, so we erase this, so we
erase this,
so we erase this, so we erase this, so we erase this,
so, now click on it and next option is layout in layout you
can see many things so, first of all you can see here
select you can select table, select column, select row this
is simple, suppose I can do normally from here means by
holding cursor of mouse
and from here select a particular row select a particular
column select a particular table you can do this with
select now, what is meant by this is first of all you have
to select things then only you have to apply color on it or
text, some text style
inside text or style inside table you can apply when you
select it so, here we have been given option to select
separately
so, let's go back to layout and here you can see view grid
lines so, because we have been given grid lines already so,
we don't do this now, in delete you can see delete column,
delete row, delete table suppose I want to delete a column
this is a column
with comma so, first of all I will select it after
selecting it, I go to layout and go to delete delete column
so, this entire column is deleted now, the thing is this
March date which is written as 1000, 1000, 1000 what I have
to do is
I have to delete it how can I delete it first I have to
select it as we go to layout and select select row and we
go to this so, we have selected it
March date and after selecting it, we go to layout again
after going to layout, we go to delete and delete row so,
it is deleted all March date is deleted after that, let's
go to delete table delete table so, this entire table will
be deleted let's undo
it let's bring it back and after this, let's see on layout
what I get to see next delete now, I know that column is
deleted row is deleted and table is deleted after that now,
I have some rows and columns which I can insert for
example, cursor of my mouse
is here
I want that one row is inserted so, for that, I have to go
to layout and below insert so, here one row is inserted
now, you can insert it in middle for example, January row
I want that one row is inserted below January row so, for
that, I have to go to layout and after going to layout
I have to insert below as soon as I do it, it is inserted
after January now, suppose
I want above April means, I want one row in between
February and April so, for that I have to go to layout
again and after going to layout what you can do you can
insert above as soon as you insert above, you can see one
row is inserted between February
and April in the same way, you can insert left what will be
left? my column is here
I want that one column is inserted in left of Anjali column
now, how that one column will be inserted to insert that
column, you have to go back to layout and after going to
layout you have to insert left as soon as you insert left,
you can see my whole
column is inserted in the same way suppose, after Rahul
I want that my whole column is inserted in right hand side
for that, you have to go to layout and after going to
layout you have to insert right as soon as you insert
right, in the same way whole column will be inserted so, we
have understood that what
is the meaning of insert above, insert below, insert left,
insert right so, I take 2 minutes break and take water then
we will go ahead that how we will do the rest of the
options in layout till then you can try
Let's move ahead.
After that, what is the meaning of Merge cells?
What did I tell you?
In the beginning, I told you that the individual boxes that
you see, what do we call them?
We call them cells.
Now, here, one second.
Here, this Rahul, what is this?
This is a particular cell.
This is the one with the mark, what is this?
This is a cell.
This is the one with the ring, what is this?
This is a cell.
This is a February cell.
Suppose, I want to merge two cells.
Like, this is 1500 and this is below it.
If I want to merge them, I will select them.
I selected it, went to Layout.
What did I do here?
I merged the cell.
So, now see, the line between them, what happened?
It moved away from here.
Why did it move away?
Because I merged both the cells.
Or, if you want to split, like this is February.
I want to split February.
I want to split this cell.
So, where will I go?
I will go to Layout.
I will go here and split the cell.
So, it will ask me,
What number of columns do you want to do this?
Sorry, I said,
Do it in three.
And number of rows is one.
That is, the rows will remain the same.
But, these three columns will be merged.
Like, one came, two came, three came.
Now, it will not be like this.
Sometimes, if you think that there are two words.
Like, Taj and Mahal.
These are two words.
If, suppose, it was written here.
I will write.
If I wrote Taj here.
And then I wrote hyphen.
Mahal.
If you want to split this.
And after splitting, what will happen?
My Taj will come in a different column.
Mahal will not be different.
So, let's see you.
Then I will do it and show you.
Once, I said, split.
I said, split in two.
So, what happened?
In this way, two will be made.
But, you will have to write it separately.
So, you can do it like this.
So, we go here.
Back to the layout.
And after that.
Here you.
Any particular cell.
Like this cell.
If you want to increase the height of this cell.
You can do that too.
Like this.
If you want to increase its width.
You can also increase its width.
After that, there are distributed rows.
So, all your rows will be distributed.
That is, it will be distributed evenly.
Distributed columns.
So, whatever your columns will be.
In this way, you will be able to see it.
Okay.
Let's click on it.
Let's go back to the layout.
After that, here are some options given to me.
What is this?
To center.
Okay.
Like this is the month.
I made it center.
That is, it is related to alignment.
If I do not center it.
If I want to align it.
Then you will see it here.
And after that, what is this?
You will see the center vertically.
After that, here you will see it at the bottom.
And this will show you up.
Now what is this?
It is the direction of the text.
Let's see the direction of the text once.
What is here?
Horizontal.
That is, it will be shown in this way.
As it is now.
Rotate.
So, you will get it like this.
Many times in any report.
You will see such things written.
That what you want.
It has been given in this way.
It has been given vertically.
It has been given horizontally.
So, you can change it.
According to your requirement.
So, here it is.
Now, what is it?
You can see it.
What is it?
It is visible vertically.
So, what is it?
It is from the layout.
We went to the layout.
And then we went to the text direction.
And as it is stacked on it.
So, by stacking it.
That is, by rotating it one by one.
If you rotate 270 degrees.
So, it will be shown like this.
Okay.
Let's go to the next option.
What is my next option?
Here, I understood something in text direction.
After that, what is it?
Margins of the cell.
What is the meaning of margin?
See, here it is written January.
Okay.
We went to the layout.
We went to the cell margin.
How much margin do you want?
We don't want any margin.
We will do it on none.
So, see.
Here, it will start just after the line.
It can't be like this.
Now, see.
If I don't do none.
So, we went to the cell margin.
I did normal.
So, what is normal?
It takes a little gap from here.
It takes a little space.
Okay.
This thing is called margin.
So, you can do different margins from here.
Like, you can do narrow, wide.
I also do wide.
So, you will see a little more gap.
Now, you can also do custom.
According to you.
Like, I go to custom margin.
And, what I do?
Increase it from the left side.
Increase it a lot.
Like, I did this.
I took it more.
I did OK.
So, see.
January was here before.
But, where do you see January now?
It is visible here.
So, you can see the difference.
How much margin, how much effect it puts on things.
If you want things like this.
Like, I.
Many times, you see margin in books.
There is a little margin.
From the left side, from the right side.
From the bottom, from the top.
Why is it kept?
If you want to give extra additional information.
So, what can a reader do?
He can write things in the margin place.
If you do not give margin.
So, it is possible that to reduce the pages.
That my book is not visible.
Show less.
Means, show less pages in it.
And, whatever my content is.
I can put all that in it.
So, for that you can play with margin.
That brother, you have narrowed the margin completely.
Narrowing the margin.
You will benefit.
But, the reader's experience.
It may go bad.
Then, once, one time.
He will buy your book.
But, may not buy next time.
Because, you have saved a little money.
He did not give margin.
Do not give margin.
Means, where is it written?
So, you can take care of this thing.
So, you can take care of this thing in any document.
You can also take care of the presentation.
After that, what is the size of the table here?
You can increase or decrease the size of the table.
Okay.
After that, you can also reduce or increase its width.
As you can see, it is increasing there.
People can do the aspect ratio.
Brother, it should be this much.
Now, it is more or less.
Okay.
So, here you can also do the aspect ratio.
After that, what is this?
These are some options.
There is a selection panel.
In the selection panel, you are like this.
We did this at the time of the image.
Its use is basically this.
That, we want to see.
Dude, the table I have put.
Is it looking good to me?
Means, it is here.
Many times, what happens is that we do the work of multiple
tables.
So, we do the work of multiple tables.
These table tools are written here.
Will it look good or not?
If I click on it, I hide it.
So, I do the experiment here.
So, the selection panel does a lot of work for us.
You can hide everyone.
You can show everyone.
So, I removed it from here.
After that, I went back to the layout.
And this is my bring forward and send backward.
Most of them are used with my image.
And this is the alignment.
To center the alignment.
Now, it will be applied on the table.
What I have to do with the table?
If I want to align left, it will go to the left.
If I align right, it will go to the right.
If I align top, it will go to the top.
You can do this with the image.
You can also do it with the table.
If it is in the middle, it will come in the middle.
So, we align it to the center.
So, in this way, the line is left.
So, I undo the control Z.
So, I hope you understood.
We also do group with it.
If we take it in multiple tables, we can group it.
The benefit of grouping is that you can bring forward and
send backward.
It will only work when you take more than one table.
So, you have to show one table below the other.
So, it will be used there.
Now, the benefit of the group is that you have clubbed two
tables.
Now, if you want to apply some color on it,
If you want to change the font of some text,
It is applied together.
This is the benefit of the group.
If you want to rotate your table or image,
Then you can use it.
This is the last option.
So, we saw the design tab and the layout tab.
In the layout tab, we saw what is this to select.
This is the view grid line.
Then we saw that you can delete row, column, and table.
Then we saw that if you want to insert a row on a
particular row,
You can insert a row above.
You can insert a row below.
You can insert a row left or right.
You can merge two cells.
Or you can split.
You can increase or decrease the height.
Here I am talking about the size of the cell.
Because it is written cell size here.
So, I am talking about the cell size of a particular month.
I am not talking about the whole table.
I am talking about the table where the table size is
written.
What is this?
This is the alignment.
Because I can change the direction of the text.
I want horizontal, vertical, or the margin of the cell.
Here we saw in January that we increased the margin.
You can decrease it if you want.
Here I saw how to place the text.
I have to bring the text in the center, left, or right.
Then I saw the height which is the size of the table.