skills.rest
lengo0951
lengo0951COMMUNITY
Explore all skills by this author →
𝕏@quocngo04GitHub

ck:xlsx

Create and edit Excel spreadsheets with formulas, formatting, and pandas analysis.

Updated Apr 18, 2026
Search Tags:#financial modeling#data analysis#pandas#spreadsheet#excel
One-click install
npx skills add https://github.com/lengo0951/pms --skill ck-xlsx-lengo0951
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: ck:xlsx
Source: https://github.com/lengo0951/pms/tree/main/.claude/skills/document-skills/xlsx
Command: npx skills add https://github.com/lengo0951/pms --skill ck-xlsx-lengo0951

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill automates the creation, editing, analysis, and formatting of Excel spreadsheets, significantly reducing manual labor and enhancing productivity in data-intensive tasks.

Core Features & Use Cases

  • Spreadsheets Creation and Editing: Generate and modify .xlsx files with formulas, data, and formatting.
  • Data Analysis: Leverage pandas for data analysis, visualization, and operations.
  • Excel Specific Functions: Apply color coding, number formatting, and formula construction rules.
  • Use Case: Streamline financial model creation, budget analysis, or any other Excel-based data manipulation.

Quick Start

Use the xlsx skill to create a new financial model in Excel with a basic cash flow forecast.

Frequently Asked Questions about ck:xlsx

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

FAQPage Schema
How do I automate Excel spreadsheet creation and data analysis?▼

Excel formula recalculation requires LibreOffice, which processes the formulas to ensure computed values update correctly within the .xlsx files generated by the Skill.

What's the best way to build a financial model in Excel with a cash flow forecast?▼

Excel automation supports color coding, number formatting, and data visualization directly within .xlsx files, ensuring that financial models and analytical reports are formatted correctly for professional presentation.

Do I need LibreOffice to recalculate formulas in automated Excel spreadsheets?▼

Excel automation handles specific functions like color coding, number formatting, and formula construction rules, ensuring that generated .xlsx files meet professional standards for financial modeling and data analysis reporting.

Can I use pandas for data manipulation in Excel .xlsx files?▼

Excel spreadsheet automation with pandas is ideal for finance and data analysis tasks, supporting operations like cash flow forecasting and budget analysis while applying formatting and formula construction rules.

Related Skills

Explore More Finance & Accounting Skills→
ChatAndBuildChatAndBuild
1

xlsx

Automate Excel spreadsheet creation, editing, and analysis with pandas and openpyxl.

Official
Advanced
4tie4tie

excel-generator

Generate Excel workbooks and Google Sheets with formulas, charts, and PDF exports.

Community
Advanced
EnztunEnztun

xlsx

Automate Excel spreadsheet operations with Python libraries like openpyxl, pandas, and matplotlib.

Community
Advanced
Gull-StackGull-Stack

xlsx

Create, edit, and analyze Excel spreadsheets with formulas using Python.

Official
Advanced