skills.rest
MuhammadUA
MuhammadUACOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create formatted Excel workbooks with live formulas and pivot tables.

Updated Jun 19, 2026
Search Tags:#financial modeling#data analysis#spreadsheet#excel#pivot tables#formula validation#workbook formatting
One-click install
npx skills add https://github.com/MuhammadUA/Axe --skill xlsx-muhammadua
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/MuhammadUA/Axe/tree/main/.kortix/opencode/skills/GENERAL-KNOWLEDGE-WORKER/xlsx
Command: npx skills add https://github.com/MuhammadUA/Axe --skill xlsx-muhammadua

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill eliminates the manual effort and risk of errors involved in creating professional Excel spreadsheets for analysis, financial modeling, and reporting, ensuring workbooks are formatted correctly and calculate accurately when inputs change.

Core Features & Use Cases

  • Professional Formatting & Structure: Applies industry-standard conventions for financial models, dashboards, and data reports, including color coding for assumptions, consistent number formatting, and logical sheet organization.
  • Automated Formula Validation: Enforces zero formula errors, uses live Excel formulas instead of hardcoded values, and includes a recalculation script to verify all formulas work correctly after generation.
  • Pivot Table Support: Creates interactive, fully functional Excel pivot tables via LibreOffice for dynamic data exploration, with validation to ensure field names match source data.
  • Use Case: For example, build a multi-sheet annual financial projection model with live growth formulas, formatted assumption cells, and a pivot table summarizing revenue by region and product line, all of which update automatically when you adjust input assumptions.

Quick Start

Use the xlsx skill to create a formatted sales performance dashboard with live formulas, conditional formatting, and a pivot table from the provided monthly sales dataset.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel workbook generation with live formulas and formatting?▼

Automating Excel workbook generation uses pandas for data processing and openpyxl to apply industry-standard financial modeling conventions, ensuring formatted workbooks calculate accurately with live formulas instead of hardcoded values.

Can I create interactive pivot tables in Excel using openpyxl?▼

Creating interactive, fully functional Excel pivot tables requires LibreOffice to validate field names against source data, as openpyxl handles spreadsheet formatting and formula management but cannot generate dynamic pivot tables directly.

What's the best way to validate Excel formulas after generating a financial model?▼

Validating Excel formulas after generating a financial model involves running a LibreOffice recalculation script to enforce zero formula errors, verifying that all live formulas update correctly when input assumptions change.

Does this automated spreadsheet generation approach support financial modeling workflows?▼

Automated spreadsheet generation supports financial modeling workflows by applying color coding for assumptions, enforcing consistent number formatting, and structuring multi-sheet projection models with live growth formulas and pivot tables.

Do I need pandas and LibreOffice to build formatted Excel workbooks?▼

Building formatted Excel workbooks requires pandas for underlying data processing, openpyxl for Excel-specific formatting and formula management, and LibreOffice specifically for formula recalculation and interactive pivot table creation.

Related Skills

Explore More Data & Analytics Skills→
cbbkrd-techcbbkrd-tech

xlsx

Create, edit, and analyze .xlsx, .xlsm, .csv, and .tsv files with pandas and openpyxl.

Community
Advanced
xcrrrxcrrr
4

xlsx

Plan and implement Excel workbook architectures for financial modeling and dashboards.

Community
Advanced
Science-DiscoveryScience-Discovery
71

Excel Analysis

Automate Excel data analysis and visualization with pandas, openpyxl, and matplotlib.

Official
Intermediate
hotriluanhotriluan

ck:xlsx

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

Community
Intermediate