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)
Arabic Video Social Media Manager Category: Content Writing, Digital Marketing, Facebook Marketing, Instagram Marketing, Social Media Management, Video Editing, Video Production Budget: €30 - €250 EUR
CRM Online Energía y Telecomunicaciones Category: API Development, CRM, Database Management, HTML, PHP, Software Architecture, Web Development, Web Design Budget: €250 - €750 EUR
03 Nov 2025 17:02 GMT
Hindi-English Educational Material Translation Category: Content Writing, Editing, English (US) Translator, English Spelling, English Translation, Hindi Translator, Language Tutoring, Translation Budget: ₹1250 - ₹2500 INR
03 Nov 2025 17:01 GMT
Cottage Renovation Floor Plan Category: 2D Drafting, 3D Rendering, AutoCAD, Building Design, Floor Plan, Interior Design Budget: $750 - $1500 CAD
Google & Social Media Ad Plan Category: Digital Marketing, Facebook Ads, Facebook Marketing, Google Ads, Instagram Marketing, Internet Marketing, SEO, Social Media Marketing Budget: £750 - £1500 GBP
03 Nov 2025 17:00 GMT
Alianza Estratégica para Innovar Productos Category: 3D Design, 3D Modelling, 3D Printing, CAD / CAM, Fusion 360, Mechanical Engineering, Product Design, Solidworks Budget: $30 - $250 USD
