Excel Spreadsheet Creation & Reporting - Sales

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.

Taidot: tiedonsyöttö, tietojenkäsittely, Excel, Visual Basic

Näytä lisää: how to create a summary report in excel 2016, how to create a report in excel 2016, excel reports template, generate report from excel spreadsheet, excel reports samples, creating reports in excel 2013, how to generate reports in excel using macros, how to create a summary report in excel, excel spreadsheet creation web service, excel spreadsheet creation specialist, custom excel spreadsheet creation calgary, custom excel spreadsheet creation, excel spreadsheet creation service, excel spreadsheet creation money, spreadsheet creation function excel, google finance export excel spreadsheet, excel spreadsheet creation date, export excel spreadsheet web page, data export excel spreadsheet web form, offshore excel spreadsheet creation

Tietoa työnantajasta:
( 0 arvostelua ) United Kingdom

Projektin tunnus: #16350582

33 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


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 Lisää

£455 GBP 10 päivässä
(300 arvostelua)

Hello, I checked attached template and I am sure I can create excel files to input sales data from multiple reports. Highly experienced in Excel Programming, Excel automation and Macros. I am good at Visual Basic an Lisää

£452 GBP 4 päivässä
(277 arvostelua)
£300 GBP 5 päivässä
(275 arvostelua)

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 Lisää

£500 GBP 7 päivässä
(86 arvostelua)

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 agree Lisää

£250 GBP 5 päivässä
(111 arvostelua)

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 Lisää

£497 GBP 13 päivässä
(119 arvostelua)

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 compro Lisää

£300 GBP 3 päivässä
(188 arvostelua)

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 päivässä
(288 arvostelua)

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 päivässä
(67 arvostelua)

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 c Lisää

£300 GBP 5 päivässä
(51 arvostelua)

mphill in computer science and expert in Excel tasks

£500 GBP 1 päivässä
(48 arvostelua)

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 Lisää

£833 GBP 45 päivässä
(15 arvostelua)

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 Lisää

£400 GBP 5 päivässä
(14 arvostelua)

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 effectiv Lisää

£500 GBP 10 päivässä
(36 arvostelua)
£250 GBP 10 päivässä
(14 arvostelua)

Hello i am scrapping expert. this is my main skill let's discuss i am really good at this part. ---------------------------------------------------------------

£555 GBP 10 päivässä
(2 arvostelua)
£250 GBP 1 päivässä
(7 arvostelua)

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 d Lisää

£444 GBP 10 päivässä
(1 arvostelu)

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 p Lisää

£666 GBP 10 päivässä
(1 arvostelu)
£555 GBP 10 päivässä
(0 arvostelua)