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)
Support Marketing Campaigns (Social Media) Category: Content Creation, Content Marketing, Digital Marketing, Facebook Marketing, Marketing, Photo Editing, Photoshop, Social Media Management, Social Media Marketing, Video Editing Budget: €8 - €30 EUR
Saw Blade Marketing Specialist Category: Blog Writing, Content Creation, Digital Marketing, Facebook Marketing, Instagram Marketing, Internet Marketing, Marketing, Marketing Strategy, SEO, Social Media Marketing Budget: $250 - $750 AUD
Pelatihan Motivasi Percaya Diri - 18/01/2026 05:46 EST Category: Conflict Resolution, Life Coaching, Motivational Speaking, Personal Development, Psychology, Public Speaking, Training Development, Workshops Budget: $10 - $30 USD
18 Jan 2026 10:56 GMT
Bantu Kembangkan Web React.js Lanjutan Category: Frontend Development, Git, GraphQL, JavaScript, React.js, REST API, User Interface / IA, Web Development Budget: $200 - $300 USD
18 Jan 2026 10:54 GMT
Happy Hotis E-Commerce Website Category: Android, Database Management, ECommerce, Laravel, Mobile App Development, Payment Gateway Integration, PHP, Web Development Budget: ₹12500 - ₹37500 INR
18 Jan 2026 10:54 GMT
Ready-Made Payment Gateway Platform Category: Android, API Integration, JavaScript, OAuth, PHP, REST API, Software Architecture, Web Development Budget: $250 - $750 USD
18 Jan 2026 10:54 GMT
iOS App Launch and ASO Category: App Development, App Store Optimization, Internet Marketing, IOS Development, IPhone, Mobile App Development, Mobile App Testing, Testing / QA Budget: $250 - $750 USD
