Microsoft Excel 32 Inserting Tables

SimpleTutorials

Microsoft Excel is a powerful spreadsheet application used for organizing, analyzing, and visualizing data. In this course, you will learn the essential skills you need to get started and become confident in using Excel.  In this video lesson, we will learn about Inserting Tables in Microsoft Excel  You can access the entire Microsoft Excel Course in the following playlist: https://www.dailymotion.com/playlist/xa9hyw

Transcript

00:00So over here, you can see that I have these particular contents right here in cell. And

00:12these are just there inside of cell and does not actually look like a table data. So I can

00:18actually go around over here and add in borders. And it does look like a table, but it does not

00:24fully behave like a table yet. So if you want to go ahead and insert our table for these selected

00:29data, you can simply go ahead and select it like this first. And then what you can do is you can

00:35go around over here onto insert. And once you do that, you can see that table is an option. Simply

00:40go ahead and click and then it confirms you the table range right here, the data range for the

00:47table data, as you can see right here. So you can go ahead and press OK. And now it behaves like a

00:52table and it's formatted as a table as well. So if I were to go around over here, I have deselected

00:58out the data. But if I were to select out any of the table formats right here, you can see that

01:04it actually goes ahead and applies that particular table format. You can enable and disable the header

01:10row right here. You can also add in a total row. As you can see right here, you can add in banded

01:15rows, first column right here, you can go ahead and then highlight it out and even highlight out the

01:21last column and the band out the columns as well. And you can see that you can enable and disable

01:27the filter button as well for the table. So you can also remove out duplicates, convert reins, and

01:33you can see that you can add pivot tables and so forth. So you've got all of these options right here.

01:38And you can even go ahead and then resize out the table as you want right here and add in a table name.

01:45Let's say for example, I'm going to go around and name this as sample data right here, just like this.

01:50The table has been renamed. Whenever you rename out the table, make sure that there's no space. Otherwise,

02:00it won't accept it. So this is what you have right here for the table. And you can also go around over

02:05here. And with the filters, you can also go around over here and select out certain filters that you want,

02:11press OK, and that will be filtered out just like that. So if I were to go around over here onto the salary as well,

02:17you can see that you can select a particular salary range, and that is how you can simply go ahead

02:22and filter out the table as necessary. So that is how you can go ahead and create and use out tables

02:29inside of Excel. So if you found this video useful, be sure to hit the like button.

02:35Don't forget to share this out with your friends and families. And for more contents like these,

02:41do follow simple tutorials.

Category

Transcript

Be the first to comment

Recommended