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.

Evner: Dataindførsel, Databehandling, Excel, Visual Basic

Se mere: 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

Om arbejdsgiveren:
( 0 bedømmelser ) United Kingdom

Projekt ID: #16350582

36 freelancere byder i gennemsnit £455 på dette job


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 Flere

£455 GBP in 10 dage
(281 bedømmelser)

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 Flere

£452 GBP in 4 dage
(231 bedømmelser)
£300 GBP in 5 dage
(225 bedømmelser)

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 Flere

£500 GBP in 7 dage
(85 bedømmelser)

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 Flere

£497 GBP in 13 dage
(110 bedømmelser)

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 Flere

£250 GBP in 5 dage
(69 bedømmelser)

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 Flere

£300 GBP in 3 dage
(132 bedømmelser)

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 in 10 dage
(257 bedømmelser)

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 Flere

£300 GBP in 5 dage
(45 bedømmelser)

mphill in computer science and expert in Excel tasks

£500 GBP på 1 dag
(36 bedømmelser)

Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thanks, Asad Khan

£455 GBP in 10 dage
(41 bedømmelser)

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 Flere

£400 GBP in 5 dage
(13 bedømmelser)

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 Flere

£500 GBP in 10 dage
(31 bedømmelser)

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 in 6 dage
(27 bedømmelser)

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 Flere

£833 GBP in 45 dage
(11 bedømmelser)
£250 GBP in 10 dage
(14 bedømmelser)

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

£555 GBP in 10 dage
(2 bedømmelser)

I am experienced Excel solutions developer with database with Ms Access, SQL etc. I have developed number of different solutions e.g Dashboards and data analytical reports.

£555 GBP in 10 dage
(5 bedømmelser)
£250 GBP på 1 dag
(7 bedømmelser)
£270 GBP in 3 dage
(2 bedømmelser)