Find Jobs
Hire Freelancers

Customize Pivot tables, Data Validation, Macros

$30-250 USD

已关闭
已发布将近 8 年前

$30-250 USD

货到付款
I have an excel workbook that needs to be updated. Currently it's designed for another division in my company with wrong system names and the data needs to be captured differently. The excel file uses pivot tables, macros and data validation I believe. The workbook has a dashboard tab that displays graphs and a table of data of one system that is pulled from a different work sheet. It has a pull down to select a different system to display its data and graphs. What I need: I need the system names to be changed. Different data points to be displayed and captured for each system. The current dashboard is capturing some useless data that I don't want captured as well.
项目 ID: 10522867

关于此项目

40提案
远程项目
活跃8 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
40威客以平均价$147 USD来参与此工作竞价
用户头像
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 version of file before you consider awarding me the project. Thanks, Jay
$176 USD 在3天之内
5.0 (642条评论)
8.3
8.3
用户头像
Hi, I am good at Excel pivot tables, macros. Looking forward to discuss further the details. I would like to work on this project.
$250 USD 在2天之内
5.0 (799条评论)
7.9
7.9
用户头像
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 在3天之内
4.9 (280条评论)
7.2
7.2
用户头像
Hi, I understand the project requirements and willing to start as soon as possible. Kindly share the details and I will deliver with high quality. Looking forward to work with you. Thanks & Regards Khushi India
$157 USD 在3天之内
4.8 (279条评论)
7.1
7.1
用户头像
I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in Excel and VBA. I've done a lot of similar work. I could send you samples of my work if you wish. Please see reviews on my profile. It would be my pleasure to do your project. Please let me know the details. Please have a look at some Excel projects I've done: 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/
$150 USD 在3天之内
4.8 (190条评论)
7.1
7.1
用户头像
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 在3天之内
5.0 (212条评论)
6.8
6.8
用户头像
i can do it for you quickly and exactly .
$200 USD 在5天之内
4.9 (106条评论)
6.6
6.6
用户头像
Hi there, Your project sounds fun and interesting - I have over 13 years of corporate experience creating automated advanced dashboards and reports and I'd love to take a look at your existing Excel file and hear all of the specific requirements and changes you would like made. I love using pivot tables, macros and data validation drop downs and creating charts and graphs in Excel is one of my favorite things to do. I have a few portfolio items on my profile if you'd like to take a look. Hopefully I can see your file and hear more about the names and data points that need to be changed along with all of your requirements. Thanks either way and best of luck, Shaun
$166 USD 在5天之内
5.0 (77条评论)
6.4
6.4
用户头像
Hello, my name is Andrés. First of all thank you for considering my offer. I am an industrial engineer with more than four years of experience in the simulation, process improvement and data analysis fields. Within this experience I have developed several skills in MS excel: regression analysis, time series, descriptive statistics, modeling, complex data analysis, pivot tables and charts, PowerPivot, financial analysis, macros and VBA. I would like to win this project as I feel really comfortable with this kind of projects :) I want to build an excellent reputation here as a freelancer so I will do my very best.
$100 USD 在3天之内
5.0 (85条评论)
6.6
6.6
用户头像
A proposal has not yet been provided
$40 USD 在2天之内
4.9 (55条评论)
5.7
5.7
用户头像
Hello, Thank you very much for posting the job. I belong to India. I graduated from India's best university named Indian Institute of Technology (IIT). I have over 7 years of professional work experience and I have been freelancing for over 3 years. I have worked on lot of advance Excel dash boarding and VBA coding and delivered them successfully with high quality. Few of my projects are 1) Fully automated end to end business model for 3B $ healthcare company. Scope : Global Forecast for 8 products, cost modelling, product selection and prioritization, scenario analysis 2) Training Management System for an MNC. Scope : Training calender, TL can nominate his associates to relevant trainings, sends reminders, annual training summaries etc 3) BD&L model for an MNC ; Market analysis, geography analysis, opportunity analysis, SWOT, cost benefit analysis 4) Physician segmentation and Targeting ; Physicians of Latin American were segmented in 3 tiers based on several factors, exhaustive call planning strategy was built with additional features like territory alignments, productive call frequency etc I delivered many more projects of high value and quality. I am confident that I can deliver your project with high quality. Looking forward for your response so that I can start working immediately Thanks and Regards.
$150 USD 在3天之内
4.9 (20条评论)
5.8
5.8
用户头像
Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 75 projects, almost 70+ are complex VB/VBA/.Net/Webscrapping projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VBA/VB/.NET, SQL, MS Office, Access/Excel/Word/Outlook, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex Webscrapping (Amazon / Aliexpress / eBay), VBA projects, viz converting Raw data to structured report, sales dashboard, PO tracking, Invoice Automation, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.
$250 USD 在3天之内
4.8 (74条评论)
5.9
5.9
用户头像
Hi there, I would love to help you with your spreadsheet. I am a reporting analyst by profession and I have over 8 years' experience creating and managing automated reports in Excel (much like the one you are describing) using advanced formulas and macros/VBA. I am US based and bring a strong educational and professional background. I encourage you to check out my profile and my reviews. I look forward to discussing this project with you further. Best regards, Marcelo
$200 USD 在3天之内
5.0 (12条评论)
4.9
4.9
用户头像
I have 6 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
$100 USD 在3天之内
5.0 (50条评论)
4.7
4.7
用户头像
Hello. I'm able to create an Excel document that can be linked to your database and allow you just to press a button that will run a Visual Basic macro which will fully automate the process of updating the file and its reports, summaries or charts. I specialize in provide solutions for Business Administration, Data Base management, Business Key Performance Indicators design, Supply Planning and Project Management for commercial and industrial companies. I am also able to develop complex and automated VBA programs integration from Excel spreadsheets and Access databases to other applications, including: - Formulas creation - Pivot tables - Pivot charts - Access queries Integration - Visual Basic for Applications programming I guarantee that I'm able to bring the solution for your project, with the dedication, seriousness and professionalism that it deserves. My work will give you the confidence to initiate a long term relationship. Thank you.
$160 USD 在5天之内
5.0 (11条评论)
4.0
4.0
用户头像
Hi, Im software developer with 5 years experience. I have just finished some project to customize excel file for some company using VBA macro scripts. Feel free to contact me for a discussion. I can help and support you anytime. Thanks Regards, Hung
$45 USD 在1天之内
5.0 (6条评论)
3.6
3.6
用户头像
I am postgraduate (MBA) in finance having more than five years of experience. I have expertise in Excel and VBA. Currently working in an MNC Analytical company in a large financial model having dashboards and presentation, for a leading US bank. I can help you with your current requirement as well as future requirements at low cost with superior quality of work.
$250 USD 在3天之内
4.6 (15条评论)
4.0
4.0
用户头像
Hello, Happy to assist you and your project to update a dashboard and customize it to your needs. I guarantee great quality work, which is always on time and brought to you in a professional manner. If you need more information, come in and chat with me. Thank you in advance for your consideration. Kind regards, Mattttiz
$83 USD 在2天之内
5.0 (1条评论)
2.0
2.0
用户头像
I'm working in ITES industry for last years and data analysis is a part of my job.. Let me know what all you need and when to discuss
$155 USD 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
I have strong excel analysis skills and data cleansing skills. I very well understand the project and can deliver the output within the given time frame with a high data consistency.
$111 USD 在5天之内
0.0 (0条评论)
0.0
0.0

关于客户

UNITED STATES的国旗
United States
0.0
0
会员自5月 17, 2016起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。