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)
Update Colors in Digital Image Category: Graphic Design, Illustration, Logo Design, Photoshop, Photoshop Design Budget: $10 - $20 USD
12-Apr-2026 22:04 GMT
Local Services On-Page SEO Specialist Category: Content Writing, Conversion Rate Optimization, Internet Marketing, Keyword Research, Link Building, Marketing, SEO, Webflow, WordPress Budget: €30 - €250 EUR
12-Apr-2026 22:04 GMT
Custom Minimalist Logo Design for Freelancers Category: Adobe Illustrator, Branding, Creative Design, Graphic Design, Illustration, Logo Design, Photoshop, Typography, Vector Design, Visual Design Budget: $250 - $750 USD
12-Apr-2026 22:04 GMT
Corporate Website Promo Video Category: Adobe Premiere Pro, After Effects, Motion Graphics, Script Writing, Video Editing, Video Production, Video Services, Videography Budget: $10 - $30 USD
12-Apr-2026 22:02 GMT
Targeted Survey Conductor Needed Category: Business Analysis, Data Analysis, Data Collection, Data Visualization, Internet Marketing, Market Research, Research, Statistical Analysis, Survey Research, SurveyMonkey Budget: €3000 - €5000 EUR
12-Apr-2026 22:02 GMT
Minimalist Art Logo Creation Category: Adobe Illustrator, Art Consulting, Branding, Graphic Design, Illustration, Logo Design, Photoshop, Vector Design Budget: $15 - $25 USD
12-Apr-2026 22:02 GMT
15-Day Brand Launch Content Category: After Effects, Animation, Branding, Content Creation, Content Strategy, Graphic Design, Photoshop, Social Media Management, Social Media Marketing, Visual Design Budget: ₹1500 - ₹12500 INR
12-Apr-2026 22:00 GMT
Edit iOS Screen Recording Numbers Category: Adobe Premiere Pro, Final Cut Pro, IPad, IPhone, Mobile App Development, Objective C, Video Editing, Video Post Editing, Video Production, Video Services Budget: £20 - £250 GBP
12-Apr-2026 21:57 GMT
Cross-Platform OTP Auth App Category: Android, API Development, CI / CD, IPhone, Java, Mobile App Development, React Native, RESTful API Budget: ₹12500 - ₹37500 INR
12-Apr-2026 21:57 GMT
Social Media Manager for Catholic Sisters Category: Branding, Canva, Content Creation, Content Strategy, Facebook Marketing, Instagram Marketing, Social Media Management, Social Media Marketing, Video Editing, Video Production Budget: $8 - $15 USD
12-Apr-2026 21:53 GMT
PDF a MP3 voz muy natural Category: AI Text To Speech, Audio Editing, Audio Engineering, Audio Mastering, Audio Production, Audio Services, Audiobook, Voice Over Budget: €30 - €250 EUR
12-Apr-2026 21:48 GMT
Young Adult Streetwear Brand Development Category: Branding, Fashion Design, Graphic Design, Logo Design, Photoshop, Product Design, T Shirts, Textile Design Budget: $30 - $250 USD
