I will build automated excel KPI dashboards and reports


About this gig
Need a clean Excel dashboard that updates automatically and gives you instant business insight without expensive software?
I build Excel dashboards that are clear, interactive, and built around what your business actually tracks. And because I trained as an accountant, I design them around real business logic not just charts that look busy.
I build:
- Sales & revenue KPI dashboards
- Financial performance trackers
- Inventory & stock reports
- Team / employee performance dashboards
- Weekly & monthly automated reports
Every dashboard includes:
- Dynamic charts & pivot tables
- Slicers & filters for interactivity
- Conditional formatting & alerts
- Clean layout built for non-technical users
- Editable template you can update yourself
I use formulas, pivot tables, and Power Query for automation (VBA/macros on request, Premium).
Message me first with your data file so I can recommend the right package. Let's make your reporting effortless.
Get to know Patrick G
Data Analyst and Accountant Power BI, SQL, Excel
- FromKenya
- Member sinceMar 2024
- Avg. response time1 hour
Languages
English, Swahili
My Portfolio
FAQ
Which Excel version do you use?
Excel 365/2019, compatible with 2016+. Tell me if you need older-version support.
Can you automate my monthly reporting?
Yes — that's the Premium package. You paste new data and the charts update automatically.
Can I update it myself after delivery?
Yes. I design for non-technical users and include a short how-to note.
Do you use macros/VBA?
I default to formulas, pivot tables, and Power Query. VBA is available on request (Premium).
My data is messy — is that a problem?
No. Standard and Premium include cleaning before the build.
