I’m looking for an experienced Excel specialist to build an automated performance dashboard for my estate agency group.
We have six Sales offices and six Lettings offices, and I want to track daily performance metrics from two data sources: 1. Call logs (exported from our phone system) 2. Reapit CRM reports (valuations, viewings, instructions, offers, sales agreed, exchanges, etc.)
The aim is to have one Excel workbook that I can easily update each day by pasting in new data or refreshing Power Query connections. The dashboard should automatically show: • Individual Negotiator activity (calls, talk time, performance vs target) • Office-level summaries for each of the 12 branches • Department-level views (combined Sales and Lettings totals) • A simple front page with clear charts, slicers (Office / Negotiator / Date), and key KPIs.
⸻
What I Need: • Build an Excel-based dashboard with dynamic visuals and KPIs • Automate data refresh (via Power Query or macros) • Create clean dashboards for: • Individual negotiators • Each office (6 Sales, 6 Lettings) • Department summaries (Sales & Lettings) • Use a clean blue and white theme with easy navigation • Include a short guide or Loom video showing how to update the data daily
⸻
Skills Required: • Advanced Excel (Power Query, PivotTables, Dashboard Design) • Strong visual layout and performance reporting experience • Familiar with CRM or sales data structures (Reapit experience a plus) • VBA experience (nice to have but not essential)
Social Media Translation Specialist -- 2 Category: Content Creation, Content Writing, Copy Editing, Copywriting, Marketing, Social Media Management, Social Media Marketing, Translation Budget: $250 - $750 USD
23 Dec 2025 05:02 GMT
Paytronix-Integrated Website Development Category: API Development, Frontend Development, HTML, JavaScript, PHP, REST API, Web Development, Web Design Budget: $1500 - $3000 USD
23 Dec 2025 05:01 GMT
Vibrant Instagram Photo & Video Edits Category: After Effects, Audio Editing, Background Removal, Photo Editing, Video Editing, Video Post Editing, Video Production Budget: ₹750 - ₹1250 INR
Social Media & Marketing Manager - Multi-Brand Portfolio -- 3 Category: Brand Management, Content Creation, Digital Marketing, Facebook Marketing, Google Ads, Internet Marketing, Social Media Management, Social Media Marketing, Twitter, WordPress Budget: $250 - $750 USD
Custom Organizer App Development Category: Android, App Design, Graphic Design, Mobile App Development, UI / User Interface, User Interface / IA, UX / User Experience, Web Development Budget: $15 - $25 USD
23 Dec 2025 04:55 GMT
Copy PHP Site Content to WordPress Category: Database Management, HTML, PHP, Web Design, Web Development, Website Management, WordPress Budget: ₹600 - ₹1500 INR