Find Jobs
Hire Freelancers

Excel VBA/Query Automation Expert - Ongoing Role

$9-15 USD / hour

Closed
Posted almost 3 years ago

$9-15 USD / hour

Hello - I am a co-owner of a company with ~2000 employees and looking for a developer to help us automate/improve some of our excel reports. The ideal candidate would have substantial experience in the following: • VBA/Macros • Power Query/query with the merging of multiple database tables • Excel reporting We currently have 8-10 reports that automatically get sent out from our virtual machine, and we are looking to add/optimize to these reports. This freelancer gig is probably 10-15 hours a week and would last no less than a year. We prefer individual freelancers versus groups but are open to either. Experience in Power BI and SQL is a plus but not required. Please let me know if you have any questions. Thanks!
Project ID: 30617119

About the project

33 proposals
Remote project
Active 3 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
33 freelancers are bidding on average $14 USD/hour for this job
User Avatar
ID : 30617119 Greetings, If the project needs an onsite visit , deployment & training etc, we can arrange for the same at your cost. We did recently 3 visits to couple of Australia based factories in last couple of years. We are interested to work on this project, please find my comments inline with yours, Hello - I am a co-owner of a company with ~2000 employees and looking for a developer to help us automate/improve some of our excel reports. => We are Microsoft Access and SQL server database developers, about the experience My senior colleague has over 21 years experience and I have a 7 year of experience in building Microsoft access databases for various industry types and purpose, we do have contracts with couple of companies for long-term support. We worked on over 530 Microsoft Access projects till now. It is a great tool when scaling-up and excellent reporting features. What version of MS Excel? 2007/2010 or on ward? let me know data tables is exists in the excel file or Ms Access or SQL server?Please provide the details of reports, how many reports you want to generate?What output fields you want to display on report etc Regards, Sonali
$12 USD in 40 days
5.0 (96 reviews)
6.4
6.4
User Avatar
Hi, I am interested in working on the Project. I have 7 years of experience working with Excel VBA Macros , Data Analysis, Generating reports, creation of dashboards in excel. I would like to know more details about the project and output requirement. Looking forward to hear from you and work on this project . Best Regards, Akila.K
$10 USD in 40 days
5.0 (25 reviews)
5.5
5.5
User Avatar
Hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. I feel fit myself for this project. please contact with me. Thanks.
$12 USD in 40 days
5.0 (2 reviews)
3.1
3.1
User Avatar
Hi Sir , I am an expert and worked on many complex projects before , Let's have a discusiion over chat , You will get the excellent results at lowest price is here only. (5$/hour only). just try my services once. Thanks.
$9 USD in 28 days
4.6 (7 reviews)
3.1
3.1
User Avatar
Hello Greetings to you!! I am an Excel (Macro)/Visual Basic expert and interested to work with your project. I have checked your requirements and that makes complete sense to me. I assure you of a high-quality job. Please let me know when we can start. We have worked on 20+ Projects. I have 8 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion. Also check my Portfolio https://www.freelancer.com/u/Krupamapara?page=portfolio&w=f&ngsw-bypass= Thanks & Regards Krupa M. India
$12 USD in 40 days
4.9 (7 reviews)
2.5
2.5
User Avatar
HI hope you doing well, I am qualified and experienced senior VBA/RPA Developer having 12+ years of experience in developing automation projects. I has done tons of projects using VBA,RPA,Power queries and other Technologies. I can give my full effort to deliver the project in on time with 100% quality and accuracy...I'm waiting for your kind response.
$10 USD in 40 days
5.0 (3 reviews)
2.2
2.2
User Avatar
Hi, I can help you with this. Could you please send me an example so i could see what type of work i can expect? Thanks, Dominik
$15 USD in 40 days
5.0 (2 reviews)
2.1
2.1
User Avatar
Hello, I am a data science engineer andI have 4+ years of experience. Looking forward to work with you. Regards
$9 USD in 40 days
5.0 (2 reviews)
1.2
1.2
User Avatar
Hi, checked your requirement, I am working on different types of dashboard & Automation using VBA CODE, Advance Excel, EXCEL Dashboard, POWER BI VISUALIZATION WITH DAX, Power query etc. ( database JSON file,CSV,MYSQL,SQL SERVER,EXCEL,CRM) please check my portfolio for more details (Mostly Saturday Sunday works) thanks best service for you TANVEER SINGH
$13 USD in 20 days
5.0 (1 review)
1.1
1.1
User Avatar
Hi dear, I am a Data Manager and MS Excel expert with over 10-years experience in using the application for writing programs with inbuilt function, VBA, Excel Report presentation and merging of multiple excel workbooks containing database, and I'm available to assit you as described and required Please chat me up to discuss further. Thanks
$10 USD in 30 days
5.0 (1 review)
0.0
0.0
User Avatar
Hi there, I have a years of experience in MS Excel a/ Macro / VBA & google sheets (Working on Mac & windows) , I will do this task with super quality , accuracy and provide to you with in committed time period. kindly visit my freelancer profile for more and accurate information. Thanks & Regards, Pal.R
$10 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, In numerous roles I have written, rewritten, supported and documented many applications using many of the VBA functions and automations within Excel. I have 30 years experience in the finance/banking/risk industries and have a very strong value of the work required for clients. I have created numerous VBA applications from simple automation of repetitive tasks to full applications processing many thousands or data rows and/or dollars. I can certainly create / modify the existing VBA code to your requirements and is certainly well within my experience. I've created numerous Excel applications that import / export data to MS SQL based on various business rules. I've not used Power BI, but am proficient in MS SQL and an export in Excel/VBA. I regularly do webinar sessions with other clients in the US for training / application review, so be able to support this from Australia is relatively easy and I'm able to commit to the weekly requirements over a longer period of time. I look forward to discussing the project with you in further detail. Regards, Darren
$20 USD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Sir/Madam, I am Sucipto Angdika from Indonesia, I'm an Individual Freelance, I'm new to Freelancer.com, but I have good Excel skills. I usually work with Excel Named Range Table + Data Connection so that I could pull data from another workbook files (even the closed one). Once the connection to external raw data is settled (imported), then we'll create connection between these imported tables data, manipulating them for analyze and create automatic generate values reporting forms based on your needs. My goal is to make a template file which is if it is given the new raw data files, then all you have to do is just click Refresh All button to update this file raw data with new raw data set, then its formula will processing automatically so that the report forms too will be auto generated. Kindly share me the details of the project so that I could send you file preview of how your project would be finished by me. Thank you for your attention.
$9 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have gone through your requirements and I am absolutely sure that I can do the project very well. I have 8+ years of experience in Relevant Technologies so I would be a good fit for this position. I am always trying to find best solution for client about price and quality. I am looking for long term contract and relation. I provide realistic deadlines that I always met. I’m fulltime freelancer and available on daily basis. Regards, Hina
$15 USD in 40 days
0.0 (0 reviews)
4.2
4.2
User Avatar
Hi, I've worked on Excel for >20 years with Fortune 50 companies. No longer in corporate world, doing full time freelance now. Hence, I can dedicate full time for this project. Chat me for a link to demo videos I did. You can decide if I am the right candidate after watching the videos Hope to hear from you. PS: I have recently completed a project with a client on another platform. He has written a positive review for me. I can share the screenshot with you on chat.
$15 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, Large data very interesting. Please share your requirement of report with parameters ( Excel Report Condition ) from table. We ready to improve your business requirement of report.
$11 USD in 15 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, Thanks for reading my response. I have gone through the project ”Excel VBA/Query Automation Expert - Ongoing Role” and I can offer you the best solution on it. I am a Professional VBA / Dashboard developer with over 10 years of working experience with different organizations. I have developed so many dashboards and applications forms in Excel. My expertise are as under: 1. Any Type of Excel Function / Formula you need in Excel 2. Automated and Dynamic Dashboards 3. Working With Power Tools (Power Query, PowerPivot, Power View and DAX Functions) 4. VBA projects 5. Advanced Filters 6. Google Forms and Sheets 7. Google Data Studio 8. Advanced Graphs like Thermometer, Tachometer, Traffic Signals, Dual color column / Bar chart 9. ++More Projects we have done: 1. Sales/Revenue Performance Analytics 2. Business Operations Analytics 3. Accounts/Finance/Treasury Analytics 4. Fixed Assets and Inventory Analytics 5. Social Media Analytics 6. HR Analytics 7. Survey Analytics 8. Governance, Risk and Compliance Reports 9. Commercial Dashboards Why choose me? 1. Unlimited Revisions 2. Fast Turnaround 3. Provide Video tutorial of the Reports 4. Excellent communication 5. Client satisfaction is my first priority 6. High Quality work If interested, please open PMD (message board) so we can talk and possibly move forward. Looking forward to your positive response. Regards, Abid Maqsood
$10 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I am the perfect candidate for your project, I am an expert in power BI, I have experience to build a dashboard, look at my portfolio and you will find out for yourself, if you like what you see contact me.
$12 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Microsoft certified Trainer in DA 100. VBA automation and DAX expert, with experience in training and development. Total work ex of 8 year into Data analysis and automation. connect for further queries
$14 USD in 16 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
brandon, United States
5.0
71
Payment method verified
Member since Jan 31, 2017

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.