skills.rest
nomifun
nomifunOFFICIAL
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 data.

284|54|Updated Jun 23, 2026
Search Tags:#data visualization#charts#dashboard#excel#xlsx#kpi#conditional formatting
One-click install
npx skills add https://github.com/nomifun/nomifun-desktop --skill officecli-data-dashboard-nomifun
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: officecli-data-dashboard
Source: https://github.com/nomifun/nomifun-desktop/tree/main/crates/backend/nomifun-app/assets/builtin-skills/officecli-data-dashboard
Command: npx skills add https://github.com/nomifun/nomifun-desktop --skill officecli-data-dashboard-nomifun

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Turning raw CSV or tabular data into a board-ready Excel dashboard requires coordinating KPI formulas, chart data ranges, sparklines, conditional formatting, print setup, and recalculation settings — a process that is error-prone and often ships broken files with stale cached values, clipped titles, or blank charts. ## Core Features & Use Cases - Dashboard-first composition: Creates a dedicated Dashboard sheet as the active tab on open, with formula-driven KPI cards referencing upstream Data and Summary sheets so values update when data changes. - Charts, sparklines, and conditional formatting: Adds cell-range-linked charts with named series and presets, time-series sparklines, and semantic CF rules (databar, colorscale, iconset, formulacf) scaled to dataset size. - Eight-gate QA delivery pipeline: Verifies KPI formula coverage, chart counts and title widths, series naming, CF presence, activeTab and fullCalcOnLoad settings, placeholder leaks, visual rendering, and cachedValue freshness before delivery. - Use Case: Given a 12-month revenue CSV, produce a single .xlsx where the user opens directly onto a Dashboard sheet showing Total Revenue and other KPI cards, a revenue trend line chart, a sparkline, and formatted source data — validated end to end. ## 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 validated 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 dashboard from a CSV file?▼

Import the CSV into a Data sheet with officecli, add a Dashboard sheet with formula-driven KPI cells referencing the data, then attach charts whose series read cell ranges like Sheet1!B2:B13. Finish by setting calc.fullCalcOnLoad and the active tab, then run validate.

How do I add KPI cards and charts to an Excel dashboard?▼

A KPI card is a small gray label cell plus a large bold value cell containing a formula such as =SUM(Sheet1!B2:B13). Charts are added with chartType, a descriptive title, named series, and cell-range values, using a consistent preset across all charts.

When should I not use this dashboard skill?▼

Do not use it for a single-sheet CSV with formatting or one chart, which belongs in the base xlsx skill, or for 3-statement, DCF, or LBO financial models, which belong in the financial-model skill. It only accepts multi-KPI, multi-chart dashboard compositions.

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 cells render blank. Aggregate into a visible Summary sheet and point chart series at those visible cells instead.

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

The ### symbol means the column is too narrow for the cached value; size width by the largest expected value, roughly ceil((visible_chars + 2) x 1.3). Stale zeros occur because fullCalcOnLoad only recalculates at runtime, so re-issue downstream formulas after upstream edits to refresh build-time cachedValue.

Does the dashboard skill support print-ready output?▼

Yes, it sets a _xlnm.Print_Area named range scoped to the Dashboard sheet, adds fit-to-page landscape page setup, and hides all non-Dashboard sheets so the print pipeline emits a single page. A structural print-scope check runs when the request mentions print, board, or investor delivery.

Related Skills

Explore More Data & Analytics Skills→
aiyinluyaaiyinluya
2

excel-multi-sheet-threshold-analysis

Deduplicate multi-sheet Excel records by keyword matching and export summary and detail reports.

Community
Basic
orqesaorqesa

investor_reporting

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

Official
Intermediate
Team-CommonlyTeam-Commonly
1.3k

officecli-financial-model

Automate end-to-end Excel financial modeling with three-statement models and DCF valuations.

Official
Advanced
syncfusionsyncfusion

syncfusion-javascript-pivot-table

Implement Syncfusion PivotView components for TypeScript applications.

Official
Advanced