Đã Đóng

Reporting (with graphics and table) in Excel. Data in raw format in another excel sheet.

We have raw data from ERP system.

Rows with orders and information.

Automated, pivot style.

Need reporting/automated report/pivot in a clean nice format. Data from the whole sheet.

Need the following: (we work one by one, and I will be involved approve the layout)

All reporting to be based on given categories (to be informed)

- How many service jobs (based on a specifict product number in column Q). Given for this last year, this last month - compared to the year before (to this date) and this month year before. Date in X column.

- Value of service jobs, given for this last year, this last month - compared to the year before (to this date) and this month year before. Date in X column.

- How many hours of service is performed for each month last year – compared to this year (based on a sum of product)

- How many product x compared to product y are sold last year, this year and each month.

- Top customers to year, based on value of orders, product x and product y. Customer id in C column.

Kĩ năng: Nhập liệu, Xử lí dữ liệu, Excel, Visual Basic, Visual Basic cho Ứng dụng

Xem nhiều hơn: courier data entry format excel sheet, data bill format excel, excel pivot table data raw data, amazon data entry format excel, data entry format excel, project data entry format excel, lock format excel pivot table refresh, automatically format excel data word template, data uae companies excel format, fnma data format excel, excel dont format automatically comma separated data, lock format excel data refresh, sample supplier data base format excel format, data sheet format excel, format excel data sheets, format excel data

Về Bên Thuê:
( 4 nhận xét ) Hommersak, Norway

ID dự án: #15656819

43 freelancer đang chào giá trung bình $101 cho công việc này

$100 USD trong 1 ngày
(262 Nhận xét)
7.7
schoudhary1553

Greeting, I have understood your Reporting (with graphics and table) in Excel task and can do it with your 100% satisfaction. Please ping me for more discussion. Relevant Skills and Experience I have more than 5 yea Thêm

$100 USD trong 2 ngày
(213 Nhận xét)
7.3
aarifakhtar

Hi: I believe that you get your data from ERP system. You want to use that raw data to create a dashboard which would provide certain metrics such as number of service jobs, value of service jobs, etc Relevant Skills Thêm

$111 USD trong 5 ngày
(158 Nhận xét)
6.9
priyal1997

Dear Sir/Madam, I'm an expert in advanced pivot tables and excel features and can help you on this task perfectly. Have already done lots of similar data analysis tasks for business around the world. Relevant Skills a Thêm

$120 USD trong 1 ngày
(169 Nhận xét)
6.6
rohitpithisaria

Hello I am an excel expert and would like to bid on the project posted by you. I can develop the required reports from the raw data. Thanks Rohit Relevant Skills and Experience Excel Proposed Milestones $138 USD - Thêm

$138 USD trong 5 ngày
(100 Nhận xét)
6.3
TonmoyRoy111

Dear Client I have previously carried out a number of projects in excel using vba macro and formulas. Kindly contact me for further details. Roy

$100 USD trong 2 ngày
(220 Nhận xét)
6.2
abhinovpankaj

I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Relevant Skills and Experience -- VBA and Excel,Word,Office Applications -- Expert on C# Thêm

$111 USD trong 6 ngày
(51 Nhận xét)
5.5
helalru

I have read your project details and i understand that i have available experience to complete your project with 100% error less. Relevant Skills and Experience As an experienced freelancer i know how to complete your Thêm

$55 USD trong 10 ngày
(38 Nhận xét)
5.5
asadkhan3533

Please review my profile as i am an excel guru how can produce your desired results in no time Relevant Skills and Experience Data Entry, Data Processing, Excel, Visual Basic, Visual Basic for Apps Proposed Milestone Thêm

$111 USD trong 5 ngày
(32 Nhận xét)
4.9
$111 USD trong 10 ngày
(6 Nhận xét)
5.3
beltran0404

Hello, I am Luis from Venezuela and it will be my pleasure to help you with this excel project. I have a lot of experience with excel, pivot tables and dashboards then I can do this. Habilidades y experiencia relev Thêm

$90 USD trong 3 ngày
(65 Nhận xét)
4.8
royalcalif

"Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. Thank you very much for your opportunity to bid" Relevant Skills and Experienc Thêm

$50 USD trong 2 ngày
(45 Nhận xét)
4.9
aimefx

Hi, I am expert in excel, vba and Power Bi. I have checked the excel file. I can create report and dashboard in excel and power bi as per specifications. If you are interested contact me over chat. Relevant Skills and Thêm

$100 USD trong 3 ngày
(19 Nhận xét)
4.5
$111 USD trong 10 ngày
(4 Nhận xét)
4.0
Ashisjena2015

I can finish this project within few hours.

$99 USD trong 0 ngày
(13 Nhận xét)
3.7
jasalaz100

Immediate [url removed, login to view], fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Relevant Skills and Experience Experience of 6 years usi Thêm

$111 USD trong 3 ngày
(7 Nhận xét)
3.6
$111 USD trong 10 ngày
(9 Nhận xét)
4.3
aubrey03

I am an Excel VBA specialist with experience in creating dynamic pivot charts. You may check one of my dashboards here: [url removed, login to view]

$80 USD trong 2 ngày
(11 Nhận xét)
3.2
Valuesolutions

Hello, how are you? I have read the details provided, but please contact me so that we can discuss more on the project. I don't outsource like most people do ensuring quality work on time Relevant Skills and Experien Thêm

$105 USD trong 3 ngày
(6 Nhận xét)
4.5
hsingla85

Available Immediately | Excel Guru | VBA Expert | Assured timed delivery Relevant Skills and Experience MS Excel | VBA | Business Knowledge Proposed Milestones $100 USD - file

$100 USD trong 4 ngày
(2 Nhận xét)
1.9