It is really nice that Excel can be used to analyse datasets because most businesses have Excel as a standard software package that is installed on most computers.
I have obtained a sales dataset that had five questions associated with that dataset and have endeavoured to use the tools in Excel to answer those questions.
A screenshot of the dataset can be seen below:-
The first question is what is the total revenue generated by the store.
This is a rather straightforward question because, according to the investopedia website, revenue is sales. The only thing that I needed to do was to use the SUM() function to total all of the values in the Sales column of the dataset:-
The second question asked which category contributes the most to sales.
In order to answer this question it is necessary to create a pivot table and then a pivot chart of the Product Category and Sales columns of the dataset.
The pivot table is created by clicking on to the PivotTable icon of the Insert ribbon:-
