Use Excel to create a simple dashboard on the Boston House Price dataset

In my last blog post I used Excel to perform an analysis of the Boston House Price dataset, and that blog post can be read here:- https://medium.com/@tracyrenee61/use-excel-to-analyse-the-boston-house-price-dataset-f5072cc4a7af

In this video I intend to use my rudimentary skills in Excel to create a dashboard for the dataset.

In order to make a dashboard, it is necessary to analyse the raw data and convert it into a table by clicking onto the Format as Table icon in the Home ribbon:-

When the table is created, the user will be given the option on what format he would like his table to take, as seen in the screenshot below. The user will also be given an option to give the table a name:-

It is necessary to create pivot tables on the relevant table data, so in the Insert ribbon the PivotTable icon must be selected. The pivot table should be made on a separate page in the workbook:-