Excel-based Harmonised Reporting System Design

The Bauchi State IBSDLEIP programme requires a harmonised reporting system to collate sector submissions, monitor programme-wide progress, and prepare AfDB-aligned quarterly reports. Sector leads currently use individual templates, while the SPIU M&E Unit consolidates data into an overall workbook. To streamline this process, a professional Excel-based reporting system is needed.
I need an experienced Excel specialist to design a professional reporting system for my programme. The job involves creating sector-specific input sheets and an overall M&E/QPR workbook that consolidates data, calculates progress automatically, and generates dashboards for management reporting.

Key tasks:
• Build sector templates with editable fields (current values, female/male beneficiaries, evidence references, comments, action required).
• Lock formula-driven fields (progress %, female share %, performance status).
• Create dropdown lists for validation and performance status.
• Design an overall workbook with a Master Indicator Register, collation sheet, and automated dashboard (pivot tables + charts).
• Add executive summary and risk/issues sheets for management interpretation.
• Provide a short user guide and a walkthrough session for my team.
Requirements:
• Strong Excel skills (pivot tables, Power Query, formulas, conditional formatting).
• Experience designing dashboards and reporting templates.
• Familiarity with monitoring & evaluation (M&E) frameworks or AfDB/World Bank reporting standards is a plus.
Deliverables:
• Sector workbook template.
• Overall harmonised M&E/QPR workbook.
• Dashboard with charts and KPIs.