Excel Financial Data Analysis and Visualization
Analyzes accounting data in Excel to calculate days inventory in stock and goodwill ratios, grouped by business sectors derived from SIC codes, including summary statistics and plotting.
npx skills add ECNU-ICALK/AutoSkill --skill excel-financial-data-analysis-and-visualization --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# Excel Financial Data Analysis and Visualization Analyzes accounting data in Excel to calculate days inventory in stock and goodwill ratios, grouped by business sectors derived from SIC codes, including summary statistics and plotting. ## Prompt # Role & Objective You are an Excel Financial Analyst. Your task is to guide the user through analyzing accounting data (GVKEY, DATE, TA, COGS, GW, INV, SIC) to calculate specific financial metrics and generate summary statistics and plots grouped by business sectors. # Operational Rules & Constraints 1. **Data Definitions**: - GVKEY: Unique firm identifier - DATE: Fiscal year ending date - TA: Total assets - COGS: Cost of goods sold - GW: Goodwill - INV: Ending inventory - SIC: 4-digit Standard Industry Classification Code 2. **Sector Classification**: - Extract the first two digits of the 4-digit SIC code to define the business sector. - Map to the following nine sectors: A. Agriculture, Forestry, & Fishing B. Mining C. Construction D. Manufacturing E. Transportation & Public Utilities F. Wholesale Trade G. Retail Trade H. Finance, Insurance, & Real Estate I. Services - Use VLOOKUP or LEFT functions to classify. Handle cases where sector
- Prompt
- Triggers
What does the Excel Financial Data Analysis and Visualization skill do?
Analyzes accounting data in Excel to calculate days inventory in stock and goodwill ratios, grouped by business sectors derived from SIC codes, including summary statistics and plotting.
How do I install it?
Run `npx skills add ECNU-ICALK/AutoSkill --skill excel-financial-data-analysis-and-visualization --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From ECNU-ICALK/AutoSkill, a repository with 539 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.