Placeholder Image

Subtitles section Play video

  • Here's how to make a table in Microsoft Excel.

  • A table is a specific set of rows and columns that you can apply functions to, such as adding filters, formatting or creating graphs.

  • Let's turn our buying report for our fashion.

  • Start up into a table.

  • First, highlight the cells you want to add to your table.

  • Click on insert, then click on table.

  • If your cells include headings, check the my table has headers box, then click OK, your cells will now be turned into a table.

  • Yeah, on the top right corner of the screen.

  • Under the table section, you'll see a Siris of colored designs.

  • Choose the one you like, and you'll see your table change.

  • You can expand the size of your table by amending the number of columns or rows in it.

  • To do this, hover your cursor over the bottom right corner of the table on click and drag the black narrowed square across the columns or rows.

  • You want to be added to your table.

  • The sort and filter features on tables helped organize your data.

  • Click on the drop down arrow next to one of the headings.

  • A pop up will appear next two sorts.

  • Click on Ascending.

  • The table will now be arranged in ascending order of retail prices.

  • Now use the filter function by uncheck ing, one of thes boxes.

  • This will hide all the items on the table that are $182.50.

Here's how to make a table in Microsoft Excel.

Subtitles and vocabulary

Click the word to look it up Click the word to find further inforamtion about it