Office

What This Skill Does

The Office skill serves as a comprehensive suite for automating and managing professional document workflows, data analysis, and administrative tasks. Designed to integrate with Microsoft 365 and Google Workspace, it provides the AI agent with deep knowledge of spreadsheet logic, document formatting, presentation aesthetics, and general office management. Whether you are performing complex data lookups, structuring long-form reports, designing slide decks, or managing office inventory, this skill acts as your virtual operations manager.

Installation

To integrate this skill into your environment, run the following command in your OpenClaw terminal: clawhub install openclaw/skills/skills/ivangdavila/office

Use Cases

• Data Analysis: Automating spreadsheet maintenance using VLOOKUP, INDEX/MATCH, and pivot tables to clean up messy datasets.
• Document Automation: Streamlining repetitive tasks like mail merges, complex header/footer management, and document structure via automatic TOC generation.
• Presentation Design: Implementing Slide Master templates and refining animations for professional, high-impact decks.
• Office Admin: Tracking physical inventory, managing vendor contracts, and optimizing workspace utilization through scheduling and maintenance reminders.

Example Prompts

1. "Analyze this spreadsheet and identify the top 5 performing products using a pivot table and highlight them with conditional formatting."
2. "Draft a formal memo from this template, insert the employee contact details from the provided Excel file, and mail merge into individual documents."
3. "Create a 10-slide PowerPoint presentation outlining our quarterly office budget and supply inventory status, adhering to the 6x6 rule."

Tips & Limitations

• Data Integrity: When performing lookups, ensure your source data is formatted correctly (e.g., dates as dates, not strings) to avoid #N/A errors.
• Precision: Use absolute references ($) in formulas when copying them across cells to maintain functionality.
• Scope: While the skill handles complex formatting and logic, it is best paired with structured data. Avoid using it for highly volatile, unstructured raw input without initial cleaning. Always review automated mail merges before mass-printing to ensure data mapping is accurate.