I will create an automated excel dashboard with pivot tables


About this gig
Tired of messy spreadsheets and reports you rebuild by hand every week? I will build a professional Excel dashboard that updates when you add new data.
What I can do:
- Interactive dashboards with pivot tables, pivot charts and slicers
- KPI summaries: daily, weekly, monthly, by department, product or customer
- Formulas: XLOOKUP, INDEX MATCH, SUMIFS, dynamic arrays
- Power Query to clean and combine files automatically
- Data entry templates with dropdowns and validation
- Trackers for sales, inventory, production, attendance and budgets
- Fixing and tidying an existing workbook
Why work with me:
- I build production and management reports in Excel regularly
- Clean layout and professional colours, ready to show your manager
- Formulas are left visible and editable, nothing hidden
- Short guide on how to refresh and maintain the file
Please message me with your file or data so that I can confirm the scope and the right package.
Your data stays confidential.
Get to know Shakib'
Power BI and Dashboard Specialist, Advanced Excel and Data Analytics
- FromBangladesh
- Member sinceNov 2026
- Avg. response time1 hour
Languages
Bengali, English, Hindi
My Portfolio
FAQ
1. Which Excel version do I need?
Excel 2019 or Microsoft 365 works best. Tell me your version and I will avoid functions it does not support.
1. Will it update when I add data?
Yes. Add rows to the data sheet and click Refresh All.
1. Do you use macros or VBA?
Only if you ask. I prefer formulas and Power Query so the file opens without security warnings.
1. Can you fix my existing file instead of building a new one?
Yes. Send it in a message first so I can quote the right package.
1. Can it work in Google Sheets?
Most dashboards can. Add the Google Sheets extra or ask before ordering.

