The final adjustment you should make in the Table Design tab is to give your table a name. By default, Excel tables are called Table1, Table 2, Table3, and so on.

Add banded rows and columns to your table by going to the "Design" tab and then the "Table Style Options" group.

Your data will be converted into a table, with default formatting applied. You can customize the table style from the Table Design tab.