Find Jobs
Hire Freelancers

Building Macro to Obtain KPI's and Graphs

$30-250 USD

Closed
Posted over 7 years ago

$30-250 USD

Paid on delivery
I need to build a basic macro that will sort and graph data using different criteria
Project ID: 11594469

About the project

21 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
21 freelancers are bidding on average $176 USD for this job
User Avatar
Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a working sample work before you consider awarding me the project. Thanks, Jay
$200 USD in 3 days
5.0 (794 reviews)
8.6
8.6
User Avatar
Hi, I am good at Excel and vba. Plz provide me the details further to get the scope of work. Looking forward to discuss in the chat.
$150 USD in 2 days
5.0 (966 reviews)
8.1
8.1
User Avatar
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$150 USD in 3 days
4.9 (417 reviews)
7.7
7.7
User Avatar
Greetings! 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. In fact, over the last MONTH , I have spent at least 225 HOURS on automation in Excel. Only last week I completed a project where I had to develop charts for 16 variables. And one more set of charts (15+) on an another project for tracking currency movements. A month ago I completed a dashboard containing 112 charts (8 KPIs across 14 business units) that is view able on a single screen( yes, no scroll allowed) for Management reporting. I have been extensively involved in charts development of late. I can help with your requirement. Looking forward to hearing a positive response from you. Thanks in advance! Have a Great Day! Srinivasan Krishnamoorthi
$80 USD in 3 days
5.0 (222 reviews)
7.0
7.0
User Avatar
Dear Sir/Madam, I have 3 years of experience in Excel VBA programming. I work as a business data analyst at Ford Motor Company creating automated reports and dashboards on car sales figures of 21 European countries. Can you tell me more details about your project? Regards, Balint
$155 USD in 5 days
5.0 (132 reviews)
7.0
7.0
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards
$150 USD in 3 days
4.9 (284 reviews)
7.1
7.1
User Avatar
I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, macros (VBA scripts), pivots, filters, and other advanced tools. I've done a lot of similar work. Please see reviews on my profile. It would be my pleasure to do your project. Please contact me to discuss the details. Please have a look at some Excel projects I've done: https://www.freelancer.com/projects/Excel/Build-Excel-reports-dashboard/ https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/ https://www.freelancer.com/jobs/Excel-Mathematics/Convert-math-proofs-Excel-formulas/
$120 USD in 2 days
4.8 (205 reviews)
7.2
7.2
User Avatar
Hello, I am VB, VBA, C#, WPF, Java, Delphi, PHP, ASP.NET, CAD and GIS developer, I developed many desktop applications and custom tools, macros and Add-Ins. For reference see my profile. I am ready to discuss and doing the project. Regards, Eyad
$1,200 USD in 15 days
5.0 (26 reviews)
6.9
6.9
User Avatar
Can get the data sorted and plot the graphs based on the selection criteria. - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Please review my portfolio on recent projects completed. My Skills: - I have good skills in Excel automation and used extensively the macros/VBA to automate: - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells,, data camparision using formulas, lookups and bringing up summaries. - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables - Outlook automation - Performing different actions other that using the existing rules, updating calendars based on logic. - MS Access - Expert in designing table, user input forms and also reporting from data. - Excel to MS access data porting and conversion and designing new system for use.
$120 USD in 3 days
4.7 (53 reviews)
6.1
6.1
User Avatar
Hello, I have been working as freelancer since last ~ 3 years,prior to this was working with a MNC as an Sr. Software Professional. The project is Product based development and integration of the product with various already existing Products and processes.. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in ASP.NET,MVC -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov
$155 USD in 3 days
4.9 (62 reviews)
5.5
5.5
User Avatar
Hi, Being attracted with your declaration of program, I feel tempted to have the chance to make your work complete carefully and sincerely. I would like at present to have your kind-mind and as soon as possible. Sincerely Yours obedient helpful person
$70 USD in 3 days
5.0 (27 reviews)
4.6
4.6
User Avatar
I have 7 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I have worked on extraction with websites like Amazon, Cellpex,Costco,etc., hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction. please award me this project and contact me for further details
$166 USD in 3 days
5.0 (56 reviews)
4.8
4.8
User Avatar
I can code this macro using whatever formulas for KPI you prefer and create a very easy-to-read graph in no time for your convenience.
$55 USD in 3 days
4.9 (13 reviews)
3.4
3.4
User Avatar
I am a Project Manager in profession working at one of the world's largest I.T. firms. I have more than 10 years of experience in academic writing and Data Entry and ensure that quality work is delivered always. Give me an opportunity; I will deliver you the quality. Also, I have expert writers in academic topics, web scrapper & bloggers, Data Entry experts and provide best quality content. We honor the delivery time commitment and work with you closely to understand your specific needs.
$35 USD in 3 days
4.7 (2 reviews)
2.0
2.0
User Avatar
Hello, I would love to help you and receive more information. As soon as I am awarded the project I can start work. I can build a macro that will sort and graph data using different criteria you select. I have worked developing and maintaining Excel databases with more than 1,000,000 cells of information and making Access databases for a large multinational organization. I also have experience writing VBA code for Office products. I recently finished a project that calculated the distance between more than 10,000 GPS coordinates and sends an email automatically with an attached mail merge and made corporate dashboards along with data import/export macros. As a Microsoft Office solution developer I offer solutions using Word, Excel, PowerPoint, Access, Outlook, Lync and Skype for business. I also have experience developing and administrating Office 365 SharePoint sites. Additionally, I have experience programing with Visual Basic for Applications (VBA), BAT, LISP (AutoCAD), and KML (Google Earth). I am a certified Autodesk AutoCAD drafting technician in 3D and 3D but more than a piece of paper I have work experience that backs my skills. I am Canadian so I am a fluent English speaker. I also speak fluent and native Spanish speaker since I have lived most of my life in Mexico and Guatemala. I am currently doing volunteer work in Mexico. Thank you for considering my offer. Greetings, Milton Mykiwka
$60 USD in 3 days
5.0 (3 reviews)
1.6
1.6
User Avatar
Hello, I've done sometimes sheets like this, in order to create/update the co. dashboard. It will be a pleasure to do this. Thanks in advanced! HFava
$100 USD in 3 days
3.2 (1 review)
0.7
0.7

About the client

Flag of CHILE
santiago, Chile
5.0
1
Member since Jun 21, 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) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
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.