Excel Database with dashboard

Create a polished, user-friendly Excel workbook to manage a property portfolio, including an intuitive dashboard summarizing key metrics and performance. Features: property list with ownership type, lease length, and use (long-term, serviced accommodation, renovate-to-sell); mortgage details (fixed-term expiry, total duration, interest rate); utilities and insurers with provider names and expiry dates; management companies and other critical contacts; key dates and alerts. Build dynamic charts, filters, conditional formatting, and simple formulas to track cashflow, ROI, occupancy, and upcoming expiries. Emphasize clarity, ease of use, and actionable insights.