Designs refreshable Excel dashboards (Power Query + structured tables + validation + pivot reporting). Use when you need a repeatable weekly KPI workbook that updates from files with minimal manual work.
Initial release of excel-weekly-dashboard. - Designs refreshable Excel dashboards using Power Query, structured tables, validation, and pivot reporting. - Focuses on creating repeatable weekly KPI workbooks that update from files with minimal manual work. - Supports ingestion from CSV, XLSX, and exported table formats (DOCX/PDF). - Provides clear input requirements, step-by-step workflow, and sample output formats. - Defines robust validation, error detection, and refresh status features to ensure reliable weekly reporting. - Includes safety guidelines to prevent accidental overwrites and highlight extraction risks.