I will build an excel management dashboard with checked kpis


About this gig
I will turn your clean operational spreadsheet into an Excel dashboard that answers a clear business question.
I bring practical experience in operations, logistics and management reporting. We agree the KPI definitions first, so the dashboard measures what you actually need.
Your workbook includes a restrained summary page, supporting data, calculations, charts and a refresh guide. Standard and Premium add agreed interactive selectors and a written management summary. I validate totals and test the supplied sample against the source.
Each package covers one workbook and one dashboard page. KPI and chart counts are separate. Input data must be structured and reasonably clean; substantial cleaning or reconciliation is quoted separately before purchase.
Please share a redacted sample, reporting period, KPI definitions and your Excel version. I will confirm compatibility and scope before accepting. Power BI, VBA, cloud hosting and live API feeds are outside these packages.
Confidentiality and AI preferences are agreed before processing.
Get to know Jannes V
Excel Data Cleaning, Reconciliation and Reporting
- FromSouth Africa
- Member sinceAug 2017
Languages
English, Afrikaans
FAQ
Will it update when I add data?
The workbook includes a defined refresh method and capacity. We test the agreed method with sample data. Changes to source columns or KPI definitions need review.
Can you add filters?
Standard includes one agreed selector; Premium includes two. Exact controls depend on your Excel version and a tested implementation.
Do you build Power BI dashboards?
This offer is for Excel. Power BI is not included.
Do you include pivot tables and slicers?
Only when agreed and verified in your target Excel environment. The initial template uses tested formulas, tables, charts and dropdown selectors.
What if the data is dirty?
I will identify the issue during sample review and quote cleaning separately before purchase. I will not hide data problems behind a chart.
Do you decide my KPIs?
I propose useful measures from your objective, but you approve the business definitions and acceptance examples.
What does a revision cover?
Changes to layout or calculations within the agreed KPIs and sources. New KPIs, sources or substantial redesign are separate scope.

