Find Jobs
Hire Freelancers

Build an Excel Spread Sheet to track Sales Goals

$40-100 AUD

Completed
Posted over 4 years ago

$40-100 AUD

Paid on delivery
I require a basic Excel spread sheet to track sales data over the 2020 calendar year on a fortnightly basis. The file 2020_GoalTracker provides an example of the layout and required fields for the new spread sheet. The second file (Copy of WIP) is a previous Excel workbook that we have used to track sales data to provide an idea of what we are after. Required : - all fields in red need to accumulate each fortnight - date column needs to be fortnightly and end at or close to 31/12/2020 - The Targets listed across row 5 all need to be adjustable and feed into the lower tracking categories ie if i changed L5 to $550,000, C26 would need to auto-calculate to $21,153 and accumulate going forward - The spreadhsheet needs to look modern and user friendly, you can add your own ideas, colors, concepts to make it work (company logo colors and design cannot be changed) I can be contacted anytime for further info. Nick
Project ID: 23469964

About the project

23 proposals
Remote project
Active 4 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
Hi there, There are four cells (column C) that are linked or dependent to the fields in the target (row 5). After that these targets are doubled fortnightly. We can locked these cells after nesting the formulas in it to prevent the from any incidental typing. Furthermore, can you tell me how are you populating the other fields that are not highlighted by red, are you doing it manually or from another data sheet. Please allow me to help you with this project. -Reggie
$80 AUD in 2 days
5.0 (45 reviews)
5.4
5.4
23 freelancers are bidding on average $68 AUD for this job
User Avatar
Hello Sir Im excel VBA macro and formula Expert :) i can help you to build an Excel Spread Sheet to track Sales Goals please ping me now for discuss more and im free now Sir Thank you Galih :)
$100 AUD in 7 days
4.9 (412 reviews)
7.6
7.6
User Avatar
Hi Hiring manager I have read your all given information in description and i am ready to do various type of work for you and available 24*7*365 for you. 1* I can do Data RESEARCH from any platform for certain subjects. 2* I can create the accurate DATABASE (EMAIL/CONTACTS/PERSONAL INFO etc*. 2* I can properly fill a Google Sheet/EXCEL/WORD. Have good working skills of Excel/PDF. 4* I am Expert in DATA ENTRY and do any kind of that work. 5* I can Find data from INTERNET RESEARCH/ WEB SCRAPING. 6* I can Work as a VIRTUAL ASSISTANT for daily any kind of task. 7* I can work as per client TIME ZONE if they want and provideS 15hrs services in a day. 8* I have 3YRS of good experience of as a VIRTUAL ASSISTANT and done various type of task. 9* I have the excellent skill of SEO/DIGITAL MARKETING/SOCIAL MEDIA MARKETING/MANAGEMENT. 10* I can create MEMES/posting,strategy for increasing likes,followers of social media. 11* I have expertise in WORDPRESS sites creating/product Uploading/WOOCOMMERCE. 12* I have Good skills in SHOPIFY, PRESTASHOP, MAGENTO etc for DROPSHIPPING. 13* I Can Write Optimized SEO friendly impressive articles for BLOG and get 1 rank. 14* I am fast Learner. Grab The instructions from client instantly and implement. 15* I can get 100% results and Give Guaranteed work satisfaction from client instructions. for work i am always available and take the challenges and never say no to work always be ready and be professional in work. thanks
$100 AUD in 7 days
4.9 (64 reviews)
6.2
6.2
User Avatar
Hello, Dear Sir/Madam, You can see my profile I do have the relevant skill and can provide you up to the mark services within the time frame mutually agreed. Thanks & Regards Muhammad Ilyas Saeed
$40 AUD in 7 days
5.0 (115 reviews)
6.3
6.3
User Avatar
Hi Good Day! A serious freelancer here. Please allow me to help you. I can make it automated using VBA Macro. I've done a lot of Reports and Templates using MS Excel. I can use my expertise in VBA Macro do it quickly and accurately. Message me anytime to discuss. I am a Project Management officer for 8 years in Accenture and Project Manager now in Appen Philippines. I do financial reports and budget forecasting for our Clients. I have all the ability to help you. Please consider my bid. With my experience as a VBA Macro developer for 8 years I can give you the high quality tool that can generate accurate result that you wanted using MS Excel. Please message me anytime to discuss more about this project. I am willing to help you out and show you my expertise. Thank you!
$100 AUD in 3 days
4.7 (76 reviews)
5.4
5.4
User Avatar
I am Sumit Choudhary. I saw your requirement for an excel vba expert. I have done many projects in excel. Can send you sample if needed. Do let me know if we can take this forward
$70 AUD in 1 day
5.0 (3 reviews)
3.8
3.8
User Avatar
Hello, I have carefully read your project description and totally understand its requirements. I can assure you that I can prepare the desired spreadsheet within the stipulated time. I place your project as my outmost priority and will give you the best quality result possible owing to my in dept knowledge of your project. Please don't hesitate to quickly contact me and let's talk about our next steps. My schedule is currently quite flexible. So I am sure we can put together an arrangement that suits your needs. Best regards, Nnadozie S.
$50 AUD in 2 days
4.9 (17 reviews)
3.7
3.7
User Avatar
I am an Accountant with more than 10 years of experience including preparation of different management reports and variance analysis. I can design a dashboard for easy understanding and tracking fulfilling your requirement. Further can be discussed in detail
$50 AUD in 1 day
5.0 (9 reviews)
3.5
3.5
User Avatar
Hey Nick Hope you are doing fine. I have full fledge knowledge of Microsoft Excel, Word, Powerpoint, OneNote, etc, etc. I have done enough job in creating dashboards using pivots, creating graphs, and formulas, data automation in excel sheets. I have checked bot of your files and can do this job perfectly for you. Let's talk in chat and discuss more about it. Waiting for your response.
$100 AUD in 2 days
4.9 (3 reviews)
3.1
3.1
User Avatar
hello, I am ready for a basic Excel spread sheet to track sales data over the 2020 calendar year on a fortnightly basis. The file 2020_GoalTracker provides an example of the layout and required fields for the new spread sheet. The second file (Copy of WIP) is a previous Excel workbook that we have used to track sales data to provide an idea of what we are after. Required : - all fields in red need to accumulate each fortnight - date column needs to be fortnightly and end at or close to 31/12/2020 - The Targets listed across row 5 all need to be adjustable and feed into the lower tracking categories ie if i changed L5 to $550,000, C26 would need to auto-calculate to $21,153 and accumulate going forward - The spreadhsheet needs to look modern and user friendly, you can add your own ideas, colors, concepts to make it work (company logo colors and design cannot be changed). please send me a message to discuss further. thanks
$40 AUD in 2 days
5.0 (3 reviews)
0.6
0.6
User Avatar
I have lots of experience in data typing, data entry, web research, database administration, ad posting, data research, data mining, data extracting, data scraping, virtual assistant. I hope your kind response.
$70 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a fast typist and I can complete your faster and please give me one chance to prove myself please and I am good in excel
$88 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
1. QUALIFICATION I am young qualified professional having certification in the field of Chartered Accountancy (CA) and MBA (Finance). 2. EXPERIENCE Initially I started from Data Entry, Bookkeeping and gain expertise in it and Now (Alhamdulillah) skillful to prepare Financial Statements (Balance Sheet, Profit and Loss Account and related Statements and Notes) as per IFRS and IASs. I have an experience of more than 10 years in the field of data entry, bookkeeping and financial statements. Further I have “Typing Speed of 100 WPM” which is considered an extra Excellency in the field of accountancy. I am well equipped with “Formulas’ and Functions Used In Excel”. I have a practical exposure of more than 7 years in the field of typing and Microsoft office work. 3. DISTINCTIVE FEATURE Further I am running an “Experienced Professional Team” of more than 30 people for such sort of work to gain satisfaction of clients by meeting deadline In addition to all above I have a Four Star Rating on Fiver and “98% Work Completion Rate”.
$40 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi. I read your job description and I can absolutely help you out with it. I'm confident that I am the best person for this job and I Will make sure I do my very best and make you satisfied with the work. Feel free to start a chat so we can discuss this in detail. Thank you.
$70 AUD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi Dear... I have read and understood all your initial requirements, and I feel, I would be the best choice for this project, I have more than 1 year of working experience in the industry. I am producing quality content for my clients including; ARTICLE WRITING, ESSAY WRITING, RESEARCH PAPERS. I can provide you 100% quality even in a short period. I can assure you, "You will hire me again and again after getting my first service".
$70 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I will be glad to assist you with your project. Please contact me by chat for help you. Have a Nice Day
$40 AUD in 7 days
5.0 (1 review)
0.0
0.0
User Avatar
I am pretty sure that I can do the project accurate at a speed of 40-45wpm. I am using Excel for almost 10 years. I am data entry here in the Philippines. Relevant Skills and Experience -Convert word file into excel or pdf form. -Collecting and entering data to database. -Transcribing -etc.
$55 AUD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have well experience in this data entry. well in planning and making tracking sheet.. You will be satisfy in this work Regards, Amit Yesugade
$80 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I can do your work, according to your preference. I am very much interested in your project and would like to invite you for further discussion over chat board. Waiting for your positive response. Regards, Nasir.
$40 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Sir, This is Samshunnahar, an Excel Expert would like to work with you. I have 2 years experience on MS-Word, MS-Excel and data Entry. I think, I am good fit for this job. I read project description carefully and I will be able to complete the job exactly like your ATTACHED files. Please let me. Regards
$50 AUD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Richmond, Australia
5.0
8
Payment method verified
Member since Oct 10, 2018

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.