URGENT: Senior Excel Dashboard Specialist

I require an experienced Excel dashboard specialist to convert existing Excel data into two fully interactive, visually appealing dashboards, suitable for director-level reporting and PDF export.

All data already exists in Excel. The task is to design, link, and automate dashboards so that KPIs, charts, and summaries update dynamically based on filters.

This work must be completed today (within 12 hours).

Scope of Work
1. Project-Specific Dashboard (A4 – Print Ready)

One dashboard per project (template-based, scalable)

Header to dynamically display:

Project name

Reporting period / week

Fully interactive filters:

Project

Week number

Trade

Labour category (if applicable)

Required KPIs (all must update with filters):

Total hours worked

Hours by trade

% labour distribution by trade

Weekly hours comparison

Any cost or productivity KPIs already present in the data

Charts & Visuals:

2 summary charts, e.g.:

Labour hours by trade

Weekly labour spread

Clean, professional layout (improve existing design)

Visually appealing but suitable for senior management

Output:

A4 layout

Button to export dashboard directly to PDF

Suitable for filing as part of a project history record

2. Labour Overview Dashboard – All Projects

High-level dashboard covering all jobs

Focus on:

What was worked on in a given week (e.g. Week 2)

Distribution of labour hours across projects

Trade-level labour spread

Interactive slicers to allow directors to:

Change week

Filter by project

Filter by trade

Key Requirements:

All KPIs and charts respond instantly to filter changes

Clear overview of where labour hours are being spent

Designed for decision-making and trend analysis

Technical Requirements

Excel (no Power BI)

Use of:

Pivot tables / pivot charts

Slicers / timelines

Dynamic formulas where required

Dashboard must be:

Stable

Easy to update with new data

Scalable for future projects

One-click “Export to PDF” button (VBA acceptable)

Key Goals (Non-Negotiable)

All KPIs must move when filters change

Interactive and visually polished

Director-ready reporting

Printable to PDF

Delivered within 12 hours

What I Will Provide

Excel file with all source data

Screenshot / example of the intended layout

Clarification on KPIs if needed (but freelancer should be able to interpret data structure independently)

Ideal Freelancer

Advanced Excel dashboard developer

Strong design sense (not just technical)

Experience creating print-ready dashboards

Comfortable working under tight deadlines