Find Jobs
Hire Freelancers

Build an Excel Work spreadsheet

$10-50 AUD

Completed
Posted about 8 years ago

$10-50 AUD

Paid on delivery
hi - each week my sales team need to record the following for the week 1. Employee name 2. Phone calls made 3. Appointments in their diary 4. How many Deals 5. conversion rate (this is simply number 3 divided by number 2 x 100 shown as a %) 6. Clients names 7. Allocated to Adviser 8. Cancelled appointments (name of person and a reason why) Each day, they need to record the following 1. Employee name 2. Phone calls made 3. Appointments made 4. conversion rate (this is simply number 3 divided by number 2 x 100, shown as a %) 5. Deals made and the clients name I am after an excel spreadsheet which allows them to simply enter in their daily numbers and it collects it all and provides the weekly report immediately. It would nee to to be broken down by each week in the year our working week is Saturday to Friday my excel knowledge is limited so i apologize in advance other things needed 1. be able to add and remove employees from this spreadsheet as we hire more and let some go 2. be able to separate per month if needed, not just showing a total. This will help working out whats months are better 3. be able to compare the employers against each other through graphs perhaps on another tab 4. some cells locked so the staff don't change it 5. an easily accessible collection of the cancelled clients, separated by employee and month 6. easy to use Looking for someone with some creative flair to make this not only look good but be quite useful moving forward open to your suggestions
Project ID: 9427524

About the project

21 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Dear sir, Greetings. As i gone through of your work strategy(including other team members) and the expected mechanism, excel won't be able to cover all of those aspects in a smarter way. As you are open to suggestion, MS Access would be the best solution. It's easy to use and control. Have all of those features including individual and admin login(password protected), smart reporting and many more. Plz let me know if you feel interested and then i would design a basic MS Access apps for you. Thank you. Sincerely, ahmsuza
$50 AUD in 1 day
4.8 (151 reviews)
6.4
6.4
21 freelancers are bidding on average $41 AUD for this job
User Avatar
Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 270 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$100 AUD in 7 days
4.9 (143 reviews)
6.3
6.3
User Avatar
Hi, I am happy to provide u the solution. But, the total can;t be addressed with the budget specified. So, i would like to offer my services step by step to make it in comfortable flow. Looking forward to work on this project. I would like to discuss in detail.
$54 AUD in 3 days
5.0 (135 reviews)
5.9
5.9
User Avatar
A proposal has not yet been provided
$100 AUD in 3 days
4.9 (64 reviews)
5.8
5.8
User Avatar
Hi, I have read your posting job carefully. I am looking for a job like this. I can do your job perfectly and also assure you that my work will be 100% satisfied to you.
$45 AUD in 1 day
4.9 (64 reviews)
5.3
5.3
User Avatar
Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 55 projects, almost 45+ are complex VB/VBA projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VB/.NET, SQL, MS Office, Access/Excel/Word, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.
$30 AUD in 2 days
4.9 (54 reviews)
5.4
5.4
User Avatar
its not a small job. though i have experience of doing same sheet for a company OSIM Pakistan. its a health and fitness product sale company. i will give u employes name drop down and u can add employes in it to add it in drop down. and also i will list a summary of the entries made. 1 thing need to be cleared assigned to adviser is it a chain reaction of just 1 advisor?
$45 AUD in 1 day
5.0 (9 reviews)
3.7
3.7
User Avatar
Hi, I built and I use this kind of excel tool. I can build yours. Please contact me for further détails of your project. Thanks!
$35 AUD in 1 day
4.6 (10 reviews)
3.8
3.8
User Avatar
I'm the man look at my profile
$30 AUD in 1 day
5.0 (5 reviews)
2.4
2.4
User Avatar
I can make the excel sheet for your need. I have been working with excel at my university too. please offer this job to me and you will have nothing to worry about. you can see more details about myself from my profile. please leave feedback after completing the job. i can reduce the bid if you want.
$35 AUD in 4 days
5.0 (2 reviews)
0.7
0.7
User Avatar
hello sir, I have 5 years of professional data entry exlerience with all the required skills. I hope you would like to work with me on this project.
$25 AUD in 1 day
5.0 (1 review)
0.5
0.5
User Avatar
HI . . . . I am really intrested in your project and able to done this in limited time. thanks
$20 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
hello sir i am a stay at home mom I have been working as a mechanical engineer for 6 years now . I am also expert in MS word and MS excel. Hope you're interested in hiring me .
$35 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have plenty of free time for this job... Efficiency and completion on time will be ensured...Hard work will be visible in results
$15 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I challenge that nobody here on freelancer is much more qualified than me for this job. I have 3 years experience and got promoted up to Sr. Project manager level. My aim is to complete the given task on time and error free. That's all i have to say. Thank you Sir
$33 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
i will do work based on the your requirements and also i have 5 years experience to handling of documentation work.
$35 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Soy atento a las indicaciones dadas, muy comprometido con el trabajo, tengo buenas relaciones con las personas que necesiten de mis conocimientos y llevo a cabo cada proyecto con orden y responsabilidad
$55 AUD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i have experience in database, office program and i worked in a similar position in a bank for one year.
$40 AUD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have overall 10 yrs of exp in developing apps in exçel n access etc.. I will be able to develop a small app in exçel for you.
$25 AUD in 4 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Sydney, Australia
5.0
13
Payment method verified
Member since Feb 5, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.