Reporting (with graphics and table) in Excel. Data in raw format in another excel sheet.
$50-150 USD
Zamknięte
Opublikowano ponad 6 lat temu
$50-150 USD
Płatne przy odbiorze
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.
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 years of experience in Data Entry, Data Processing, Excel, Visual Basic, Visual Basic for Apps
Proposed Milestones
$100 USD - Reporting (with graphics and table) in Excel. Data in raw format in another excel sheet.
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 and Experience
Expert in excel (pivot, formatting,formulas etc)
8+ experience in customized excel solutions.
Proposed Milestones
$120 USD - Total cost - release on 100% satisfaction
You can see samples under my portfolio.
Thanks
Priyal
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 and Experience
I can help you with this project by creating a Macro which would create the dashboard based on data. I am an Excel expert who have done over hundred project on Freelancer , with ~100% completion rate.
Proposed Milestones
$111 USD - Excel Macro to Create Dashboard Based on ERP Data
Please share the details about categories and layout.
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 - Milestone
Please initiate conversation to discuss further.
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 relevante
Excel experience. I have work managing data and delivering professional reports.
Htos propuestos
$100 USD - excel project / report
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# using .NET framework using Visual Studio 2012 and 2013
-- Expert in VB.NET using VS2012/VS2013
-- WPF and Windows Forms Application
Proposed Milestones
$111 USD - Excel
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 Experience
Data Entry, Data Processing, Excel, Visual Basic, Visual Basic for Apps
Proposed Milestones
$105 USD - .
Have experience in Networking, Software & Data Entry, Banking & Financial.
Relevant Skills and Experience
Have experience in Networking, Software & Data Entry, Banking & Financial.
Proposed Milestones
$111 USD - MS
If we can discuss over chat
Hi, I have total 9+ years of experience in excel dashboard created and data presentation. I will do this job with required accuracy and timeliness. looking forward for your positive response.
Thanks
Rohan