I need a microsoft excel guru to make a sales tracking template
- or -
Post a project like this2545
$$
- Posted:
- Proposals: 21
- Remote
- #1525373
- Awarded
PowerPoint Template design | Brand Identity | Logo Design | UX design | Print design | Website design
Houston
Microsoft Certified Power BI Data Analyst & Advance Excel Specialist¦Professional Power BI consultant ¦ (ACCA)- Chartered Certified Accountant ¦ Accounting- Reconciliations ¦DAX ¦Data Models ¦
Doha
3652751621539342247159691715931991581896150629814782581467017145645914150951406416
Description
Experience Level: Intermediate
Hello Freelancers
I’m looking for a freelancer expert in Microsoft Excel of create a template to track sales progress for each of the 10 customer categories we sell to as well as yearly sales over the 2017/2018 financial year.
I have attached a sketch of some ideas I had.
The freelancer awarded to job will need to take the following points into consideration.
1. This template is to track % of sales received. I want to stay away from displaying the $ figure. I understand that the formulas will need to take into consideration $ values.
2. The graph will also need to show our last year total for each customer category.
3. The template needs to be very user friendly
4. The graph needs to look clean and uncluttered.
5. The graph will be displayed on a 65-inch screen for all staff to see.
6. I would like this project to be completed within 3 weeks.
I’m looking for a freelancer expert in Microsoft Excel of create a template to track sales progress for each of the 10 customer categories we sell to as well as yearly sales over the 2017/2018 financial year.
I have attached a sketch of some ideas I had.
The freelancer awarded to job will need to take the following points into consideration.
1. This template is to track % of sales received. I want to stay away from displaying the $ figure. I understand that the formulas will need to take into consideration $ values.
2. The graph will also need to show our last year total for each customer category.
3. The template needs to be very user friendly
4. The graph needs to look clean and uncluttered.
5. The graph will be displayed on a 65-inch screen for all staff to see.
6. I would like this project to be completed within 3 weeks.
Ted D.
100% (1)Projects Completed
2
Freelancers worked with
2
Projects awarded
100%
Last project
23 May 2017
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Ooopps, that should say worksheets!
-
That's clever Ted, I've never seen squared wirksheets captured like this on a Pdf.
In terms of analysing data the only complication can be the amount of data to be processed. Could you kindly detail approx. how many lines of excel or its equivalent the raw data to complete this from consists of?
382578381819
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies