Excel Sales Report Needed
- or -
Post a project like this38
$150
- Posted:
- Proposals: 22
- Remote
- #3162843
- Awarded
Professional Freelancer - Excel Formula, Macros, Google Scripts, Charts/Graphs, Google Sheets, Google Docs, Zapier, IFTT, HUBSPOT

ACCA Certified Accountant of UK & Australia, Excel, Power Point, Xero and Quick Book Expert.

Logos I Brochures I Flyers I Business Cards I Company Profiles I Websites I Mobile & Web Apps I Virtual Assistance

230479519564295424927264240649044112753154183904714297133584762547384035604423873491



Description
Experience Level: Entry
We’re looking for an excel expert whom can generate for us a great Product Sales Report out of current “dumb” sheets.
The files we will give you are all daily products orders ( by product name only )
We will need you to take all of these files to generate 1 big product report that will show us the products sorting by sales Percentage, in couple of way of product breakdown ( we will explain in full once project starts.
All in all these “dumb” sheets has data which we need to translate into an actual reporting working data to understand our product breakdown better.
We need this project to be completed within 96 hours maximum, so there is a big urgency here.
What you will recevie from us, is an Excel file that has 60 days of data ( the only available data in this excel file is the product name and quantaties ) , each row in the excel file represent a product and equal to 1 unit...
All in all there about 15,000 rows of simple data to scrap and to produce an actual report from.
The final report should give us the following:
Products Sales in precentages Product X = 20% of sales, Product Y =33% of sales etc. )
Product total Quantaties
that's all....
We will generate 2 different reports as for 2 different sales outlooks.
The files we will give you are all daily products orders ( by product name only )
We will need you to take all of these files to generate 1 big product report that will show us the products sorting by sales Percentage, in couple of way of product breakdown ( we will explain in full once project starts.
All in all these “dumb” sheets has data which we need to translate into an actual reporting working data to understand our product breakdown better.
We need this project to be completed within 96 hours maximum, so there is a big urgency here.
What you will recevie from us, is an Excel file that has 60 days of data ( the only available data in this excel file is the product name and quantaties ) , each row in the excel file represent a product and equal to 1 unit...
All in all there about 15,000 rows of simple data to scrap and to produce an actual report from.
The final report should give us the following:
Products Sales in precentages Product X = 20% of sales, Product Y =33% of sales etc. )
Product total Quantaties
that's all....
We will generate 2 different reports as for 2 different sales outlooks.

Roy L.
100% (26)Projects Completed
30
Freelancers worked with
29
Projects awarded
25%
Last project
7 Apr 2021
Israel
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Can you give me a sales report template so I can figure out how to do it?
970688
We use cookies to improve your experience and our services. By using PeoplePerHour, you agree to ourCookie Policy