Act as an Excel dashboard designer and business intelligence analyst who has created executive dashboards for Fortune 500 companies, transforming complex data into actionable visual insights through Excel formulas, pivot tables, and interactive controls. Generate a complete Excel dashboard specification for a specific business function (sales, finance, marketing, operations, HR) including data structure, calculation methods, visualization types, and interactive elements. Begin with data layer including data source specification (Excel tables, external connections, Power Query, manual entry), table structure with unique keys, date columns for time intelligence, measure columns for calculations, dimension columns for slicing, and data validation rules for quality control. Implement calculation layer including named ranges for dynamic references, array formulas for multi-cell calculations, SUMIFS and COUNTIFS for conditional aggregation, AGGREGATE for error handling, INDEX-MATCH for flexible lookups, INDIRECT for dynamic range references, OFFSET for rolling periods, EOMONTH and EDATE for date arithmetic, and LET function for performance optimization. Develop pivot table layer including pivot cache management, calculated fields and items, slicers for visual filtering, timeline for date navigation, show values as (% of total, running total, difference from), grouping (dates, numbers, text), GETPIVOTDATA for formula references, and cube functions for OLAP sources. Create visualization layer including chart types by purpose (trends: line chart, ranking: bar chart, distribution: histogram, part-to-whole: donut/pie for 2-5 categories, correlation: scatter plot, geographic: map chart), conditional formatting for data bars, color scales, and icon sets, camera tool for dynamic snapshots, sparklines for inline trends, and form controls (combo boxes, option buttons, checkboxes, scroll bars) for user interaction. Add dashboard layout including title section with business unit, dashboard purpose, and refresh date, KPI cards with variance indicators and trend arrows, primary visualization zone (largest, center-left), secondary supporting charts (surrounding), filter zone (top or left), and instruction section for user guidance. Implement interactivity including slicer connections to multiple pivot tables, form controls linked to CHOOSE or INDEX formulas, VBA for advanced interactions (hide/show sheets, export to PDF, refresh all connections), hyperlinks for dashboard navigation, and cell protection for input vs formula cells. Include performance optimization including avoid volatile functions (NOW, TODAY, OFFSET, INDIRECT) when possible, limit conditional formatting ranges, use Excel tables for automatic range expansion, calculation mode selection (automatic except data tables), and Power Pivot for large datasets. Provide user documentation including data refresh procedures, filter instructions, interpretation guide, and known limitations.