Peruttu

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

Tietoa työnantajasta:
( 0 arvostelua ) United Kingdom

Projektin tunnus: #16350582

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

seaanddream

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ä
(281 arvostelua)
7.6
Webxpert4u

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ä
(231 arvostelua)
7.5
£300 GBP 5 päivässä
(225 arvostelua)
7.3
maverick44000

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ä
(85 arvostelua)
6.9
katilinas

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ä
(110 arvostelua)
6.4
zekovicm

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ä
(69 arvostelua)
6.5
Tanmoy236

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ä
(132 arvostelua)
6.3
TonmoyRoy111

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ä
(257 arvostelua)
6.5
satishtl

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ä
(45 arvostelua)
5.5
usmanhassan123

mphill in computer science and expert in Excel tasks

£500 GBP 1 päivässä
(36 arvostelua)
5.7
asadkhan3533

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 10 päivässä
(41 arvostelua)
5.2
whitehorsetechn

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ä
(13 arvostelua)
5.1
awaisjahangir25

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ä
(31 arvostelua)
5.1
periyannas

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ä
(27 arvostelua)
4.8
vaidyag

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ä
(11 arvostelua)
4.4
£250 GBP 10 päivässä
(14 arvostelua)
3.2
MaMingMing

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)
3.7
imranrazawi

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 10 päivässä
(5 arvostelua)
3.4
£250 GBP 1 päivässä
(7 arvostelua)
2.7
£270 GBP 3 päivässä
(2 arvostelua)
2.1