Find Jobs
Hire Freelancers

Analyze some Data and Generate Excel report

R210-1750 ZAR

Closed
Posted almost 9 years ago

R210-1750 ZAR

Paid on delivery
Hi, I want to create some reports on the attached data , it is important that I must be able to generate my own reports every month, in a user friendly, good looking way out of the data sheet in the attached file. Every Sheet in the attached consists out of a list of customer names and each one's turnover for that specific period ( see the sheet name for the date range). The main purpose of this excercise is to compare the turnover for each customer for a specific date range with the previous period. The report must contain information like: The customer with the Highest turnover for X date range, customer with the biggest difference in turnover in comparison with its previous date range, compare turnover for a specific customer over a specific period, etc etc etc etc. Its important to provide me with your suggestions in terms of outlay and presentation of the above. Further , it is of outmost importance that the " report sheet" will update automatically if next months data is added. The above is straight forward and should give you a good understanding of what I am trying to achieve. For any questions do not hesitate to ask.
Project ID: 7688244

About the project

34 proposals
Remote project
Active 9 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
34 freelancers are bidding on average R946 ZAR for this job
User Avatar
A proposal has not yet been provided
R1,000 ZAR in 2 days
4.9 (174 reviews)
7.0
7.0
User Avatar
Dear Sir/Madam, I'm happy to help you on this task. I went trough the attachment and I'm 100% sure that I can develop a perfect dynamic model for you. I am an expert in advanced excel features and have a strong financial background. Further, I have already developed lots of such dynamic excel based models for various clients and businesses. You can visit my profile to see my qualifications, experience and reliability, and if you are comfortable with those, I am ready to start this project. I assure you that I will go beyond your expectations. I look forward to hearing from you. Best regards, Priyal
R1,500 ZAR in 3 days
5.0 (142 reviews)
6.4
6.4
User Avatar
Hi: Please note that I have 100% completion rate and 5-star feedback on all projects (>50 total completed projects). More than 90% of my completed projects are related to Excel and macro. Please check my profile to confirm the quality of my work. Please connect with me to discuss more
R1,000 ZAR in 5 days
5.0 (55 reviews)
5.6
5.6
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards
R1,944 ZAR in 3 days
5.0 (47 reviews)
5.3
5.3
User Avatar
Hello, I'm an Excel expert and I'd like to help you with your project.
R1,000 ZAR in 3 days
5.0 (50 reviews)
5.4
5.4
User Avatar
Hi, We are experts in Excel based reporting. We understood your requirements throughly. Here is what we can provide you. 1. An interface to enter the current period and previous period 2. once you click Run, it creates the reports to compare two periods interms of volums for each. Secondly it ranks all based on their values. 3. The whole thing will be dynamic. Hence you put the dates of periods at the begining and get the report run. We can send a dummy design to start with and once you agree with the report formats we can start the actual work. Kindly let us know. Regards, Pal
R889 ZAR in 5 days
4.8 (12 reviews)
4.7
4.7
User Avatar
Hi, My name is Dan. I am an expert in excel and all advanced functionalities. I can do the required reports and also have them dynamically update when you insert a new month's data. I believe if you change the naming convention of each date range sheet names (say if you avoid spaces), it will be easier to implement this process. Please message me so that we can proceed further. Thanks ! Regards Dan
R1,333 ZAR in 3 days
4.9 (10 reviews)
4.3
4.3
User Avatar
Nie złożono jeszcze oferty.
R1,000 ZAR in 3 days
5.0 (10 reviews)
4.0
4.0
User Avatar
Dear Hirer Manager, I am experienced in Web Search, Data Entry, Excel.I am ready to give you accurate work. My work will help you to complete your project. Thanks
R555 ZAR in 3 days
4.3 (8 reviews)
3.0
3.0
User Avatar
A proposal has not yet been provided
R1,088 ZAR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear sir, I am very interested for this project and I can do this project , i work with my expert team who always looking for such type of project . so please sir give me one chance to prove my strength and quality of work. sir i am new in freelancer but not fresher so please sir give me this opportunity for doing this project. sir money is not a matter i only want to do this project if you feel good for my work then after you awarded me and pay for this project , me and my experienced team believe in accuracy and quality of work. Trust me sir i never disappoint you at least you can give me one chance. Thanks & Regards Mohit Dubey Visiesoft Technology
R1,400 ZAR in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I think I am fitting this task, so kindly accept my request as I am experienced in Excel and formulas, so I will be appreciating your concern. Thanks you.
R1,088 ZAR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
R1,088 ZAR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
heya, happy to further discuss your instructions and the delivery timeline. hope to hear from you :)
R260 ZAR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
R1,088 ZAR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
R1,088 ZAR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I am interested about this project and wish to take this opportunity to serve myself. I have seen your data sheet and made some plan already how to make it a fruitful report for you. For instance,for the report sheet it will be good to make a power pivot for analysis and visualize data with time range options.I can make further analyze and graphs for the data set. if you wish I'm making a sample for you to review and hope you will like. I can even make some small analysis about your trend of business with the customers listed. I need some discussions about it to make it successful. Please reply me a message to discuss. Thanks for trusting me and my capabilities. Have a nice day. Kind regards Biplob Biswas
R778 ZAR in 1 day
4.8 (1 review)
0.0
0.0
User Avatar
Hi, I am very good at using excel and word processing. So I am 100% sure that I can do the job according to your criteria. I am looking forward to you.
R719 ZAR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
R1,088 ZAR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
R1,111 ZAR in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SOUTH AFRICA
Pretoria, South Africa
0.0
0
Payment method verified
Member since May 22, 2013

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.