Find Jobs
Hire Freelancers

Advanced Excel Assistance

$30-250 USD

Cerrado
Publicado hace más de 7 años

$30-250 USD

Pagado a la entrega
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.
ID del proyecto: 12009103

Información sobre el proyecto

19 propuestas
Proyecto remoto
Activo hace 7 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
19 freelancers están ofertando un promedio de $143 USD por este trabajo
Avatar del usuario
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 en 1 día
4,9 (346 comentarios)
8,0
8,0
Avatar del usuario
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 en 3 días
4,9 (401 comentarios)
7,6
7,6
Avatar del usuario
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 en 5 días
4,9 (250 comentarios)
7,6
7,6
Avatar del usuario
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 en 3 días
5,0 (271 comentarios)
7,1
7,1
Avatar del usuario
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 en 3 días
4,9 (90 comentarios)
7,2
7,2
Avatar del usuario
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 en 3 días
5,0 (141 comentarios)
7,1
7,1
Avatar del usuario
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 en 3 días
5,0 (209 comentarios)
6,9
6,9
Avatar del usuario
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 en 3 días
4,8 (172 comentarios)
7,1
7,1
Avatar del usuario
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 en 3 días
5,0 (116 comentarios)
6,5
6,5
Avatar del usuario
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 en 3 días
4,9 (115 comentarios)
6,2
6,2
Avatar del usuario
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 en 3 días
4,6 (49 comentarios)
6,0
6,0
Avatar del usuario
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 en 2 días
4,9 (64 comentarios)
5,7
5,7
Avatar del usuario
Hi, i can help you with this project, please let me know more about it :) .
$50 USD en 1 día
5,0 (26 comentarios)
5,3
5,3
Avatar del usuario
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 en 3 días
5,0 (57 comentarios)
5,3
5,3
Avatar del usuario
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 en 3 días
4,8 (69 comentarios)
5,5
5,5
Avatar del usuario
10-12 successfully completed data Migration Projects only using Macros. Hence consider the job done. The output will be 100% quality
$100 USD en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
United States
0,0
0
Miembro desde nov 7, 2016

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.