技能库智客分类：文档办公 Office OpenClaw

Office

Master Excel, Word, PowerPoint, 和 Google 工作空间的公式,格式化,以及自动化.

534 安装量 · 21 星标

官方网址：ClawHub

技能介绍

先看中文介绍；官方 description 原文单独保留，不改写 SKILL.md。

做什么

Master Excel, Word, PowerPoint, 和 Google 工作空间的公式,格式化,以及自动化.

何时用

官方 description 未单独写出 Use when。按规范，代理会在用户任务与这段 description 的关键词匹配时激活本技能。

代理如何加载

按 Agent Skills 渐进披露：启动时只加载 name 与 description（约 100 token）；任务匹配后才读入整份 SKILL.md 正文；scripts/、references/、assets/ 仅在需要时再读。本文件正文结构：What "Office" Means Here、Spreadsheets (Excel / Google Sheets)、Documents (Word / Google Docs)、Presentations (PowerPoint / Google Slides)、Office Administration、Quick Reference。

文件分析

文件分析：这是一份仅含 SKILL.md 的指令型技能，代理激活后整份正文进入上下文。

官方 description（原文）

Master Excel, Word, PowerPoint, and Google Workspace with formulas, formatting, and automation.

What "Office" Means HereSpreadsheets (Excel / Google Sheets)Documents (Word / Google Docs)Presentations (PowerPoint / Google Slides)Office AdministrationQuick Reference

来源与网址

市场来源：ClawHub

开源榜 Skill 分类

SKILL.md 与 Agent 调用

官方规范 ↗

name: Office
description: Master Excel, Word, PowerPoint, and Google Workspace with formulas, formatting, and automation.

发现技能客户端向 Agent 提供名称与描述目录。
匹配与调用用户指定或任务匹配后，载入 SKILL.md 指令。
按需加载按步骤读取参考文档、使用脚本与素材。

具体调用语法与可用工具以目标 Agent 客户端为准。查看调用机制说明 ↗

安装这个技能

Skills CLI ↗

先选择目标 Agent 和安装范围，保留技能包的附属文件，安装后检查客户端能否发现该技能。

交给 Agent 安装

复制安装指令给支持 Agent Skills 的代理，确认其中的目标目录与客户端匹配。

把 Agent Skill「Office」安装到我的项目：SKILL.md 原文与官方 description 见 https://zicq.com/zh/skills/skl-88a4d4ff506de183-Office.html
请存为 .cursor/skills/office/SKILL.md 或 .claude/skills/office/SKILL.md，frontmatter 的 name 与 description 保持原样，不要改写。

当前没有明确的 GitHub 技能包地址，请按来源页面的安装器说明操作。

ClawHub ↗

SKILL.md 原文可复制，不会改动源文件

---
name: Office
description: "Master Excel, Word, PowerPoint, and Google Workspace with formulas, formatting, and automation."
---

## What "Office" Means Here

Productivity software: Microsoft 365, Google Workspace, and office administration.

| Signal | Context | Load |
|--------|---------|------|
| Formulas, pivot tables, VLOOKUP, macros | Spreadsheets | `tools/spreadsheets.md` |
| Formatting, headers, mail merge, TOC | Documents | `tools/documents.md` |
| Slides, animations, presenter view | Presentations | `tools/presentations.md` |
| Supplies, vendors, facilities, space | Office admin | `admin/facilities.md` |

---

## Spreadsheets (Excel / Google Sheets)

**Formulas people actually need:**
- `VLOOKUP` / `XLOOKUP` — lookup value in table, return another column
- `SUMIF` / `COUNTIF` — sum/count with conditions
- `INDEX/MATCH` — more flexible than VLOOKUP
- `IF` with `AND`/`OR` — conditional logic

**Common problems:**
- VLOOKUP returns #N/A → check for spaces, data types, exact match setting
- Formula works in one cell, breaks when copied → missing `$` for absolute references
- Dates sorting wrong → format as actual dates, not text

**Pivot tables:** Right-click data → Create Pivot Table → drag fields to rows/columns/values.

---

## Documents (Word / Google Docs)

**Formatting essentials:**
- Use Styles (Heading 1, 2, 3) for structure — enables automatic TOC
- Page numbers starting on page 3: Insert break → Different First Page → start numbering
- Different headers per section: Section breaks, unlink from previous

**Mail Merge:**
1. Prepare data source (Excel with columns: Name, Address, etc.)
2. Word → Mailings → Start Mail Merge → Letters
3. Insert Merge Fields where dynamic content goes
4. Preview Results → Finish & Merge

---

## Presentations (PowerPoint / Google Slides)

**Professional basics:**
- Slide Master for consistent styling (View → Slide Master)
- 6x6 rule: max 6 bullets, 6 words per bullet
- One idea per slide

**Animations:**
- Entrance animations for bullet reveal (Appear > Fade > Fly In)
- Timing: On Click vs After Previous
- Keep it subtle — animation should aid, not distract

**Presenter View:** F5 to present, use Presenter View to see notes while audience sees slides.

---

## Office Administration

For those managing physical office operations:

**Supplies & Inventory:**
- Track with simple spreadsheet: Item, Quantity, Reorder Point, Supplier
- Set calendar reminders for regular orders
- Bulk ordering usually 15-30% cheaper

**Vendor Management:**
- Cleaning, maintenance, IT support contracts
- Document SLAs and contact info in shared location
- Review contracts annually for renegotiation

**Space Planning:**
- Hot-desking: Use booking system (even a shared calendar works)
- Meeting room: Clear naming, visible displays, 15-min buffers

---

## Quick Reference

| Task | Excel/Sheets | Word/Docs | PowerPoint/Slides |
|------|-------------|-----------|-------------------|
| Find value | VLOOKUP/XLOOKUP | Find & Replace | Find & Replace |
| Conditional format | Home → Conditional | N/A | N/A |
| Auto-update content | Formulas | Fields | Links |
| Export to PDF | File → Save As | File → Save As | File → Save As |

阅读排版

name: Office description: "Master Excel, Word, PowerPoint, and Google Workspace with formulas, formatting, and automation."

What "Office" Means Here

Productivity software: Microsoft 365, Google Workspace, and office administration.

| Signal | Context | Load | |--------|---------|------| | Formulas, pivot tables, VLOOKUP, macros | Spreadsheets | tools/spreadsheets.md | | Formatting, headers, mail merge, TOC | Documents | tools/documents.md | | Slides, animations, presenter view | Presentations | tools/presentations.md | | Supplies, vendors, facilities, space | Office admin | admin/facilities.md |

Spreadsheets (Excel / Google Sheets)

Formulas people actually need:

VLOOKUP / XLOOKUP — lookup value in table, return another column
SUMIF / COUNTIF — sum/count with conditions
INDEX/MATCH — more flexible than VLOOKUP
IF with AND/OR — conditional logic

Common problems:

VLOOKUP returns #N/A → check for spaces, data types, exact match setting
Formula works in one cell, breaks when copied → missing $ for absolute references
Dates sorting wrong → format as actual dates, not text

Pivot tables: Right-click data → Create Pivot Table → drag fields to rows/columns/values.

Documents (Word / Google Docs)

Formatting essentials:

Use Styles (Heading 1, 2, 3) for structure — enables automatic TOC
Page numbers starting on page 3: Insert break → Different First Page → start numbering
Different headers per section: Section breaks, unlink from previous

Mail Merge:

Prepare data source (Excel with columns: Name, Address, etc.)
Word → Mailings → Start Mail Merge → Letters
Insert Merge Fields where dynamic content goes
Preview Results → Finish & Merge

Presentations (PowerPoint / Google Slides)

Professional basics:

Slide Master for consistent styling (View → Slide Master)
6x6 rule: max 6 bullets, 6 words per bullet
One idea per slide

Animations:

Entrance animations for bullet reveal (Appear > Fade > Fly In)
Timing: On Click vs After Previous
Keep it subtle — animation should aid, not distract

Presenter View: F5 to present, use Presenter View to see notes while audience sees slides.

Office Administration

For those managing physical office operations:

Supplies & Inventory:

Track with simple spreadsheet: Item, Quantity, Reorder Point, Supplier
Set calendar reminders for regular orders
Bulk ordering usually 15-30% cheaper

Vendor Management:

Cleaning, maintenance, IT support contracts
Document SLAs and contact info in shared location
Review contracts annually for renegotiation

Space Planning:

Hot-desking: Use booking system (even a shared calendar works)
Meeting room: Clear naming, visible displays, 15-min buffers

Quick Reference

| Task | Excel/Sheets | Word/Docs | PowerPoint/Slides | |------|-------------|-----------|-------------------| | Find value | VLOOKUP/XLOOKUP | Find & Replace | Find & Replace | | Conditional format | Home → Conditional | N/A | N/A | | Auto-update content | Formulas | Fields | Links | | Export to PDF | File → Save As | File → Save As | File → Save As |