skills.rest
LynxLabVN
LynxLabVNOFFICIAL
Explore all skills by this author →
GitHub

excel-author

Create Excel workbooks for financial modeling with openpyxl conventions.

Updated Jul 3, 2026
Search Tags:#audit#financial modeling#Excel#openpyxl#spreadsheet
One-click install
npx skills add https://github.com/LynxLabVN/office-agent --skill excel-author-lynxlabvn
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: excel-author
Source: https://github.com/LynxLabVN/office-agent/tree/main/agent-core/optional-skills/finance/excel-author
Command: npx skills add https://github.com/LynxLabVN/office-agent --skill excel-author-lynxlabvn

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill automates the creation of auditable Excel workbooks with financial modeling conventions, reducing manual errors and streamlining the process.

Core Features & Use Cases

  • Automated Workbook Creation: Generates Excel workbooks using openpyxl with predefined conventions.
  • Financial Modeling Conventions: Implements blue/black/green cell conventions, formulas over hardcodes, named ranges, balance checks, and sensitivity tables.
  • Use Case: Ideal for financial models, audit outputs, reconciliations, and other spreadsheet-based financial analysis tasks.

Quick Start

Use the excel-author skill to create a new workbook with the following inputs: revenue FY2024 = 1,250,000,000, growth rate = 0.12.

Frequently Asked Questions about excel-author

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

FAQPage Schema
How do I automate Excel workbook creation with financial modeling conventions?▼

You can automate Excel workbook creation by using openpyxl to generate spreadsheets that enforce banker-grade conventions like blue/black/green cell coloring, named ranges, and formulas over hardcodes for auditability.

What financial modeling conventions are applied when automating Excel spreadsheets?▼

Financial modeling conventions applied include blue/black/green cell formatting to distinguish inputs and formulas, named ranges for clarity, balance checks for accuracy, and sensitivity tables for flexible financial analysis.

Does openpyxl support audit preparation and model reconciliation workflows?▼

Yes, openpyxl supports audit preparation and model reconciliation by programmatically generating Excel workbooks with built-in balance checks and transparent formulas, reducing manual errors in financial analysis.

Do I need openpyxl to generate auditable Excel workbooks for financial analysis?▼

Yes, openpyxl is required as the core dependency to manage workbook creation, apply banker-grade financial modeling formatting, and enforce auditability conventions within the generated Excel spreadsheets.

Can I use automated spreadsheet generation for audit outputs and reconciliations?▼

Yes, automated spreadsheet generation is ideal for producing audit outputs and performing reconciliations, applying financial modeling conventions to ensure your Excel workbooks remain flexible and auditable.

Related Skills

Explore More Finance & Accounting Skills→
Exocore-OrganizationExocore-Organization
5

excel-generator

Generate formatted Excel workbooks with formulas, charts, and styling from Python.

Official
Advanced
jleechanorgjleechanorg

excel-author

Create auditable Excel workbooks with formulas, named ranges, and balance checks.

Official
Intermediate
salmanparachasalmanparacha

working-with-spreadsheets

Create and edit Excel .xlsx workbooks with formulas and formatting using openpyxl.

Community
Intermediate
NONEitnonameNONEitnoname

xlsx

Create and edit Excel workbooks with formulas using OpenPyXL.

Community
Advanced