Find Jobs
Hire Freelancers

Advanced Excel Assistance

$30-250 USD

Closed
Posted over 7 years ago

$30-250 USD

Paid on delivery
I am looking for someone to add a Macros button and develop charts and a Dashboard that combines information from about 3-5 spreadsheets into one spreadsheet, outlining the data on the Dashboard. The spreadsheets come to me weekly, so I want a separate tab for each week and want to be able to upload all the weekly excel reports and have the data generate to the new tab each week illustrating the weekly trends on the dashboard.
Project ID: 12009103

About the project

19 proposals
Remote project
Active 7 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
19 freelancers are bidding on average $143 USD for this job
User Avatar
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
$100 USD in 1 day
4.9 (346 reviews)
8.0
8.0
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.
$200 USD in 3 days
4.9 (401 reviews)
7.6
7.6
User Avatar
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled (VBA) Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
$140 USD in 5 days
4.9 (250 reviews)
7.6
7.6
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
$250 USD in 3 days
5.0 (271 reviews)
7.1
7.1
User Avatar
I can do all kind of screen layout's, reports, and dynamic dashboards on excel by formulas, pivot tables, charts, and VBA. I am a specialist in financial reports, budget, costing reports, inventories, bill of materials together with extensive knowledge and expertise in Microsoft Excel, Pivot Tables, and Visual Basic Application including preparation of screen layout's, generator reports showing the relevant information in 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. Areas of expertise: • 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, SPE (SPV FVC). • Implementation of information systems in organizations and businesses (accounting, payroll, treasury, budgeting and control, Intuit QuickBooks, SAP B1, ERP, Venture Capital system, CRM, etc.) • Budget Development & Management • Business expansion and start-up • Served as CFO, Controller, and Chief Accountant at global parent companies • Extensive experience in accounting, consolidating, forecasting, budgeting, and costing
$155 USD in 3 days
4.9 (90 reviews)
7.2
7.2
User Avatar
Hi there. I can write the necessary VBA code and with a button click you will be able to consolidate the data in dashboard ans create charts accordingly (this is what u want, right?) Lets get in contact and proceed. Thanks..
$263 USD in 3 days
5.0 (141 reviews)
7.1
7.1
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 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 get your work completed to your fullest satisfaction. Looking forward to hearing a positive response from you. Thanks in advance! Have a Great Day! Srinivasan Krishnamoorthi
$130 USD in 3 days
5.0 (209 reviews)
6.9
6.9
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. Just FYI, I own a small business registered in the state of Illinois. I could bill you as an individual freelancer or as a business, whichever suits you better. 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/
$200 USD in 3 days
4.8 (172 reviews)
7.1
7.1
User Avatar
Hello. 30 % of employers hiring me once hired me again. I have experience in the same. I CAN do this job, and do it well!
$100 USD in 3 days
5.0 (116 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 so that I can estimate cost and time better. I have completed more than 290 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$100 USD in 3 days
4.9 (115 reviews)
6.2
6.2
User Avatar
Can consolidate the multiple sheets into one summary data. Have the graphs and dashboard metrices generated on each weekly tab. Can be done one a click of a button using macro. - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Excel macros - I have done complicated data processing using Excel macros for Exam sheet evaluation, (Recent)Circuit designing based on mulitple wire models, amps/voltages, calculations of taxes for Canadian citizen based on tax slabs per Fed and Provincial tax, based on the salary ranges etc. - Outlook macros - - Samples - Extracting mail contents parsing and sending to different customers, getting the task and calendar events from Outlook to Excel - Pl. review my portfolio on recent projects. 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 - extracting, modifiying mails in Inbox, retrieving calendar, tasks or scheduling. - MS Access - Expert in designing table, user input forms and also reporting from data.
$80 USD in 3 days
4.6 (49 reviews)
6.0
6.0
User Avatar
Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the usual Open file and/or select folder dialogs to identify the current input and output files (or the folders containing them, as required by the job) and hosting command buttons and other controls if necessary. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards
$55 USD in 2 days
4.9 (64 reviews)
5.7
5.7
User Avatar
Hi, i can help you with this project, please let me know more about it :) .
$50 USD in 1 day
5.0 (26 reviews)
5.3
5.3
User Avatar
Hello, I can create the dashboard will graphs and everything you need. All will be populated with a click of a button. If you are interested please open a chat with me. Kind regards, Sorin
$155 USD in 3 days
5.0 (57 reviews)
5.3
5.3
User Avatar
Hi, Experienced Excel VBA and VB.Net Programmer. I have read your instructions carefully. I can extract the data from sheets and combine into one single sheet. I have just completed the job like this for another client. It takes data from trading site and manipulate the data. Expertise in exchanging data between sheets, advance formulas, critical programming, developing system for management and creating reports. I also have excellent knowledge and experience of creating User Form and its elements button, combo, drop down, option buttons etc. in excel VBA. So, I can do this job nicely. Ready to start please reply soon. Thanks, Virendra
$120 USD in 3 days
4.8 (69 reviews)
5.5
5.5
User Avatar
10-12 successfully completed data Migration Projects only using Macros. Hence consider the job done. The output will be 100% quality
$100 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
United States
0.0
0
Member since Nov 7, 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.