excel table

How to create a dynamic table in excel to summarize data

Creating a dynamic table in excel

In this example, we will be creating a dynamic table in excel from a dataset. The dataset has 3 columns out of these three 2 are categorical values while the third is numerical. Now we wanted to create a dynamic table that will have these two columns as rows and columns. Also, we wanted to summarise our data by as count of entries of these two categorical columns. Dataset is illustrated in the below image.

Creating a dynamic table in excel
Creating a dynamic table in excel

To create this kind of excel dynamic table we will first convert our dataset into the excel table. You must be wondering why we are converting this into the table, this is because … Continue Reading

Table in Excel: How to create excel table step by step by 2 methods

How to create excel table

Table in excel is a powerful feature that helps us in organizing our data by grouping data together. It is very quick to create a table in excel by just clicking a few keys or using a shortcut key and converting your flat data into a table with a lot of benefits.

The benefit of using excel table is as below but it is not limited to these only:

  • Clean Formulas : When we are using excel table feature then it become very easier to read forumals even it is very complicated.
  • Referencing a range : It is very easy to reference a range as every table has its own name.
  • Auto expand : It
Continue Reading