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.

Some Visuals on the dashboard such as property locations on a global map and also performance metrics would be great if possible on the excel dashboard or linked powerBI