Find Jobs
Hire Freelancers

Excel Spreadsheet Creation & Reporting - Sales

£250-750 GBP

Скасований
Опублікований about 6 years ago

£250-750 GBP

Оплачується при отриманні
We're looking for an Excel Spreadsheet/Data base to be created from scratch, so we can input sales data from multiple reports. This must include and enable the following; - Easily add multiple products (including product details & pricing) from multiple vendors and be able to filter by spec & product type. - Input data (weekly sales, delivery costs, marketing & sales support, Rebates, RMAs etc) from multiple sales reports & documents. I expect this will have to be done manually at our end, we just need the tool creating to do so. - Easily compile reports and demonstrate this through stylish graphs; Revenues, Profits, Costs, RMAs. - Enable performance comparison; Year on Year, Week on Week, Vendor vs Vendor, Product vs Product, Average Sale Prices, Profit per System etc. - Ability to export the graphs for use in QBRs. We work with around 8 different partners and this could increase over time. We could either have one spreadsheet per vendor which links into a master file? Or we could have one file which looks after everything. We would need the ability to add more partners in the future as this grows. I have uploaded a template of one which was created in-house which could give an insight of what we're after, but looking for a much more professional one creating which is easier to use.
ID проекту: 16350582

Про проект

31 пропозицій(-ї)
Дистанційний проект
Активність 6 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
31 фрілансерів(-и) готові виконати цю роботу у середньому за £452 GBP
Аватарка користувача
Hi, my name is Sevinc. I read your "Excel Spreadsheet Creation & Reporting - Sales" project descriptions carefully before bidding. I checked the attached excel template as well... I got what you need and ready to go ahead as soon as we can clarify further project details. I am 5-star excel and vba coding expert here at freelancer.com. Pls check my profile and feedbacks first to have some idea about the quality of my previous businesses. I had many similar excel tasks, including automated data extraction, aggregation and reporting, all achieved with 5/5 rating. Kindly get back to me if you wish to proceed with a top-rated and reliable partner here...pls note that I only deliver best quality at a reasonable price, and I am open for longterm partnerships, if you wish too... I bid my best for you to start business, and I am ready to prepare an excel workbook template for you to check & validate, once you give me a reply...regards.
£455 GBP за 10 дні(-в)
4,9 (333 відгуки(-ів))
8,0
8,0
Аватарка користувача
Hi there,I am Miljan,IT expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the agreed deadline. Specializations and skills: Web Scraping(Python,PHP,node.js) Excel (VBA,Macros) Access,Word,Powerpoint Data Entry Data Processing Web Search Market Research Research Leads generating PDF to Excel WordPress Magento Shopify Data Base Programming HTML,CSS,PHP,JavaScript,jQuery,MySql Check out my profile, portfolio, and former clients feedback - that'll let you know everything about me. There is a lot of experience behind me, so it will be a huge satisfaction for me to do this job. Feel free to contact me so we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Kind regards
£250 GBP за 5 дні(-в)
4,9 (160 відгуки(-ів))
7,5
7,5
Аватарка користувача
I am fast and Extremely Detailed Oriented and good with Excel and EXCEL MACRO/VBA. Completed more than 150+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Satisfaction. am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in Sales, Marketing and Advertising. Currently I am working for a Multinational Telecommunication Company as an B2B Marketing Manager.
£300 GBP за 3 дні(-в)
4,9 (268 відгуки(-ів))
7,0
7,0
Аватарка користувача
Dear client I have previously carried out a number of projects in excel using macros and formulas. I can certainly help you in this project. Kindly contact me so that we have a discussion. Roy
£500 GBP за 10 дні(-в)
4,9 (398 відгуки(-ів))
7,0
7,0
Аватарка користувача
Hello, I can develop User friendly data input and retrieval forms so the user will never have to work directly with the Excel sheet itself. I have done several such projects in the past and I can handle it with ease and proficiency. Please discuss details so we may proceed. I am comfortable to receive full payment after you have thoroughly tested the solution. Please discuss via chat. Thank you, Usman
£500 GBP за 7 дні(-в)
5,0 (89 відгуки(-ів))
7,0
7,0
Аватарка користувача
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered ten excel vba projects in the past two months. Willing to take up your project. Thank you, Regards.
£555 GBP за 6 дні(-в)
5,0 (124 відгуки(-ів))
6,4
6,4
Аватарка користувача
Dear Employer, I'm ready to work on "reporting excel spreadsheet creation" project. Relevant Skills Excel, VBA Milestones 397 GBP - code writing 99 GBP - userfriendly interface I can complete your project on time and within your budget.
£497 GBP за 13 дні(-в)
5,0 (120 відгуки(-ів))
6,5
6,5
Аватарка користувача
mphill in computer science and expert in Excel tasks
£500 GBP за 1 день
4,7 (84 відгуки(-ів))
6,3
6,3
Аватарка користувача
Went through the Excel spheet - Customer Review, Range review sales out and Shipping data. Based on the data entered, the Quarter consolidation QoQ and YoY consolidation for particular product type and for a partner can be summariesed into Customer overivew, using click of button. - Thereby the margins, Salesout Allowance, MDF, Profit can be calculated. - Separate buttons to generate the reports YoY, WoW, Vendor Vs Vendor can be generated. - Regarding how to segerate the partners can decide, but from the first look vendor vs vendor comparison can be easier if all in one worksheet. - Have done similar sales, inventory, tax calculations, product wise comparison in Freelancer projects. My Skills: - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data camparision using formulas, lookups and summaries., - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., Sample HighComplex Projects using Macros:(via Freelancer) - Heating Wire Design, Canada, - Identify the wiremodel running through multiple iterations. - System log generation (users logged in time, duration, days) between time period based on the text log files. Generate report. - Employee Tax, Canada - Calculations per hours,wage,provincial deductions, Federal deductions per reference tables.
£300 GBP за 5 дні(-в)
4,7 (53 відгуки(-ів))
6,0
6,0
Аватарка користувача
Hi, I read through your requirement You have requirement to do data entry on your sales data as well purchase data (you have mentioned about vendors). Also this will be required to calculate the profits. Then you require reports (dashboards) to get a view of the performance on various dimensions. I would suggest that you should consider a web based system or system like MS-Access for capturing the data entry to ensure the data is maintained and is clean. For the reports we can use excel which can support your requirements. I have about 15+ years of experience in Infosys and have designed complex systems. I have worked on various MS technologies and web based systems. Regards Vaidy
£833 GBP за 45 дні(-в)
5,0 (15 відгуки(-ів))
5,2
5,2
Аватарка користувача
Hello Sir, By precession I am from finance background for last 5 years. I’ve advanced level MS Excel skills including but not limited to advance formulas, user interactive templates, dynamic charting, highly effective dashboards, Visual Basic programming and pivot tables etc. I understand your requirement as you are looking for an integrated system to track your sales, vendors and analyse performance. Sir I am willing to start work with your help and regular basis discussions to get it done. You can review my profile and reviews from my previous employers. Kindly text me if you are interested in my proposal. Regards Awais Jehangir
£500 GBP за 10 дні(-в)
4,6 (37 відгуки(-ів))
5,3
5,3
Аватарка користувача
Greeting, I have understood your Excel Spreadsheet Creation & Reporting - Sales task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Data Entry, Data Processing, Excel, Visual Basic
£400 GBP за 5 дні(-в)
4,8 (14 відгуки(-ів))
5,2
5,2
Аватарка користувача
I have gone through your requirement and i have 2 solutions to offer with minimal manual intervention. 1) I can create single excel dashboard with single consolidated performance & 8 different link for vendor wise performance 2) I can also create single master DB in access then link to your excel dashboard or make it a "Switchboard" In both solutions all reports will be automated, only manual intervention needed to append the raw data on agreed frequency Looking forward to hear from you
£666 GBP за 10 дні(-в)
3,6 (2 відгуки(-ів))
1,4
1,4
Аватарка користувача
hello. I have worked on excel databases for more than 10 years. I am smart and reliable. I am new to this site and need to gain reviews so I will work for minimum cost. You will stay satisfied. I need to know all the details to tell the exact time. Hope to cooperate with you
£444 GBP за 10 дні(-в)
5,0 (1 відгук)
1,0
1,0
Аватарка користувача
A proposal has not yet been provided
£250 GBP за 7 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
Yes beloved. I am a computer trainer, Data analyst, Data entrant, Database manager, with proven experience in these fields with a supplement of all the office packages. entrust me, with this work. I shall accomplish the work within the exact period you want it, in the very format you want with the highest degree of accuracy. Looking forward to accomplishing this just in time. am so glad to meet you
£555 GBP за 10 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
I am an expert in creating Excel sheets
£277 GBP за 5 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
A proposal has not yet been provided
£555 GBP за 1 день
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
Hi, I believe I can help you with your project in Excel. You can check my portfolio to see my past work.
£722 GBP за 10 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
i am working as mis executive in a company so i can do this please send the information of the data
£555 GBP за 10 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0

Про клієнта

Прапор UNITED KINGDOM
United Kingdom
0,0
0
На сайті з лют. 22, 2018

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.