Find Jobs
Hire Freelancers

Build an Excel model that pulls in and calculates data from multiple sources each week

$750-1500 USD

Closed
Posted over 7 years ago

$750-1500 USD

Paid on delivery
We are looking for someone who can build an Excel model of ~750 rows that would track multiple data elements by week. The data sources that would be imported are in various formats and don't always have the same naming conventions, so some lookup tables would probably be required as well. The model needs to be able to support slicing the data in multiple ways for dashboard / reporting purposes, so an analytics background / experience with dashboards is desirable.
Project ID: 11667825

About the project

22 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
22 freelancers are bidding on average $925 USD for this job
User Avatar
Dear Project Poster, I have relevant hands on 5 years of experience .We have a team of all the skills. I assure you about the work quality and time delivery. Please give me chance to complete this project. I Have 100% completion ratio. I had already done the same work in past. Looking forward to hear from you. Let me give an opportunity to work. We can talk further when you message me.
$750 USD in 15 days
4.9 (224 reviews)
7.4
7.4
User Avatar
Hello, where do you retrieve data? You take CSV export and import to excel? Or connect to SQL database or something? As being one of the highest rated Excel & VBA expert in this platform, I can work on your job. I am mostly online. Lets discuss more on chat.
$1,184 USD in 10 days
5.0 (141 reviews)
7.1
7.1
User Avatar
Hi: It would be great if you could share a sample data file. Please note that over 90% of my completed projects are related to Excel and Macro. Moreover, I have 100% completion rate and 5-star feedback on projects. Please connect with me discuss your requirements in detail.
$750 USD in 7 days
4.9 (152 reviews)
6.9
6.9
User Avatar
Greetings! I can implement a methodology that would help analyse data in multiple ways. Excel slicer functionality is not available for Text data - however through VBA coding I can implement a system that would help support slicing of Text data. I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting as well as dashboards for Management Reporting. In fact, over the last MONTH , I have spent at least 225 HOURS on automation in Excel. I can show you some of my work if you can IM me using chat window (Freelancers cannot initiate a chat with Employers on their own - otherwise I would have shared some of my work myself). I can get your work completed to your fullest satisfaction. Looking forward to hearing a positive response from you. Thanks in advance! Have a Great Weekend! Srinivasan Krishnamoorthi
$750 USD in 10 days
5.0 (140 reviews)
6.5
6.5
User Avatar
Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. Please send me more details about the work. It will help me estimate time and cost. I have completed more than 280 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$1,250 USD in 20 days
4.9 (115 reviews)
6.2
6.2
User Avatar
I create all kind of Excel Applications by VBA, formulas, pivot tables, including screen layout's, reports, charts, and dynamic dashboards I am a specialist in financial reports, budget, costing reports, inventories, bill of materials construction models together with extensive knowledge and expertise in Microsoft Excel, Pivot Tables, and Visual Basic Application including preparation of screen layout's, generator reports, dynamic dashboard, and graphs. Throughout my career, I have created dozens of financial modules, business plans, and modules for accounting, budgeting, financial reports, financial plans, and inventories reports for a range of products and services. And have bullied all kind of Excel Applications by VBA, formulas, pivot tables, including screen layout's, reports, charts, and dynamic dashboards Areas of expertise: • Implementation of information systems in organizations and businesses (accounting, payroll, treasury, budgeting and control, Intuit QuickBooks, SAP B1, ERP, Venture Capital system, CRM, etc.) • Developing of consolidated financial statements, financial plans (fitted to due diligence), feasibility studies, and measurement reporting tools for global companies • Business valuation and ratios (NPV, IRR, DCF, MCDA, CPI, SPI, EVM, KPI, Monte Carlo technique) • Budget Development & Management • Business expansion and start-up • Extensive experience in accounting, consolidating, forecasting, budgeting, and costing.
$1,250 USD in 20 days
4.9 (50 reviews)
6.3
6.3
User Avatar
Hello. 35 % of employers hiring me once hired me again. I have experience in the same. I CAN do this job, and do it well!
$750 USD in 20 days
4.9 (108 reviews)
6.3
6.3
User Avatar
I have gone through the project details and understand what you are trying to achieve. We have completed a number of similar a projects to yours. I'd like to speak with you to confirm project details. A little about us, We are a team (19 operators) here, giving all data entry, research and scraping service world wide with best quality output ,we are experienced enough to collect the data from several source, from a deep investigation. We would like to talk in details and give the total structure about how we ll do this job along with a sample, LETS TALK HERE FOR DISCUSSING THE JOB Thanks Dg
$750 USD in 20 days
4.7 (151 reviews)
6.5
6.5
User Avatar
Hello, I’ve carefully gone through your job posting Build an Excel model that pulls in and calculates data from multiple sources each week. I'm an expert in Advanced Excel VBA programming techniques. I am very much interested in your project with all of your requirements. I am always available on Email. I will be available to start your project as soon as possible in accordance with you. Thank you for your consideration, Best Regards, Ian
$833 USD in 20 days
5.0 (72 reviews)
5.9
5.9
User Avatar
Hi I'm an Excel expert with years of experience - VBA programming, web scraping, data analysis, pivot tables, lookup, formulas, ect Please provide more details. Best regards, Denis Poduzov
$833 USD in 10 days
5.0 (22 reviews)
4.8
4.8
User Avatar
I have extensive experience in the data processing space. I am an expert in Excel and VBA. Please contact me to discuss the details further. Thanks!
$900 USD in 5 days
4.9 (8 reviews)
4.3
4.3
User Avatar
Hi I have good experience in data analysis for past 2 years. And I'm expert in MS excel. I can able to connect multiple source with excel. I did lookup fields from various tables. I can design dashboards in excel. I'm interested more about project scopes, objective, deliverables and timeline. Based on these parameters, I will you exact quote. I look forward to work on this project. Thanks Sundaram
$1,111 USD in 45 days
3.9 (8 reviews)
2.3
2.3
User Avatar
Hi, I have got over 16 years of experience in leading and managing learning and technology teams. I come with a business process re-engineering background with extensive experience in automating business processes built around Microsoft technologies. My last assignment was for a multinational automobile company where data needed to be pulled out from a huge export from their ERP on a daily basis with 'chassis number', 'product code' and 'country being exported to fields' needed to be pulled out into a separate sheet to feed to a web system which we had developed. The processed sheet pulled data from multiple excel sheet having relational data. I'm assuming that this is a 5 day work with another day for requirement understanding, review etc. Looking forward to your response. Thanks, -Anant
$777 USD in 6 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have many years of experience doing this exact type of work! I work as an Actuary and have spent a lot of time building models in excel to analyze or track data. I also have a lot of experience with variable source formats and am very comfortable using lookups and finding ways to be more efficient in my work. I also have experience creating reports and using slicers to analyze the data. Please let me know if you have any questions or want to know anything else.
$833 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I have more than 20 years of experience on many programming languages like C/C++, C#, PHP, VB, ASP, Java, Javascript and some others. I also have a deep knowledge on MySQL/MSSQL database design/implementation/maintenance tasks, and SQL language query programming. I'm a Microsoft Certified Systems Engineer, having a low-level knowledge on networks and protocols. I also have a strong knowledge in Microsoft Office platform (Word, Excel, PowerPoint, Access), including Excel macro programming. You don't have to pay anything in advance. I'm looking forward to have a chance to work for you. Thanks and best regards
$750 USD in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have worked on something similar before and have 12 years of experience in Data Analytics, MS Office. customer support, operations management. I am six sigma certified. Let me know how you would like to take it forward. Awaiting for your positive response.
$777 USD in 6 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
United States
0.0
0
Member since Sep 29, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.