Browse categories
Explore
Fiverr Pro
English
$
USD
I will automate your excel workflow using power query and vba
Creation and optimization of dashboards in Power BI and advanced Excel.
Design of effective visualizations for strategic decision making.
Development of interactive and customized reports for differ...
About this Gig
Stop wasting hours on repetitive manual tasks. If you are still copying, pasting, and cleaning data manually every day, you are losing valuable time and money.
With over 5 years of experience in Data Analysis and Automation, I specialize in building one-click solutions using Power Query and VBA Macros.
What I can do for you:
- Automated Data Cleaning with Power Query
- Custom VBA Macros for reports, PDFs and automated emails
- Dynamic Dashboards that update instantly with new data
- Advanced Formulas: XLOOKUP, INDEX/MATCH and complex logic
- Data entry forms and validations to prevent human errors
Why choose my service:
- Professional IT and Data Instructor with clean, documented code
- Tailored solutions built for your specific business needs
- Post-delivery support and guidance included
Perfect for: Financial reports, Inventory management, Sales tracking and HR data.
Every project is unique. Contact me before placing an order to discuss your needs and ensure the best solution for your data.
Let's automate your workflow today.
Technology:
Python
•
Excel
•
VBA
Technique:
Automated
FAQ
Does your automation work on both Windows and Mac?
My Power Query and VBA solutions are optimized for Excel on Windows. Please note that Excel for Mac has significant limitations with VBA macros and certain Power Query connections. If you use a Mac, please message me before ordering so I can confirm if your specific automation is possible.
Can you automate data from multiple files or folders?
Yes! One of my specialties is using Power Query to combine dozens of Excel, CSV, or PDF files into a single, clean master table. Once the setup is done, you will only need to click "Refresh" to update your entire report with new data.
Will I be able to update the file myself after you deliver it?
Absolutely. I build "one-click" solutions designed for non-technical users. I will provide a brief set of instructions (or a quick video) showing you exactly where to put your new data and how to trigger the automation. You won't need to touch the code or complex formulas.
Reviews
1 reviews for this Gig
| (1) | ||
| (0) | ||
| (0) | ||
| (0) | ||
| (0) |
Rating Breakdown
- Seller communication level
- Quality of delivery
- Value of delivery
Sort By
Most relevant
M 
maria_sanp
Colombia
The work completely exceeded my expectations. From the beginning, the freelancer demonstrated a high level of professionalism, commitment and attention to detail. Communication was always clear, timely and proactive, which made the whole process very smooth. Not only did she comply with what was requested,...
Up to $50
Price
2 days
Duration
Helpful?
Reviews
1 reviews for this Gig
| (1) | ||
| (0) | ||
| (0) | ||
| (0) | ||
| (0) |
Rating Breakdown
- Seller communication level
- Quality of delivery
- Value of delivery
Sort By
Most relevant
M maria_sanp
Colombia
The work completely exceeded my expectations. From the beginning, the freelancer demonstrated a high level of professionalism, commitment and attention to detail. Communication was always clear, timely and proactive, which made the whole process very smooth. Not only did she comply with what was requested,...
Up to $50
Price
2 days
Duration
Helpful?
