Welcome to our free Intermediate Microsoft Excel tutorial. This tutorial is based on Webucator's Intermediate Microsoft Excel 2019 Training course.
Working with tables in Excel 2019 can help you organize your data. In Excel, you can group data together into a table and then manipulate that table.
To format data in Excel as a table:
When working in tables in Excel, you can select cells and cell ranges as you would within a worksheet, by clicking to select a cell and clicking and dragging to select a worksheet.
However, to select rows and columns in a table, you need to click the left edge of the row or the top edge of the column, respectively, when it turns to an arrow.
You can modify Excel tables in a number of different ways.
To insert or remove rows or columns of cells within a table, select the row or column to be removed, right-click, and select Insert or Delete.
To change the style of a table, from the Table Tools Design tab, select an option from the Table Styles group.
By default when you create a table in Excel, titles are created by default; headers are turned into titles.
To turn this feature off, from the Table Tools Design tab, in the Table Style Options group, uncheck the Header Row check box.
You can band rows and columns in an Excel table. To do this, select the Table Tools Design tab and in the Table Style Options group, check the check boxes to band rows or columns.
When you select the Total Row checkbox on the Table Tools Design tab, Excel adds a row at the end of your table showing the totals of the data in your columns.
You may want to remove styles that you applied to your Excel table.
To remove styles, select the Table Tools Design tab and in the Table Styles group, select the arrow to view more options, and then select Clear.
In this exercise, you will create an Excel table and modify it.