Sales Data Analysis

[Ehtisham Ali]

Hi All,

Here is a sample data of sales in a shop.

It is an automated machine generated data so it is again a challenge to deal with it in Excel.

Details of analysis required are given in workbook itself.
Try your hands on it...

Regards
Ali

 

[Hui]

Ali

It is quite clear that this is for an assignment

The purpose of assignments is for you to research and learn new techniques and ideas

I'd suggest you put the data into a pivot table
That should allow you to answer most of your questions

use the main help to find posts on Pivot Tables

 

[Ehtisham Ali]

Thanks Sir,