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
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
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 :)
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
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
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!
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
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.
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
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.
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
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.
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”.
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.
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".
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.
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.
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