Find Jobs
Hire Freelancers

help vba excel training or mentor

$30-250 USD

Fechado
Publicado há mais de 5 anos

$30-250 USD

Pago na entrega
hello, i need some help and training on vba / excel basically i have multiple input files from "source A" and one output workbook from "source b" i need to check that the input files match the output workbook there are 280 input files that are in csv format and there is one output excel workbook that is created i need to check all csv file data with correct columns has been correctly imported into the workbook. some sort out output comparison file needed that demonstrates which files, data and columns not properly mapped or are missing. also appointed freelancer would recommend how to fix problems from "source b". thanks
ID do Projeto: 18028894

Sobre o projeto

16 propostas
Projeto remoto
Ativo há 5 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
16 freelancers estão ofertando em média $122 USD for esse trabalho
Avatar do Usuário
I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without changing my bid or playing games. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly and at my FIRST BID. I promise to deliver 100% Satisfaction.I have more than 5 year of experience in Excel, Excel Macros, Excel VBA, Visual Basic. Please ping me for more discussion.
$200 USD em 3 dias
4,9 (346 avaliações)
8,0
8,0
Avatar do Usuário
Hi saj1011! What I understood is that you need to compare the files (csv files) with a single file. Should both files have exactly same content in them? Please reply me via chat.
$200 USD em 3 dias
5,0 (364 avaliações)
7,5
7,5
Avatar do Usuário
Hi there,I am Miljan,Excel VBA expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the agreed deadline. Check out my profile, portfolio and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan
$155 USD em 2 dias
4,9 (128 avaliações)
7,3
7,3
Avatar do Usuário
Completed numerous similar projects in the past and always impressed the clients with my excellent solutions. 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. 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.
$111 USD em 3 dias
4,8 (75 avaliações)
5,9
5,9
Avatar do Usuário
Hello there, As indicated in your similar project on this; and as an expert in excel and VBA, i can help you to accurately develop a vba script to accomplish your tasks and train you on how to do it as you have specified. Please contact me and let us talk more about your project. Thanks
$100 USD em 3 dias
5,0 (83 avaliações)
5,7
5,7
Avatar do Usuário
1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction
$150 USD em 3 dias
4,8 (68 avaliações)
5,7
5,7
Avatar do Usuário
Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I can fix the error of "Source b" and develop a macro to compare data from input CSVs and output excel file. All process will be automated. I have done mostly Excel VBA Programming job. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio So, I can do this job nicely. Ready to start please reply soon. Thanks, Virendra
$120 USD em 3 dias
4,8 (88 avaliações)
5,7
5,7
Avatar do Usuário
I can do the job! I'm an engineer with advanced working knowledge and experience in excel, VBA and VBA interaction between different software (Word, excel, powerpoint, access, autocad etc.). Also have lots of experience with processing very large data files in different formats with VBA (specially data acquisition files). I value and honor customer service so I’m responsible for helping, small adjustments, unnoticed corrections or bug fixes even after the project has been paid for and closed. Communication won't be an issue because I was raised in USA (Charlottesville Virginia) so English is my second mother tongue and I have IELTS certification with global score of 7,5 over 9.
$115 USD em 3 dias
5,0 (22 avaliações)
4,2
4,2
Avatar do Usuário
Hi, I am an Excel Expert with very good knowledge of VBA. I can do this task. Please come on chat for more details. Thank you Awaiting your response.
$50 USD em 2 dias
4,4 (48 avaliações)
4,5
4,5
Avatar do Usuário
About me & what I can provide - • I can match and find the errors • 5 Yrs. of Experience in Excel & VBA. • Knowledge of Formatting, Graphs, Chart & Formulas. • Macro coding for complex tasks possible. • Have worked directly with client for an MNC IT Company. • High Accuracy. • Work in tight deadline.
$100 USD em 3 dias
4,9 (23 avaliações)
3,8
3,8
Avatar do Usuário
Thanks for the opportunity to bid on the project. Overall what you are asking for is pretty simple. I can definitely deliver the solution and then provide adequate training on the process design and continued maintenance. In order to facilitate I will do the following: 1) The code will be properly commented 2) I will include standard error handling in the files Depending on the size of the excel files, performance is something that we should consider, however there are other processes and technologies that we can use should VBA not prove workable From a process standpoint I propose the following functionality and have the following questions: 1) We maintain a configuration file that you can use to change the various attributes of where you want to program to execute, e.g. allow you the ability to change the input directories 2) Do you require any additional validation rules to be programable or executed in the comparison, i.e. looking for duplicate entries 3) In what format do you want your validation reports to be presented Feel free to send me a chant should you want to chat. It is your project and you should be happy with what you receive.
$55 USD em 2 dias
4,9 (10 avaliações)
3,9
3,9
Avatar do Usuário
Hello, So as I understood, you need to make sure that all data in 280 files are successfully imported to the workbook, then in case of any problem you need it to be solved by me. Yeah, that can be done with some focus and I can take this responsibility as such task was my daily practice at work. Please let me know if you are interested in my offer. Thank you Waseem
$111 USD em 3 dias
4,9 (5 avaliações)
3,3
3,3
Avatar do Usuário
-Computer Engineer with 4 years of professional Access/Excel/Outlook VBA experience doing projects precisely like this -Easiest way to guarantee all data from input files are in output workbook is to create a macro that will do it. However, if you need a different solution, I will tell you upfront if I can do it and the time it will take. No lies, no exaggeration -Code ready for testing in 4-5 hours. -Flexible with project requirements meaning if you wish to add additional features after the project has begun, I can accommodate those requests -Continued free support in the event of code errors or oversights on my or employer's part (oversights = user utilizes workbook in a way that neither of us foresaw that may cause issues if not accounted for) -Native English proficiency (K-12 in an American school + Bachelor's from USA) -New to Freelancer & eager to work so please consider giving me a chance
$77 USD em 3 dias
4,2 (3 avaliações)
2,2
2,2
Avatar do Usuário
Hello, I would like to take this opportunity to introduce myself. My name is Satish Chandra and am an expert in Visual Basic for Applications (VBA - Macros) automating complex Excel based reports, having an experience of 18 years. My other accomplishments are - Am and an expert in writing complex Excel based macros with 15+ years of experience. - Have held several senior level positions during my professional career spanning over 18 years. - Have around 5 years of experience handling 8 teams concurrently PAN India as a Senior Manager. - An expert in data visualization tools like Tableau. - Developed a few applications in Android Studio for Android platform which involves writing code in native Java and XML. - Have also successfully completed the course in PMP from Simplilearn earning 35 Personal Development Units (PDUs). Exam is scheduled on 4th December, 2018. - Have keen interest in Six Sigma, TQM and management methodologies like PDCA, Herzberg's X and Y theory, McGregor's Hygiene theory and am a protagonist of Kanban, Kaizen and Continuous Improvement. - Have scored 7 out of 9 in IELTS certification. - Have been certified for Java, HTML, CSS, JavaScript, jQuery, PHP and mySQL by the Cambridge Certification Authority. My niche is that if any error/glitch is present in the project, I will provide support for it up to 15 days post final payment or submission of the project (whichever date is earlier), free of Cost. Thanks & Regards Satish Chandra +91-9999986050
$155 USD em 3 dias
4,8 (2 avaliações)
1,6
1,6
Avatar do Usuário
"Greetings! According to your stated project description you need an excel expert. I read your job description and understood. Yes, my experienced service will help you all about MS program. Just send me all of your requirements to start your project. I think no need to talk about the quality because I think provided work will proved it. I will be in touch with you any time you need. Looking forward to hearing you. Waiting for your kind response. Best Regards."
$150 USD em 4 dias
5,0 (2 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) GERMANY
Frankfurt Am Main, Germany
5,0
34
Método de pagamento verificado
Membro desde nov. 26, 2010

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos 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)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.