En cours

I would like to hire an Excel Expert

We are a sales company for media equipment for the TV industry. We'd like to do an ABC analysis of our customers in terms of sales volume and margin. I have a xls file with hundreds of single invoices data rows including customer no., date, revenue and margin. It is possible that a single customer is mentioned in many rows, if he bought several times.

What we want to get is an accumulation of the of sales volume and margin of each customer. The result should be like this example: [url removed, login to view] (sorry, German picture). Column A ist cutsomer no.; column B is customer revenue (the whole table is sorted by that column); column C is sales revenue in percentage of the overall revenue; column D is an accumulation in percentage and column E is the ABC classification segmented by class A does 75% of the revenue; class B does the next 20% and class C does the last 5% revenue. I hope thats understandable.

The job should be completed by the 8th of January.

Compétences : Excel, Ventes

Voir plus : need excel expert on hire, ms excel expert for hire, microsoft excel expert for hire in atlanta ga, excel expert for hire sheffield, excel expert for hire melbourne, excel expert for hire las vegas, excel expert for hire in delhi, excel expert for hire, i have 1 question for a amazon expert for hire, excel expert sg hire, excel expert on hire, expert excel vba, data analysis excel hire, expert excel macro, become expert excel modeler

Concernant l'employeur :
( 1 commentaire ) Hamburg, Germany

N° du projet : #12683808

Décerné à :

vlayausa

Hello, I am proficient with Excel and VBA and I would love to help you with this project. Please contact me for more information.

35 € EUR en 1 jour
(87 Commentaires)
5.3

8 freelance ont fait une offre moyenne de 25 € pour ce travail

khushh07

Hi, I understand the project requirements and willing to start as soon as possible. Kindly share the details and I will deliver with high quality. Looking forward to work with you. Thanks & Regards Khushi India

28 € EUR en 1 jour
(211 Commentaires)
6.8
23 € EUR en 1 jour
(24 Commentaires)
4.9
AmmarHafeez

Hi.. I am a python developer and have done tasks involving excel files using python.. I have checked the description and what I got is that you need to accumulate the record by customer number and change the revenue an Plus

30 € EUR en 1 jour
(8 Commentaires)
3.2
himanshu9us

I am proficient in using MS Office tools having working in the banking industry for more than 10 years.

15 € EUR en 1 jour
(1 Commentaire)
1.8
omarhayatgondal

I am basically a typist/computer operator/office assistant and having 25+ years of experience of professional data entry of all kinds with Local and International Firms. I fully read the Terms and Conditions of your pr Plus

20 € EUR en 1 jour
(3 Commentaires)
1.0
23 € EUR en 1 jour
(0 Commentaires)
0.0
23 € EUR en 1 jour
(0 Commentaires)
0.0