About this skill

Problem

Although named PPT Writing, the supplied material mainly constrains Excel / financial-model delivery quality: inconsistent fonts, formula errors, overwritten existing templates, and Python-calculated values hardcoded into cells. It is better suited to producing auditable, recalculable .xlsx artifacts.

How It Works

Output rules: use a consistent professional font and deliver files without #REF!, #DIV/0!, #VALUE!, or similar formula errors; when editing existing files, preserve established template conventions.
Financial-model conventions: distinguish hardcoded inputs, formulas, cross-sheet links, and external links with blue, black, green, and red text; mark key assumptions with yellow backgrounds and enforce clear formatting for years, currency, percentages, multiples, and negatives.
Formula-first workflow: avoid hardcoding calculated results; write Excel formulas and then recalculate them with scripts/recalc.py using LibreOffice, checking reported error locations.
Engineering path: use pandas for data reading and analysis, openpyxl for formulas and formatting, and handle 1-based cell indices, cross-sheet references, nulls, division by zero, and edge cases.

Boundaries

The material does not define slide structure, masters, animations, or PPT file generation. Treat it as an Excel delivery constraint skill that assumes LibreOffice is available for formula recalculation.

Screenshots

Use Cases

A financial analyst compiles 10-K revenue data into an assumption-driven model.
A data analyst reads multi-year Excel data and outputs an error-free analysis workbook.
An operations lead merges channel reports into one template while preserving formatting and formulas.
A research analyst marks inputs, formulas, cross-sheet links, and external links in a valuation model.

Best For

Financial analysts delivering models that must be error-free and template-consistent.
Data engineers processing Excel files with pandas and openpyxl.
Research analysts maintaining valuation models with color coding and source notes.
Operations staff consolidating channel data into workbooks with existing conventions preserved.

Related Skills

Tech Five-Track Daily Report

@user_d8825169/tech-daily-report

Generates a fixed-structure A-share tech daily across five tracks, screening 24-hour news and selecting leader and growth stocks.

Office Efficiency 2026.08.29 ↓ 526

PDF Teaching Schedule to Excel Converter

@user_2ed69ff3/pdf-teaching-schedule-to-excel

Convert teaching schedules from talent development plan PDFs into structured Excel files, with cross-page tables, merged cells, multi-semester course splitting, major metadata extraction, and batch output.

Office Efficiency 2026.08.29 ↓ 626

Meeting Minutes Translator

@user_70c2f807/meeting-minutes-translator

Turn post-meeting text into bilingual minutes, preserving structure and consistent terminology.

Office Efficiency 2026.08.30 ↓ 695

XinXun Bid Writing Tool

@user_ba095919/biaoshu-writer-turbo

Interprets tender files, generates bid docs, and checks compliance via the Bailian API.

Office Efficiency 2026.08.30 ↓ 762