Requirements
- Target platform
- OpenClaw
- Install method
- Manual import
- Extraction
- Extract archive
- Prerequisites
- OpenClaw
- Primary doc
- SKILL.md
Master Excel, Word, PowerPoint, and Google Workspace with formulas, formatting, and automation.
Master Excel, Word, PowerPoint, and Google Workspace with formulas, formatting, and automation.
Hand the extracted package to your coding agent with a concrete install brief instead of figuring it out manually.
I downloaded a skill package from Yavira. Read SKILL.md from the extracted folder and install it by following the included instructions. Tell me what you changed and call out any manual steps you could not complete.
I downloaded an updated skill package from Yavira. Read SKILL.md from the extracted folder, compare it with my current installation, and upgrade it while preserving any custom configuration unless the package docs explicitly say otherwise. Summarize what changed and any follow-up checks I should run.
Productivity software: Microsoft 365, Google Workspace, and office administration. SignalContextLoadFormulas, pivot tables, VLOOKUP, macrosSpreadsheetstools/spreadsheets.mdFormatting, headers, mail merge, TOCDocumentstools/documents.mdSlides, animations, presenter viewPresentationstools/presentations.mdSupplies, vendors, facilities, spaceOffice adminadmin/facilities.md
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.
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
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.
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
TaskExcel/SheetsWord/DocsPowerPoint/SlidesFind valueVLOOKUP/XLOOKUPFind & ReplaceFind & ReplaceConditional formatHome โ ConditionalN/AN/AAuto-update contentFormulasFieldsLinksExport to PDFFile โ Save AsFile โ Save AsFile โ Save As
Workflow acceleration for inboxes, docs, calendars, planning, and execution loops.
Largest current source with strong distribution and engagement signals.