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)
Drone Land Survey Footage Category: Aerial Technical Site Survey, After Effects, Cinematography, Drone Photography, Editing, Photography, Video Editing, Video Post Editing, Video Production, Video Services Budget: €30 - €250 EUR
24-Feb-2026 11:02 GMT
Detailed Terrain Model for Urban Planning Category: 3D Design, 3D Modelling, 3D Rendering, 3D Visualization, Building Architecture, Cartography & Maps, Geographical Information System (GIS), SketchUp Budget: $10 - $30 USD
24-Feb-2026 11:02 GMT
Cobblemon Modpack & Server Setup Category: Content Creation, Documentation, Game Design, Game Development, Game Testing, Inventory Management, Minecraft, Project Management, Technical Documentation, Technical Support Budget: $30 - $250 USD
24-Feb-2026 11:01 GMT
Create Advanced AI Live Courses Category: Algorithm, Data Science, Deep Learning, Electrical Engineering, Image Processing, Machine Learning (ML), Mathematics, Matlab And Mathematica, Neural Networks, OpenCV Budget: ₹750 - ₹1250 INR
Indian Insurance CRM Development Category: API Development, CRM, Insurance, Mobile App Development, PHP, Project Management, Web Development, Web Design Budget: ₹37500 - ₹75000 INR
Automated WhatsApp Lead Acknowledgements Category: API Integration, Automation, Database Management, HTML, Internet Marketing, PHP, Twilio, Web Development, Web Design, Wix Budget: ₹600 - ₹1500 INR
24-Feb-2026 10:54 GMT
Accelerate Your B2B Business Growth Category: Appointment Setting, B2B Marketing, Business Development, Business Strategy, Growth Hacking, Lead Generation, Market Research, Sales, Sales Management, Strategic Planning Budget: $30 - $250 USD
