Excel Usage Guide
Paste the following prompt into your AI chat to install this skill:
According to https://skillhub.cn/install/skillhub.md, install @user_90d58900/excel01.
About this skill
The Core Problem It Solves
When collaborating on financial models, data analysis reports, or automated report generation, teams frequently encounter specific pain points: inconsistent formatting across Excel files, frequent formula errors, and garbled characters in CSV files when exchanged between different systems. These
Use Cases
- When a team collaborates on building a financial forecast model, use color coding standards to differentiate input assumptions from formulas, ensuring all calculation cells reference separate assumption cells to prevent errors from input modifications.
- When a system-generated CSV file containing Chinese characters for quarterly sales data needs to be imported into Excel for analysis, save the file using `utf-8-sig` encoding to prevent garbled text when opened in Excel.
- When the audit department needs to verify data consistency in quarterly reports, quickly identify format anomalies based on standard number formatting rules (e.g., parentheses for negatives, hyphens for zeros, text for years) to ensure compliance with disclosure requirements.
- After source data updates, use the `scripts/recalc.py` script to batch recalculate all formulas across the entire workbook and automatically scan for common errors like `#REF!` or `#DIV/0!`, ensuring dynamic report calculations are correct.
Best For
- An analyst responsible for building complex financial forecast models, whose requirement is to follow industry-standard formatting and formula conventions to ensure the model is clear, maintainable, and easy for others to review.
- A data engineer who needs to regularly consolidate CSV files from multiple data sources into Excel or analysis tools, whose requirement is to solve cross-platform data exchange issues like Chinese character garbling and format misalignment.
- A developer responsible for creating and maintaining dynamic operational analysis reports, whose requirement is to ensure all formula references in the report are correct and that the report can be automatically recalculated and verified after data updates.
- An operations manager who needs to weekly consolidate sales data tables submitted from various regions into a single master sheet for analysis, whose requirement is to maintain consistency in formatting, formulas, and styles with the standard template after consolidation.
Related Skills
Tencent Cloud Table Recognition V3 is an OCR skill for detecting and recognizing tables in images or PDFs, supporting various table types like linear and borderless tables, with Excel export.
The complete set of online document operation tools provided by Tencent Docs MCP, supporting creation, querying, and editing of smart docs, Excel, PPT, mind maps, and more.
PPT Master is a professional PPT generation skill that automatically generates editable .pptx files through a 5-stage interactive workflow based on user requirements.
An AI-powered bid document assistant offering intelligent interpretation, document generation, and compliance review features.