Browse categories
Explore
Fiverr Pro
English
$
USD
I will automate your excel spreadsheet with macros and power query
About this Gig
Are you doing the same Excel tasks over and over every week? Copy-pasting, formatting, generating reports manually that is hours of your day wasted.
I build automated Excel solutions using VBA Macros and Power Query so your spreadsheet does the heavy lifting for you. One click and it is done.
What I can automate for you:
Repetitive reports that update automatically Data cleaning and formatting on demand Custom buttons that trigger any process with one click Power Query connections that refresh your data automatically VLOOKUP, XLOOKUP, IF formulas and complex logic
Why work with me?
I deliver fully unlocked files with open source code. You and your team can edit everything after delivery. No black boxes, no dependency on me.
Send me a message describing your current manual process before ordering. If I can automate it, I will tell you exactly how.
Platform:
Excel
•
Google Sheets
•
VBA
Development technology:
VBA
•
Power Query
•
VLOOKUP
Expertise:
Pivot tables
•
Formulas
•
Macros
•
Power Query
•
Cleaning
FAQ
Will I be able to edit the file later?
Absolutely! I always deliver the final Excel file fully unlocked with open source code (VBA). You or your team will have full control to make future adjustments.
What information do I need to provide?
Attach your current Excel file with sample or dummy data, explain step by step the manual process you currently do, and describe exactly how you want the final result to look.
What if my process is too complex?
Send me a message before ordering and I will tell you honestly if it is doable and how long it will take. No surprises.
