Find Jobs
Hire Freelancers

Fill in a Spreadsheet with Data

$10-30 AUD

Completed
Posted over 8 years ago

$10-30 AUD

Paid on delivery
We have a spreadsheet with a two columns: client suburb, and invoice total. We would like the information to be reformatted and compiled in a new spreadsheet so that there are 3 columns: Client suburb, total revenue per suburb, and total number of jobs per suburb. So, instead of: Client Suburb Invoice Total Ex ABBOTSBURY $45.00 ABBOTSBURY $324.00 ABBOTSBURY $242.22 ABBOTSBURY $45.00 ABBOTSBURY $950.00 ABBOTSBURY $318.11 ABBOTSBURY -$318.11 ABBOTSBURY $0.00 ABBOTSBURY $0.00 ABBOTSBURY $220.00 ABBOTSBURY $45.00 ABBOTSBURY $227.27 It will be: Client Suburb Total Revenue Per Suburb Total Number of Jobs Per Suburb ABBOTSBURY $2,098.49 12
Project ID: 8972659

About the project

24 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, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 50 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.
$14 AUD in 1 day
4.8 (74 reviews)
5.9
5.9
24 freelancers are bidding on average $24 AUD for this job
User Avatar
Greetings!!! Can we discuss details about your project so that I can submit some sample entries and it will help you to understand our Quality of work and It will also help me to give you fair price and exact time frame?.Awaiting for your response..Thanks
$54 AUD in 1 day
4.9 (653 reviews)
8.3
8.3
User Avatar
A proposal has not yet been provided
$34 AUD in 1 day
4.7 (81 reviews)
6.6
6.6
User Avatar
A proposal has not yet been provided
$30 AUD in 1 day
4.4 (54 reviews)
4.7
4.7
User Avatar
Hello I have it ready. Whenever you want I can send it to you. Don't hesitate to contact me. Michael
$10 AUD in 1 day
5.0 (31 reviews)
4.3
4.3
User Avatar
Hello, I've read your description carefully and I find your project suits me. I'll work for $20 (plus $5 freelancer fee), within 1 day. I have a lot of free time now. Please tell me in detail over the chat box. Thank you.
$25 AUD in 1 day
5.0 (14 reviews)
3.9
3.9
User Avatar
Hi, I would like to use my past experience to serve you better. You can trust my sincere indulgence both in quality and time frame. If you will give me a chance, I will ensure that you're satisfied. I'm really interested in the project, since it's my area of expertise. I'm sure we can work together. I have read and understood all the requirements and thus I believe I am the best freelancer to tackle it. I will comfortably address all the issues within the given deadline. In addition, I will be keeping in touch with you regularly to update you on the progress. Regards
$25 AUD in 1 day
4.7 (3 reviews)
2.1
2.1
User Avatar
A proposal has not yet been provided
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Looks like peace of cake. I am new freelancer, I will be very thankful for every chance. Thank you for reading this.
$20 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Native fluency in English, IELTS score of 7.5/9.0. International research-level master's degree with more than seven years of professional experience gained from various multi-national companies.
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I've had 10 years of work experience and working with excel started in Primary School. As a social media manager, I use excel every day to collate data or schedule posts. The task that is needed to complete requires me to insert an additional column for Number of Jobs Per Suburb. From the example that you provided, I can collate the invoice values using the sum formula and reflect that in the 2nd column; Total Revenue Per Suburb. Highlighting the number of entries in the 1st column of the original file will churn out the value for the new column (Total Number of Jobs per Suburb). Depending on the data you have, this task can be completed in a day or less. You may contact me at my email address if you would like to discuss further. Thanks!
$20 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I can do this for you very quickly. Please contact me and I will show you a screenshot of what I have done. I can also add in formulas for you if you need them. I can make you a pivottable too or have a chart that automatically updates when you refresh the data.
$20 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have lots of experience in data entry with out making any errors.I have a advanced knowledge of spread sheet calculation which helps to make the job better
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$17 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
it's a real simple stuff to do. I can do it in a couple of minutes. I can also (if you want) insert filters so you can organize the list with a simple click in base of what kind of data you need first.
$20 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have a lot of experience working with excel and I can guarantee you a great work, you can check how the project is going as many times as you like. Thanks for considering, have a nice day.
$20 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I know exactly what you need, and I've created many types of these tables. I can have it completed for you within minutes.
$22 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I ensure FAST and ACCURATE data entry available to you within 24 hours. Please feel free to contact me. Cheers, Jack
$20 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
The experience that I have will get the job done the right way efficiently and effectively. 5 years experience of data processing and mining for supply chain department also 2 years experience as a Business Solutions Analyst and 3 Years experience as a Project Manager of IT Department. All the experience and skills gained throughout my career will deliver the customer 100% on time and effective.
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I work for a reputed company as client service executive. I have hand on experience in formatting and excel. Please assign me the project and I assure you to complete it efficiently and accurately.
$30 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am very accurate in data entry jobs. I have a lot of experience in using microsoft excel. I can finish any work assign to me as fast as I can.
$15 AUD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Pennant Hills, Australia
5.0
29
Payment method verified
Member since Jun 25, 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.