Another way to manually add a table of contents in Excel is by using the Hyperlink Function. In this method, you need to type all the names of your sheets and add hyperlink formulas to each one ...

Go to Insert > Table. Confirm the range in Create Table window. Again, select the same rows and columns. Go to Insert and add a chart. So first, you need to convert the data into a table.

A pivot table is a useful tool in data analysis that can give you an overview of your data. We'll show you how to create one in Excel and Google Sheets.

Simply highlight your table, then go to the INSERT ribbon and choose Pivot Table. A Create PivotTable dialogue box will open to confirm your data source and where you want the Pivot Table generated.