![phoenix](https://d1a29h5kxv3oc2.cloudfront.net/dist/img/phoenix.81914efc7207f6a059bd10f5d3fd5f89.png)
Excel / VBA Expert Required
- or -
Post a project like this3418
£50(approx. $64)
- Posted:
- Proposals: 17
- Remote
- #690368
- Awarded
Lead Generation,Data Analysis,Data Visualization,Dashboard,LinkedIn Leads,Market Research,MS Excel,Google sheets,Web Research,CRM/CMS,Google Ads,PPC
![Top Seller with earnings over £100k Top Seller with earnings over £100k](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/6848fd9e0514ae9277cce59806b79dc5.png)
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
6652665996818764988746098791084893652992195397486495443720849746800218
![Simon P.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/add6ce030a9b86d7954c8944708b94c7_70x70.jpg)
![Pete R.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/cda2925c4e06bd658f4b30e4f4ea088e_70x70.jpg)
![Justin B.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/876498_70x70.png)
![Daniel D.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/8c3309456c2055018f2c290c89dd7663_70x70.jpg)
![Dave G.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/cc73ddcd994a97c74371d3870189217f_70x70.jpg)
Description
Experience Level: Intermediate
Estimated project duration: less than 1 week
Description of excel work: - I receive weekly statistics on my staff performance, I would like to be able to put them into a spreadsheet and it deliver a report for me offering options to produce graphs, flag low/high statistics within the group (and based on previous trends) and compare them against each other.
- I need an weekly entry point for the stats, this is the data I will be inputting, everything else is extrapolated from this, mainly just totals and ratios. These are the data input fields
Contact Calls spoken to
Contact Calls not spoken to
Applicant calls spoken to
applicant calls not spoken to
Contacts
Apps
CVs
Marketing No.
Marketing Emails
Interviews
Deal No.
Deal Value
I would like to be able to enter data for each person and be able to do the following automatically:
- Produce totals and ratios - open ended - this is not for a finite time, these records will progress for as long as the people are working
- Produce data and graphs showing trends on a weekly, monthly and all time basis (easily with a button click)
- Be able to compare people against other people, both with data and graphically, and weekly, monthly and for all time.
- Highlight highest stats, best ratios, upward trends, lowest stats, worst ratios, and downward trends.
- Look good enough to produce print offs for staff to look over
I have the data up to a point and can send to use as a template. Budget listed below is an example, please quote me what you think fair.
Extra notes: More work available following this task
- I need an weekly entry point for the stats, this is the data I will be inputting, everything else is extrapolated from this, mainly just totals and ratios. These are the data input fields
Contact Calls spoken to
Contact Calls not spoken to
Applicant calls spoken to
applicant calls not spoken to
Contacts
Apps
CVs
Marketing No.
Marketing Emails
Interviews
Deal No.
Deal Value
I would like to be able to enter data for each person and be able to do the following automatically:
- Produce totals and ratios - open ended - this is not for a finite time, these records will progress for as long as the people are working
- Produce data and graphs showing trends on a weekly, monthly and all time basis (easily with a button click)
- Be able to compare people against other people, both with data and graphically, and weekly, monthly and for all time.
- Highlight highest stats, best ratios, upward trends, lowest stats, worst ratios, and downward trends.
- Look good enough to produce print offs for staff to look over
I have the data up to a point and can send to use as a template. Budget listed below is an example, please quote me what you think fair.
Extra notes: More work available following this task
![Alex L.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/18bf38e9a5b654e6025d988666b48727_150x150.png)
Alex L.
100% (90)Projects Completed
84
Freelancers worked with
76
Projects awarded
43%
Last project
10 Jun 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
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