Generate simplified data from RAW data

Posts
1
Registration date
Tuesday October 16, 2018
Last seen
October 16, 2018
- - Latest reply: TrowaD
Posts
2440
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 13, 2018
- Oct 16, 2018 at 11:41 AM
Hello guys,
i need help to create some magic from excel.
I am a marketer for a F&B, and right now i am in the mid of trying to generate some precious, juicy information from our customers' purchasing behaviour. I know it might be possible using excel, but I have no idea how to.
The situation goes:

what i ultimately look for, is a big chunk of table that can generate all sort of conclusions base from my raw data. for example:
how many people order a food, AND order a drink.
While how many people order a food, AND not ordering a drink.

If i can see a deeper breakdown like,
food A, 50% of the time customer also buy a drink,
food B, only 10% of the time customer also buy a drink.
that would be great.

My raw data that is available to use:
1. order number
2. order timing
3. type of food ordered
4. quantity of each food ordered

A thousand thanks in advanced!

See more 

Your reply

1 reply

Posts
2440
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 13, 2018
0
Thank you
HI Damonlin,

With the limited amount of data you provided I can only advise you to dive into Pivot Tables. They are meant to analyse data.

To get you started have a look at the following link:
https://exceljet.net/things-to-know-about-excel-pivot-tables

Best regards,
Trowa
Respond to TrowaD