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)
UI Design for CRM Landing Page Category: Figma, Graphic Design, HTML, UI / User Interface, User Experience Research, User Interface / IA, Web Design Budget: ₹600 - ₹1500 INR
24-Mar-2026 11:04 GMT
Modern Clean Figma Showcase Site Category: Figma, Graphic Design, Photoshop, UI / User Interface, User Interface / IA, Web Application, Web Design, Web Development Budget: ₹1500 - ₹12500 INR
Urgent Email Restore & Migration Category: Cloud Computing, CPanel, Linux, Network Administration, PHP, System Administration, Technical Support, Troubleshooting, Web Hosting, Web Security Budget: $10 - $30 USD
24-Mar-2026 10:57 GMT
AI Search Optimization Expert | Rank on Google, ChatGPT & AI Platforms Category: AI (Artificial Intelligence) HW / SW, AI Chatbot Development, AI Content Creation, AI Development, AI Model Development, AI Text To Text, Internet Marketing, Link Building, Search Engine Marketing (SEM), SEO Budget: ₹75000 - ₹150000 INR
24-Mar-2026 10:55 GMT
Social Media Manager Πωλήσεων Αυτοκινήτων Category: A / B Testing, Advertising, Analytics, Content Creation, Content Strategy, Digital Marketing, Facebook Marketing, Social Media Management, Social Media Marketing Budget: €250 - €750 EUR
24-Mar-2026 10:55 GMT
SEO | AEO | GEO Expert Proposal Category: Content Strategy, Content Writing, Conversational AI, Generative AI, Internet Marketing, Keyword Research, Link Building, Marketing, Prompt Engineering, SEO Budget: ₹150000 - ₹250000 INR
24-Mar-2026 10:53 GMT
Edición Creativa de Promos Category: Adobe Premiere Pro, After Effects, Animation, Creative Design, DaVinci Resolve, Graphic Design, Motion Graphics, Video Editing, Video Production, Video Services Budget: £18 - £36 GBP
