skills.rest
Dhanuzh
DhanuzhCOMMUNITY
Explore all skills by this author →
GitHub

officecli-data-dashboard

Builds multi-element Excel dashboards with formula-driven KPI cards, charts, sparklines, and conditional formatting from CSV input.

Updated Aug 19, 2026
Search Tags:#data visualization#charts#dashboard#excel#xlsx#kpi#conditional formatting
One-click install
npx skills add https://github.com/Dhanuzh/DCode-Core --skill officecli-data-dashboard-dhanuzh
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: officecli-data-dashboard
Source: https://github.com/Dhanuzh/DCode-Core/tree/main/crates/dcode-app/assets/builtin-skills/officecli-data-dashboard
Command: npx skills add https://github.com/Dhanuzh/DCode-Core --skill officecli-data-dashboard-dhanuzh

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Turning raw CSV or tabular data into a board-ready Excel dashboard requires coordinating KPI formulas, cell-range-linked charts, sparklines, conditional formatting, print setup, and workbook-level settings like activeTab and fullCalcOnLoad — a process that is error-prone and easy to get wrong (stale cached values, blank charts, clipped titles). ## Core Features & Use Cases - Dashboard-first composition: Creates a dedicated Dashboard sheet with formula-driven KPI cards, multiple charts, sparklines, and semantic conditional formatting, while raw data and aggregations stay on upstream Data/Summary sheets. - Design guidance: Provides layout patterns (executive summary, ops console, scorecard), complexity scaling by data size, chart-type selection tables, and column-width sizing rules to prevent ### rendering. - Eight-gate QA delivery cycle: Enforces verifiable checks for KPI formula coverage, chart count and title width, series naming, CF rules, activeTab/fullCalcOnLoad, placeholder leaks, visual floor, and cachedValue sanity. - Use Case: Given a 12-month revenue CSV, produce a single .xlsx that opens on a Dashboard sheet showing Total Revenue and other KPIs, a linked line chart, a sparkline, and print-ready settings for a board pack. ## Quick Start Ask the AI to build an executive KPI dashboard from your sales CSV file with revenue KPI cards, a trend chart, and conditional formatting, delivered as a single xlsx file.

Frequently Asked Questions about officecli-data-dashboard

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I create an Excel KPI dashboard from a CSV file?▼

Import the CSV into a Data sheet, add a Dashboard sheet with formula-driven KPI cells referencing the data, then add charts whose series read from cell ranges. Finish by setting calc.fullCalcOnLoad and the activeTab so the Dashboard opens first.

When should I use this dashboard skill instead of a plain xlsx skill?▼

Use it only when the deliverable is a Dashboard sheet with multiple KPI cards, multiple charts, and conditional formatting or sparklines. A single-sheet CSV tracker, a small weekly report, or a 3-statement financial model should use the base xlsx or financial-model skills instead.

Why does my Excel chart render blank in LibreOffice?▼

LibreOffice does not evaluate formulas in hidden columns or hidden sheets at render time, so charts pointing at hidden SUMIFS cells render blank. Aggregate into a visible Summary sheet and point chart series at those visible cells.

Why do my KPI cells show ### or stale zero values?▼

### appears when column width is too narrow for the cached value; size columns by the widest expected value, roughly ceil((visible_chars + 2) x 1.3). Stale zeros happen because fullCalcOnLoad only recalculates at runtime, so re-issue downstream formulas after upstream edits.

Can I make the Excel dashboard print-ready for a board pack?▼

Yes. Set an _xlnm.Print_Area named range scoped to the Dashboard sheet, add fit-to-page landscape pageSetup, and hide all non-Dashboard sheets so the print pipeline emits a single page.

Related Skills

Explore More Data & Analytics Skills→
markus41markus41
12

pandas-cleaning

Clean and standardize messy tabular data into normalized DataFrames and formatted .xlsx files.

Community
Advanced
orqesaorqesa

investor_reporting

Establish monthly investor updates, KPI dashboards, and quarterly board decks.

Official
Intermediate
mtsatryanmtsatryan
1

data-analyst

Analyze business data with SQL and Python to generate dashboard-ready visualizations and insights.

Community
Advanced
reason-machinesreason-machines
5

power-bi-retail-analytics-dashboard

Builds Power BI retail dashboards with DAX measures, forecasting, and alert thresholds.

Official
Advanced