skills.rest
oneryalcin
oneryalcinCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

xlsx

Create, edit, and analyze Excel workbooks with formulas and formatting.

Updated Oct 13, 2025
Search Tags:#financial modeling#data analysis#openpyxl#formulas#spreadsheet#excel#libreoffice
One-click install
npx skills add https://github.com/oneryalcin/nexus-skills --skill xlsx-oneryalcin
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/oneryalcin/nexus-skills/tree/main/skills/tools/xlsx
Command: npx skills add https://github.com/oneryalcin/nexus-skills --skill xlsx-oneryalcin

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, openpyxl, LibreOffice, and includes scripts (resource) components.

What problem does it solve?

This Skill provides comprehensive guidance and tools for creating, editing, and analyzing Excel files, ensuring professional-grade spreadsheets with dynamic formulas and zero errors. It automates complex spreadsheet operations, eliminating manual drudgery and ensuring data integrity.

Core Features & Use Cases

  • Formula-Driven Design: Emphasizes using Excel formulas for all calculations, ensuring dynamic, maintainable, and easily auditable spreadsheets.
  • Automated Recalculation & Error Checking: Integrates recalc.py to automatically recalculate formulas and identify common Excel errors (#REF!, #DIV/0!, etc.), guaranteeing error-free outputs.
  • Industry-Standard Formatting: Details color coding and number formatting standards for financial models, ensuring professional, compliant, and easy-to-read outputs.
  • Use Case: When building a complex financial projection, the AI refers to this skill for precise instructions on formula construction, color coding, and error verification, ensuring the final model is robust, compliant, and ready for presentation.

Quick Start

"Create a new Excel file named 'budget.xlsx'. Add a sheet named 'Summary' and include a formula in cell B2 that sums values from A1 to A10. Ensure all formulas are recalculated and verified."

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I create Excel formulas that recalculate automatically and stay error-free?▼

Excel formulas recalculate automatically when cell values change. This Skill ensures zero formula errors by verifying formulas with recalc.py, catching common errors like #REF! and #DIV/0! before output. Use formulas for all calculations rather than hardcoded values to maintain dynamic, auditable spreadsheets.

Can I edit existing Excel templates while preserving their formulas?▼

Yes. This Skill updates templates while preserving existing formulas and structure, then recalculates to verify integrity. It prevents accidental formula breakage during edits and applies industry-standard color and number formatting to maintain professional compliance.

What's the best way to build financial models in Excel with proper formatting and data integrity?▼

Build financial models using formulas for all calculations, apply industry-standard color coding and number formatting, then run recalc.py to automatically verify formulas and catch errors. This Skill guides formula construction, formatting standards, and error checking to ensure presentation-ready, compliant outputs.

How do I analyze and transform data in Excel files using openpyxl and pandas?▼

This Skill creates, reads, and analyzes Excel workbooks using openpyxl for file manipulation and pandas for data processing. It performs data analysis, visualization, formula-driven calculations, and recalculation workflows to extract insights while maintaining formula integrity.

Does this work with LibreOffice spreadsheets as well as Excel?▼

Yes. The Skill supports both Excel and LibreOffice through openpyxl and a LibreOffice-based recalc.py workflow. This enables cross-platform spreadsheet creation, editing, and formula verification regardless of whether files are opened in Excel or LibreOffice.

What happens if I have formula errors in my spreadsheet—can they be detected and fixed?▼

Formula errors like #REF!, #DIV/0!, and other common issues are automatically detected and reported by recalc.py. This Skill identifies errors before final output, ensuring spreadsheets are validated and error-free before use or distribution.

Related Skills

Explore More Finance & Accounting Skills→
dougdliudougdliu

xlsx

Create and edit Excel workbooks with formulas, formatting, and template preservation.

Community
Advanced
billlzzz26billlzzz26
4

story-export

Export StoryGraph data into Mermaid diagrams, Canvas JSON, Markdown, HTML dashboards, and MCP UI dashboards.

Community
Advanced
verrio1verrio1

Xlsx

Create, edit, and validate Excel workbooks with openpyxl, pandas, and recalc.py.

Community
Advanced
xpert-aixpert-ai
8

spreadsheets

Create and modify .xlsx, .xls, .csv, and .tsv spreadsheets with formulas and charts.

Official
Advanced