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)
AI Process & Agile Training Plan Category: Agile Development, AI Chatbot Development, Automation, HTML, JavaScript, PHP, Software Architecture, Training Budget: $15 - $25 USD
06 Feb 2026 22:57 GMT
Lithuanian Roblox Roleplay Game Category: 3D Modelling, Blender, Game Design, Game Development, Game Testing, Lua, Roblox, Scripting Budget: €10 - €100 EUR
Commission-Based Online Sales Marketer Category: Advertising, Digital Marketing, Email Marketing, Facebook Marketing, Instagram Marketing, Internet Marketing, Sales, Social Media Marketing Budget: $10 - $30 USD
06 Feb 2026 22:52 GMT
Elegant Logo for Event Planner Category: Adobe Illustrator, Photoshop, Branding, Creative Design, Graphic Design, Illustration, Logo Design, Vector Design, Visual Design Budget: ₹600 - ₹1500 INR
06 Feb 2026 22:52 GMT
Need editorial link placement into cluster pages Category: Content Creation, Content Development, Content Marketing, Content Strategy, Digital Marketing, Editorial Writing, Link Building, Search Engine Marketing (SEM), SEO, Website Optimization Budget: $1500 - $3000 USD
06 Feb 2026 22:52 GMT
Redactor Diario de Fútbol Español Category: Article Rewriting, Article Writing, Blog Writing, Content Writing, Editing, SEO, Sports Budget: $30 - $250 USD
06 Feb 2026 22:50 GMT
Online Alberta Chemistry 30 Tutoring Category: Chemical Engineering, Chemistry Tutoring, Mathematics, Physics, Research Writing, Teaching / Lecturing, Whiteboard, Zoom Budget: $250 - $750 CAD
