Find Jobs
Hire Freelancers

Excel Expert

$10-90 USD

Closed
Posted over 9 years ago

$10-90 USD

Paid on delivery
I have a report that analyzes sales performance of my sales team in a restaurant. I need a excel expert to design an executive dashboard, using the data that we have. The dashboard either needs to be created in a separate file, that pulls the data from the report file (as the report file changes daily) The dashboard needs to outline, in detailed colorful info-graphs, how the waiter is preforming, amongst their peers and others in the group. The report I have already gives us all of this information, I simply want to make it more relevant and easy to read for the waiter. Each waiter should have their own report, on a separate Sheet , printable onto A4 paper. So: here's my view on the work flow. 1. We get these reports emailed / linked to us every day at 11am 2. We save this report into a folder called "Waiter Reports" 3. You design a excel template, that does the following a) See's how many employees are listed in the Report b) creates a separate sheet in Excel for each employee c) inserts a dash-board that compares the employee to every one else in the restaurant, an give KPI's on sales / average spend per head etc ( we have all of this data) d) Also compares the employees amongst other restaurants in the group (again, we have this data) d) Relays the information in an easy to use, info-graphical format f) Give the use the ability to exclude or ignore certain data
Project ID: 6266259

About the project

36 proposals
Remote project
Active 10 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
36 freelancers are bidding on average $62 USD for this job
User Avatar
Hi there, I've been working with Excel since before '98 and I've been using all possible versions of it. I have years of experience working with macros and writing code / debugging Excel VBA code. You may check my portfolio images to see few pieces of my kind of work. (This is what I do on daily basis). I am a professional and I can do a very good job. Also fast and accurate. Do not hesitate to contact me for further details. Kind Regards, Jon
$90 USD in 3 days
5.0 (19 reviews)
4.4
4.4
User Avatar
I have created many excel dashboards for different clients, you can see my profile which has my excel projects with excellent reviews. I have read the below details and I can easily make this dashboard at lowest price.
$77 USD in 1 day
5.0 (4 reviews)
4.1
4.1
User Avatar
I am quite familiar with Excel dashboards,- in fact I am currently working on one for "Electricity Bill Generation ". However, I am not familiar with waiter performance criteria,- that is how a waiter is evaluated. The KPI (Key Performance Indicators) must be listed by you. You must detail all the objects which must appear on the "summary page",- how many charts and what type. The other sheets will be only data on each waiter in the sales team. I will also try to look up google to check if there are any templates for assessing waiter performance. Please message me for further discussion. Terence
$55 USD in 10 days
4.9 (13 reviews)
3.7
3.7
User Avatar
Hi Employer, I am an Excel Specialist and most of the work that I am doing involves automation using Excel Macro and VBA. I have experiences in making spreadsheets that automatically extracts data from Websites using the Web Query function of Excel. I have done several projects which uses lookup, index-match functions.
$90 USD in 1 day
5.0 (1 review)
3.1
3.1
User Avatar
I am interested to do this project. I will do it perfectly. And deliver the results on time. Please message me if any clarifications that you have before assigning me this project.
$70 USD in 1 day
3.0 (1 review)
0.8
0.8
User Avatar
I CAN FULFILL YOUR REQUIREMENT AND I AM GOOD IN EXCEL WHICH CAN HELP YOU TO IMPROVE IN A BETTER WAY AND THANKS IN ADVANCE
$66 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$55 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I can do this task for you in Excel or I can even make a small software for it if you like. DO let me know how you want the work to be done. Regards,
$80 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$55 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Proposal belum diberikan
$55 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$54 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have worked on such projects for few of clients and also worked on Excel macros, pivot tables, data filter, conditional formatting, vlookup, data validation, etc. I would like to work on this assignment. Looking forward for your valuable response. Thanks & Regards, Pravin Bankar
$55 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$55 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Propunerea nu a fost încă furnizată
$55 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Sir, We are newly established Software company in New Delhi, India with the name VisualX Business Solution and looking forward for bright future of our firm. Thus, we are in the stage where we are looking for good opportunities regardless of what we are earning as our present time is to prove good. This can only be happen if we provide excellent result to our customers and thus we think we should get a chance to prove ourself and provide excellent solutions to our customers to be in the industry. Looking forward for favourable reply and discuss details of the project. Thank and Regards Santosh Srivastava 08750947423
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I can do this job for you. I am a sofware engineer but I am not working, so I have time enought. I am motivated. Please contact me. Célia Carracha
$55 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Предложение еще не подано
$45 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I would like to do this job for my first task in freelance. You can see my portfolio for example of my work in excel. Hope to hear from you soon. Thank You
$45 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am a qualified CA professional with substantial experience of working with various firms on accounting, auditing & verification, data analysis, data entry. Proficiency of working on excel and power-point. Executing the task at a faster pace delivering better and desirable output in a meticulous manner. Have worked on other data entry, data proofing and formatting projects as well. Possess high typing speed to ensure the speedy completion of the task. Thanks
$40 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can do the dashboard as specified in your proposal. Some other matters that would aggregate some value: - I can add a summary report, where you the manager can compare the waiters performance. Or even better, it can make them compite to improve. - Are you saving historical data?, or is only daily information?. You could use trend KPI to see if someone is improving in the last week, month or year. - A good way to make the dashboard more intuitive is to have pictures of the waiters beside their stats. Best, Juan E.
$88 USD in 4 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDIA
India
0.0
0
Member since Aug 2, 2014

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.