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)
3D AI Cartoon Video Editor Category: 3D Animation, 3D Graphic Design, 3D Modelling, 3D Rendering, After Effects, Animation, Motion Graphics, Video Editing Budget: ₹600 - ₹1500 INR
01-Jun-2026 16:03 GMT
Dynamic Modeling of Information in Distributed Systems Category: Data Analysis, Data Modeling, Data Science, Distributed Systems, Mathematics, R Programming Language, SPSS Statistics, Statistical Analysis, Statistical Modeling, Statistics Budget: $30 - $250 USD
01-Jun-2026 16:01 GMT
Integrate PawaPay Gateway Category: API Integration, Full Stack Development, HTML, JavaScript, MySQL, Payment Gateway Integration, PHP, REST API Budget: £10 - £15 GBP
Simple City Model in 3DS Max Category: 3D Animation, 3D Architecture, 3D Design, 3D Graphic Design, 3D Modelling, 3D Rendering, 3D Studio Max, 3ds Max Budget: $30 - $250 USD
Romantic 2D Animated Music Video Category: 2D Animation, 2D Animation Explainer Video, 3D Animation, Adobe Animate, After Effects, Animation, Arabic Translator, Character Illustration, Video Services Budget: $250 - $750 USD
Word Document Formatting Overhaul Category: Editing, Format And Layout, PDF, Proofreading, Typography, Visual Design, Word, Word Processing Budget: $30 - $250 USD
01-Jun-2026 15:56 GMT
3D-Print CAD for Bike Nose Cone Category: 3D CAD, 3D Modelling, 3D Print Design, 3D Printing, AutoCAD, Blender, CAD / CAM, Fusion 360, Product Design, Solidworks Budget: £20 - £250 GBP
01-Jun-2026 15:55 GMT
Weekend Database Invoice Entry Category: Accounting, Data Analysis, Data Processing, Database Management, Excel, Microsoft Access Budget: ₹12500 - ₹37500 INR