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)
Quick Instagram Clip Edit Category: After Effects, Animation, Canva, CapCut, Social Media Marketing, Video Editing, Video Post Editing, Video Production Budget: $10 - $30 USD
06-Dec-2025 11:03 GMT
Modern WordPress Business Website Category: HTML, PHP, SEO, Web Design, Web Development, WordPress, WordPress Design Budget: ₹1500 - ₹12500 INR
Blue-Purple Crystal Logo Category: Adobe Creative Cloud, Adobe Illustrator, Photoshop, Branding, Digital Art, Graphic Design, Icon Design, Illustration, Logo Design, Vector Design Budget: €8 - €70 EUR
06-Dec-2025 11:02 GMT
Christmas Facebook Graphics Bundle Category: Adobe Illustrator, Photoshop, Animation, Banner Design, Graphic Design, Social Media Marketing, Web Design Budget: $30 - $250 AUD
06-Dec-2025 11:01 GMT
Part-Time AI Engineer (LLMs) – Remote, Europe -- 2 Category: AI Chatbot Development, AI Development, Communications, LLM Integration, Local Job, Machine Learning (ML), Node.js, Python, React.js, SQL Budget: $25 - $50 USD
06-Dec-2025 10:58 GMT
Elementor E-commerce Site Setup Category: Elementor, Google PageSpeed Insights, HTML, Mailchimp, PHP, Web Development, Web Design, WordPress Budget: $250 - $750 USD
06-Dec-2025 10:56 GMT
Long-Term SEO Specialist for Ladakh Travel Company Category: Competitor Analysis, Content Strategy, Google Analytics, Internet Marketing, Keyword Research, Link Building, Marketing, SEO Budget: ₹1500 - ₹12500 INR
Product Modeling Category: 2D Drafting, 3D Animation, 3D CAD, 3D Design, 3D Modelling, 3D Print Design, 3D Rendering, AutoCAD, CAD / CAM, Product Design Budget: $14 - $30 NZD
06-Dec-2025 10:55 GMT
Luxurious Food Recipe Card Visuals Category: AI Art Creation, AI Content Creation, AI Image Editing, Graphic Design, Illustration, Photography, Photoshop Budget: ₹12500 - ₹37500 INR
06-Dec-2025 10:54 GMT
E-Commerce Dissertation Chapter Writing Category: Academic Research, Academic Writing, Alibaba, Amazon, Business Writing, Data Analysis, EBay, Report Writing, Research, Research Writing Budget: $20000 - $50000 USD
06-Dec-2025 10:53 GMT
Virtual Assistant Layanan Pelanggan Category: Admin Support, Customer Service, Data Entry, Data Processing, Email Handling, Email Marketing, Excel, Virtual Assistant Budget: $2 - $8 USD
