I will build automated excel dashboard with vba and power query
Excel , Power BI Expert , Microsoft Certified Trainer
About this Gig
Tired of manually updating spreadsheets every week?
I'm Palash, a Microsoft Certified Trainer (MCT) with 16+ years of Excel, VBA, and Power Query experience trained 1000+ professionals including teams at Ministry of Finance Bangladesh, Beacon Pharmaceuticals, and Asian Development Bank.
I build smart, automated Excel dashboards that turn raw data into real results:
- Power Query clean and merge your data automatically
- VBA Macros automate repetitive tasks with one click
- Auto-Refresh dashboard updates the moment new data arrives
- Dynamic Dashboard interactive KPIs, trends, and charts
Perfect for sales dashboards, HR trackers, finance reports, or inventory monitors designed around your business needs.
Why work with me?
- Microsoft Certified Trainer (Excel Expert + Associate)
- 16+ years hands-on Excel/VBA/Power Query experience
- Clear communication, on-time delivery, 100% quality guaranteed
Message me before ordering if you have custom requirements!
Platform:
Excel
•
VBA
Development technology:
VBA
•
Power Query
•
Excel
Expertise:
Forms
•
Functions
•
Macros
•
Power Query
•
Modeling
FAQ
What Excel version do I need?
Excel 2016 or later (Windows) for full VBA and Power Query support. Mac Excel has limited VBA compatibility — please message me first if you're on Mac.
Can you connect the dashboard to my live data (Google Sheets, database, etc.)?
Yes, this is possible as a custom order — please contact me with details before ordering.
Will I be able to edit the dashboard myself later?
Yes, I'll provide clear instructions, and with the Premium package you'll also get a training video.
