Skip to main content
ZICQ

Skills ZICQ category:Documents Office OpenClaw

Office

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

534 installs · 21 stars

Official URL:ClawHub

What this skill does

Intro in this page language first. The official description stays in its original wording; we do not rewrite SKILL.md.

What it does

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

When to use it

The official description does not include a separate “Use when”. Per the spec, agents activate this skill when the task matches keywords in that description.

How agents load it

Per Agent Skills progressive disclosure: name and description load at startup (~100 tokens); the full SKILL.md body loads when the skill activates; scripts/, references/, and assets/ load only as needed. This file's sections: What "Office" Means Here; Spreadsheets (Excel / Google Sheets); Documents (Word / Google Docs); Presentations (PowerPoint / Google Slides); Office Administration; Quick Reference.

File analysis

File analysis: instruction-only skill (SKILL.md). The agent loads the full body when activated.

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

SKILL.md & Agent activation

Official spec ↗
name
Office
description
Master Excel, Word, PowerPoint, and Google Workspace with formulas, formatting, and automation.
  1. DiscoverThe client exposes names and descriptions to the agent.
  2. ActivateYour request or the task context selects the skill and loads its instructions.
  3. Load resourcesReferenced scripts, documentation and assets are used when needed.

Invocation syntax and available tools depend on your Agent client. Client integration guide ↗

Install this skill

Skills CLI ↗

Choose the target agent and installation scope, keep referenced package files, then verify the skill appears in the client's catalog.

Ask your Agent to install

Copy these instructions to a compatible agent and confirm the target directory matches your client.

Install the agent skill "Office" into my project. The full SKILL.md and official description are at https://zicq.com/en/skills/skl-88a4d4ff506de183-Office.html
Save it as .cursor/skills/office/SKILL.md or .claude/skills/office/SKILL.md and keep the frontmatter name and description exactly as-is.

No unambiguous GitHub package URL is recorded. Follow the original source's installer instructions.

ClawHub ↗

Readable layout

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 |

Related skills

Documents

Ontology

Typed knowledge graph for structured agent memory and composable skills. Use when creating/querying entities (Person, Project, Task, Event, …

Documents

Nano Pdf

Edit PDFs with natural-language instructions using the nano-pdf CLI.

Documents

Word / DOCX

Create, inspect, and edit Microsoft Word documents and DOCX files with reliable styles, numbering, tracked changes, tables, sections, and co…

Documents

Api Gateway

Call third-party APIs through the Maton gateway, which injects the credential for an app the user has already connected. Use this skill when…