Browse categories
Explore
Fiverr Pro
English
$
USD
I will build an excel dashboard with power query pivots and vba automation
Advanced Excel Expert and Data Automation Specialist
I don’t just build spreadsheets—I create automated systems that make work easier and decisions clearer.
With 3 years of hands-on experience in Excel and e-commerce, I turn messy data into practical to...
About this Gig
Welcome! I build automated systems that run your business efficiently. With hands-on experience managing e-commerce operations across 7 marketplaces, logistics, and ERP data, I turn messy data into a powerful command center.
Whether you need a simple tracker or a fully automated system, I can help you.
Here is what I offer:
- Dashboards: Interactive Excel & Power BI dashboards with slicers, dynamic charts, and automated KPIs.
- Automation: VBA/Macros and Power Query to eliminate repetitive tasks and cut manual reporting time.
- Business Trackers: Systems for sales, stock management, and logistics (NDR/RTO tracking).
- Data Cleaning: Flawless PDF-to-Excel extraction, deduplication, and data modeling for your team.
- Complex Formulas: XLOOKUP, nested IFs, INDEX/MATCH, and dynamic arrays tailored to your exact needs.
Why work with me? I understand real-world business problems, not just textbook Excel functions. I pride myself on accuracy, fast turnarounds, and building systems that are easy for your team to use.
Note: Please message me before ordering so we can discuss your exact project requirements!
Platform:
Excel
•
Google Sheets
•
Power BI
Development technology:
VBA
•
Excel
•
VLOOKUP
Expertise:
Formatting
•
Formulas
•
Macros
•
Dashboard
•
Data validation
FAQ
Can you handle inventory and sales data from platforms like Amazon or Shopify?
Yes! I specialize in building automated trackers for e-commerce brands. Whether you need to manage stock levels, track NDR/RTO, or analyze sales from Amazon Seller Central, I can build a custom system that connects your marketplace data into one easy-to-read operational dashboard.
I have messy data stuck in PDF statements. Can you convert and clean it in Excel?
Absolutely. Extracting and cleaning data from PDFs is one of my specialties. I use Power Query and advanced data modeling to pull your PDF reports into Excel flawlessly, organizing them into a clean, usable format so you can actually analyze the numbers.
Will I need to know how to code or use VBA to run the dashboard you build?
ot at all! I design my automated systems to be completely user-friendly for you and your team. I handle all the complex coding behind the scenes and provide you with a clean interface. Often, updating your reports or running a complex macro will be as simple as clicking a single button.
What do you need from me before I place an order?
Please send me a message before ordering so we can discuss your exact needs. It is incredibly helpful if you can provide a sample of your current spreadsheet or raw data, along with a brief explanation of the final result you are trying to achieve.
