Office Wizard for General Office

Problem

Office work often fails not because a feature is missing, but because the right command, formula, or layout step is scattered across Word, Excel, PPT, and WPS. This skill maps common requests to concrete outcomes: document formatting, spreadsheet formulas, slide design, WPS-specific tools, and entry points for VBA / Python automation.

How It Works

It first classifies the user's intent, then returns actionable steps.
- Word: page breaks, headers and footers, table of contents, style syncing, mail merge, wildcard search, and field codes.
- Excel: formulas such as VLOOKUP, XLOOKUP, SUMIFS, NETWORKDAYS, and SORT, plus split columns, deduplication, Ctrl + E Flash Fill, conditional formatting, and data validation.
- PPT: slide masters, color picker, image layouts, SmartArt, narration recording, and video export.
- WPS: PDF-to-Word conversion, Daoke templates, document merging, cloud collaboration, and WPS AI features.
- Automation: for batch work, it flags VBA macros or Python dependencies such as python-docx and openpyxl.

Boundaries

This skill focuses on workflow guidance and quick references rather than direct local file manipulation. Feature names and menu locations can differ across Office versions and WPS. Shortcuts assume Windows unless noted; on Mac, replace Ctrl with Cmd. For macros, scripts, or batch edits, verify Trust Center settings, the Python environment, and the source file structure first.