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)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。