Create an excel spreadsheet that has pivot tables included to determine the amount spending from a particular customer in the last 3 years. It needs to also be able to provide filters that will show a particular product, product group, who has spent the most on a particular product group etc. It will also need to show the margin percentage and a graphs showing the customers buying pattern as well as what products they are buying the most or what they have not bought in a while. We need this done ASAP. ALL APPLICANT MUST BE AN EXCEL EXPERT! A background in Statistical and Reports Analysis would be highly advantageous.
We are also looking for a person that will do all our future excel projects reports. We want someone who has excellent knowledge in excel as well as doing reports.