Hi folks, welcome to our new lecture.
How to insert data in table using excel sheet?
We are going to see that.
First of all, let's open powerpoint.
To open powerpoint, we need to use Windows plus S.
And here we need to write POW.
As soon as I wrote this, I got this suggestion.
Powerpoint.
Let's open it.
After opening, I have to go to blank presentation.
I went here.
And after that, I write a new slide.
Here I did a new slide.
And this is my slide.
Now let's go to insert.
After going to the insert tab,
Where do we have to go?
We have to go to table.
Let's go to the table.
And at last, you get to see this.
Excel spreadsheet.
As soon as you go to the excel spreadsheet,
Or let's make a table first.
OK.
First we make a table.
Insert.
Table.
And we made a table like this.
After that, we put the cursor of the mouse here.
We went back to the table.
What did we do?
Excel spreadsheet.
And this excel spreadsheet has come here.
I made it a little bigger.
And here I have to put the data.
OK.
So I put the data here.
As soon as I put it here, Month.
Let's put the same data.
And let's put some names here.
Like what happened?
Rahul.
Deepak.
And Suraj.
How much was their monthly sale?
OK.
Suraj.
And what do we do here? Let's do the month.
Brother, January.
After that, February.
Then it was March.
Then it was your April.
OK.
I put the data here.
Let's put some numbers here.
Sale of 1500.
2000 in February.
Then of 20000.
After that, 4567.
This is a number.
I put some random numbers.
OK.
And after that, we put the sale of Deepak.
Brother, 2000 in February.
Then 2500 in February.
And then 3000 in March.
And in April, brother did 5000.
If we see Suraj, 20,000 in the first month.
Then it dropped.
Then it became 15,000.
Then we see a number here.
2500.
And then finally, brother did 21,000.
So this is my number.
That is, in Excel spreadsheet,
Whatever data I had,
I wrote it here.
And then if I click here,
So what happens?
In this way,
All this data comes.
Now you don't need to take it in the table.
As we have taken the table here.
We remove this table from here.
We go to Insert.
And go to the table and delete it.
One second.
We have to go to the design.
We saw this in the last lecture.
I got the design.
Sorry, I have to go to the layout.
In the layout, delete table.
So we deleted the table.
And we brought this data down a little bit.
We removed it from here.
And see.
That is, what happened in this?
Now try to understand this.
What happened here is that
Whatever your Excel spreadsheet will be,
You are bringing that sheet exactly the same.
So what is this?
Data is in the table form.
But in the Excel spreadsheet.
There are also rows and columns here.
In the rows and columns,
This cell has been here.
In which January is written.
Here is a cell.
February is written.
Here is a cell where March is written.
So in this way,
You can use the Excel spreadsheet.
Now see.
Suppose you have to edit.
Here instead of 20000.
That is, you have a new guy.
Name of Golu.
You have to show the data of that too.
So what do you have to do?
Double click here again.
As soon as.
One second.
Why is this not happening?
One second.
Control Z.
Format.
And.
Let me do it again.
Let's do it in a blank sheet.
One second.
Let's come here.
On the insert.
And.
Let's do this.
Table.
We did not do it here.
First we did the slide.
First we went to the home.
We went to the new slide.
We opened the blank slide on the slide.
And here we went to the insert.
After going to the insert.
Then we went to the table.
And we did the Excel spreadsheet.
We closed it from here.
We dragged it like this.
Here we put some random data.
I am just showing you.
After that.
Here we put some random data.
After that we click here.
As soon as we click here.
White.
Slide.
I mean the white space on the slide.
Anywhere.
As soon as you click single.
It will be inserted in this way.
If I want to do this again.
In that sheet.
If you want to make any changes.
Then I have to double click.
On the same sheet.
As it came here.
Now what do I write here? I wrote month.
And here I put.
Rahul.
Here I put.
Deepak.
And at last I put.
Sun.
After that.
I have left this whole white space.
In this white space.
Now anywhere.
Click.
I clicked here.
So what happened here.
Inserted here.
If I want to go again.
Change this number.
Which is written here.
Fq is written.
Fqw is written.
I do.
I double click.
As soon as I double click.
What happened.
We came back here again.
And I put here.
Month.
January.
Then I put.
February.
Then I put.
March.
After that.
I put number here.
200.
400.
500.
OK.
Now I have to go back here.
That I have done.
Then I went back.
So what happened.
As soon as I click single.
It became disabled.
That is.
You can not change here.
You have to change.
Go into insert tab
Make your data visualization perfect
Now go to new slide
Now go to chart tab
Now go to placeholders tab
Now go to table tab
Now go to insert tab
Now go to columns tab
Now go to line tab
Now go to chart tab
Now go to table tab
Now go to chart tab
Now go to columns tab
Now go to table tab
Now go to column tab
Now go to table tab
Now go to chart tab
Now go to column tab
Now go to chart tab
Now go to column tab
Now go to table tab
Now go to column tab
Now go to table tab
Now go to column tab
Now go to table tab
Now go to column tab
Now go to table tab
Now go to chart tab
In this video, we will learn about standard deviation and
percentage deviation of a
chart element.
In this video, we will learn about standard deviation and
percentage deviation of a chart element.
In this video, we will learn about standard deviation and
percentage deviation of a chart element.
In this video, we will learn about standard deviation and
percentage deviation of a chart element.
In this video, we will learn about standard deviation and
percentage deviation of a chart element.
In this video, we will learn about standard deviation and
percentage deviation of a chart element.
In this video, we will learn about standard deviation and
percentage deviation of a chart element.
In this video, we will learn about standard deviation and
percentage deviation of a chart element.
In this video, we will learn about standard deviation and
percentage deviation of a chart element.
In this video, we will learn about standard deviation and
percentage deviation of a chart element.
In this video, we will learn about standard deviation and
percentage deviation of a chart element.
I have
a
I can change the style of the chart and I can change the
rows in the column and I can change the column in the row.
And then I had to select data because I had to select data.
So, look here, whatever you have been given, whatever the
name has been given, how it has been given, it has been
given in the row, you can put it in the column.
So, this is yours and at the end, you can edit the data and
you can change the type of the chart.
If I don't like the column type, then let's do the bars
type.
So, I hope you liked this video.
We have seen how the chart is inserted and we have also
seen the last option that is left, the Excel spreadsheet.
So, if you like this video, then please like it and share
it with your friends.
And if you don't understand anything that there is a
problem in this particular point, then you can play this
video again.
Or if there is any issue that is not being solved by you,
then you can comment and write, we will resolve it.
That's why we are here.
You just have to do one thing at your end, that is
practice, practice, practice.
I will meet you with a new topic in the next video.
Till then, good bye.
Did you refer an Earn program on Pure Professional?
No, I haven't.
What's it about?
Basically, if you refer the Advanced Certificate on
Advanced Accounts and Taxation course, for accountants with
3 years experience, to your friends and they sign up using
your referral code, you'll get some awesome rewards.
That sounds interesting.
For every friend you refer, you earn points that you can
redeem for discounts or even cash rewards.
And also you'll get the job guarantee after completing this
course.
Count me in. I'll make sure to spread the word.
Word to all my classmates.