Excel Tables:
Generally, Excel tables are used to manage and analyze the huge data in spreadsheets. It can convert a list of data into the formatted Excel table to make our work easier. It has many features like formatting, editing, filtering, and sorting. These features help us to organize the data.
Let’s jump into this tutorial and learn how to create the Excel Tables magnificently using various options provided in Excel 365.
How to Turn the Data into a Table?
First, you need to enter the data in the Excel spreadsheet to create a table.
- For Example, Here, we are going to create a table with Employee details. To do this, you have to include the details like Employee id, name, age, salary below.
Employee Details
- Now, you have to turn the data into a table.
- Select any cell in the data range.
- On the ** Insert** tab, select Table under the table selection command.
- Check if your entire data range is selected or not.
- Check My Table has a headers box.
- Hit the Ok button.
Now, the data are turned to the table format and it will give the result like below.
How to Name and Style the Table?
To add name and style to the table, follow these steps:
- Go to the Table Design tab. ( this tab is visible when the cursor is on the table cells )
- On the Properties tab, type the table name and click Enter key.
- On the Table Styles tab, select any style and click Ok.
Name and style the table
That’s it, and we have given the name and style to the formatted table.
How to Add Summary Statistics to the Table?
Here we are going to see how to add summary statistics to the table. Summary statistics are beneficial to reduce our manual work because you don’t need to type individual functions like sum, mean, average. So we can easily make these kinds of calculations.
To do this, you need to follow the instructions given below.
- On the Table Design tab, Check the Table Row option under the Table Style Options.
- At the bottom of the Total table, the row has been created. Select any summary formula from the Drop-down List as per Your wish.
Add summary statistics to the table
How to Sort and Filter the Table?
To Sort and Filter the data in the table, you have to do the following steps.
- On the Table Design tab, check the Filter Button.
- Sort and Filter Toggles will add to each heading in the table.
- Click the Toggle in any one of the headings to use the Sort and Filter Menu.
Sorting and filtering the table
Note:
You can use CTRL + T shortcut keys to create a table in Excel.
Closure:
This tutorial clearly understands the Steps to Create a Table in Excel 365 using various options. Kindly share your feedback in the comment section. Thanks for visiting Geek Excel. Keep Learning!!
Top comments (0)