Door categorieën bladeren
Ontdekken
Fiverr Pro
Nederlands
$
USD
I will automate your ms excel using power pivot and power query
Data wrangler and dashboard-builder focused on converting HR and ops data into dynamic Power BI insights. Expert in Power Query, DAX, SQL, and Excel. I deliver streamlined models, automated dashboards...
Over deze dienst
Tired of repetitive Excel tasks and messy reports? Let me help you automate your workflow and turn your spreadsheets into dynamic, interactive tools using Power Query, Power Pivot, and VBA.
With years of experience in data analytics and dashboard development, Ill build custom Excel solutions that clean, transform, and visualize your data so you spend less time clicking and more time analyzing.
What I Offer:
- Automated data cleanup with Power Query
- Robust data modeling using Power Pivot
- Interactive dashboards with slicers, filters, and KPIs
- Custom VBA macros (Premium) for forms, buttons, and task automation
- Seamless connectivity to external data sources or APIs (available in higher tiers)
Package Levels:
BASIC (3 days)
A single-page interactive dashboard with Power Query & Power Pivot. Ideal for quick reports or refreshable views.
STANDARD (5 days)
Up to 3 dashboards with thoughtful UI/UX design, slicers, and multi-source support. Great for team reports and operational tools.
PREMIUM (10 days)
Full Excel tool with VBA macros, user forms, task automation, and enhanced interactivity. Perfect for advanced internal tools and multi-user workflows.
Technologie:
Excel
•
Google Sheets
Mijn portfolio
Veelgestelde vragen
What tools do you use for automation in Excel?
I use Power Query for data extraction and transformation, Power Pivot for modeling and calculations, and VBA (Visual Basic for Applications) for automating workflows, buttons, and forms in the Premium package.
Can you connect to external data sources like SQL, SharePoint, or Google Sheets?
Yes! In Standard and Premium packages, I can connect to multiple sources including databases, web services, SharePoint folders, and Google Sheets using Power Query.
What if I need more than 3 dashboards or a larger project?
No problem! Please send me a message with your full requirements, and I’ll create a custom offer tailored to your needs and budget.
What kind of VBA automation can you do?
I can build buttons, user forms, automated tasks, and custom logic flows such as auto-refresh, data export, and validation prompts — perfect for power users or teams.
Do I need Excel installed to use the files you build?
Yes, you’ll need a desktop version of Microsoft Excel (2016 or later). Some features like Power Pivot and VBA won’t work properly in online or mobile versions.
Will the file be password-protected or editable?
By default, files are fully editable. If you need password protection or locked formulas, I can apply that upon request (available in Standard and Premium).
Can you record a tutorial or create documentation?
Yes! I offer walkthrough videos and PDF documentation as gig extras. Just let me know how you’d like the instructions delivered.
