Browse categories
Explore
Fiverr Pro
English
$
USD
I will build excel automation using power query and macros
About this Gig
Tired of repeating the same Excel tasks?
Let me help you automate your data workflows using Power Query and Excel Macros (VBA). I specialize in transforming raw data into clean, organized reports that update with a single click.
Data cleaning, filtering, removing blanks/duplicates
Merging and transforming multiple tables
Dynamic dashboards and pivot table prep
Custom Excel macros to automate repetitive tasks
Button-triggered workflows and logic-based automation
Whether it's a simple cleanup or full automation pipeline, Ill deliver a reliable and optimized Excel solution tailored to your needs.
Message me before ordering to discuss your file and requirements.
Platform:
Excel
•
Power BI
•
VBA
Development technology:
Power Query
•
RStudio
•
VLOOKUP
Expertise:
Pivot tables
•
Formulas
•
Macros
•
Power Query
•
Charts
FAQ
What do I need to share before ordering?
Please send your Excel file(s) with a short description of what you want automated or cleaned.
Can I get a macro that runs with a button?
Yes, I can create buttons to run your macro tasks smoothly.
Do you use VBA or only Power Query?
I use both depending on your need—Power Query for transformation, VBA for automation.
Can you connect Excel to an external data source (like another file or web)?
Yes, I can set up Power Query to pull data from other Excel files, CSVs, or online sources (like web pages or SharePoint). Just let me know your source format.
I don't know what Power Query or Macros are—can you still help me?
Absolutely! You just need to tell me your Excel problem or task. I’ll choose the right tool (Power Query or VBA Macro) to automate or clean your data.
Do you offer documentation or explanation for what you build?
Yes, Premium packages include full documentation. For other packages, I can explain the process or add notes in the file upon request.
Can you add a custom toolbar or ribbon buttons in Excel?
Yes, in the Premium package I can create a custom Excel Ribbon or toolbar buttons to trigger macros for a smoother user experience.
Will my data stay confidential?
100%. Your data will be used only for your project and never shared. I can also sign an NDA if required.
What if I’m not satisfied with the result?
I offer revisions based on your package. You can request adjustments, and I’ll work with you to ensure it meets your expectations.
