{"skill":{"slug":"office","displayName":"Office","summary":"Master Excel, Word, PowerPoint, and Google Workspace with formulas, formatting, and automation.","description":"---\nname: Office\ndescription: \"Master Excel, Word, PowerPoint, and Google Workspace with formulas, formatting, and automation.\"\n---\n\n## What \"Office\" Means Here\n\nProductivity software: Microsoft 365, Google Workspace, and office administration.\n\n| Signal | Context | Load |\n|--------|---------|------|\n| Formulas, pivot tables, VLOOKUP, macros | Spreadsheets | `tools/spreadsheets.md` |\n| Formatting, headers, mail merge, TOC | Documents | `tools/documents.md` |\n| Slides, animations, presenter view | Presentations | `tools/presentations.md` |\n| Supplies, vendors, facilities, space | Office admin | `admin/facilities.md` |\n\n---\n\n## Spreadsheets (Excel / Google Sheets)\n\n**Formulas people actually need:**\n- `VLOOKUP` / `XLOOKUP` — lookup value in table, return another column\n- `SUMIF` / `COUNTIF` — sum/count with conditions\n- `INDEX/MATCH` — more flexible than VLOOKUP\n- `IF` with `AND`/`OR` — conditional logic\n\n**Common problems:**\n- VLOOKUP returns #N/A → check for spaces, data types, exact match setting\n- Formula works in one cell, breaks when copied → missing `$` for absolute references\n- Dates sorting wrong → format as actual dates, not text\n\n**Pivot tables:** Right-click data → Create Pivot Table → drag fields to rows/columns/values.\n\n---\n\n## Documents (Word / Google Docs)\n\n**Formatting essentials:**\n- Use Styles (Heading 1, 2, 3) for structure — enables automatic TOC\n- Page numbers starting on page 3: Insert break → Different First Page → start numbering\n- Different headers per section: Section breaks, unlink from previous\n\n**Mail Merge:**\n1. Prepare data source (Excel with columns: Name, Address, etc.)\n2. Word → Mailings → Start Mail Merge → Letters\n3. Insert Merge Fields where dynamic content goes\n4. Preview Results → Finish & Merge\n\n---\n\n## Presentations (PowerPoint / Google Slides)\n\n**Professional basics:**\n- Slide Master for consistent styling (View → Slide Master)\n- 6x6 rule: max 6 bullets, 6 words per bullet\n- One idea per slide\n\n**Animations:**\n- Entrance animations for bullet reveal (Appear > Fade > Fly In)\n- Timing: On Click vs After Previous\n- Keep it subtle — animation should aid, not distract\n\n**Presenter View:** F5 to present, use Presenter View to see notes while audience sees slides.\n\n---\n\n## Office Administration\n\nFor those managing physical office operations:\n\n**Supplies & Inventory:**\n- Track with simple spreadsheet: Item, Quantity, Reorder Point, Supplier\n- Set calendar reminders for regular orders\n- Bulk ordering usually 15-30% cheaper\n\n**Vendor Management:**\n- Cleaning, maintenance, IT support contracts\n- Document SLAs and contact info in shared location\n- Review contracts annually for renegotiation\n\n**Space Planning:**\n- Hot-desking: Use booking system (even a shared calendar works)\n- Meeting room: Clear naming, visible displays, 15-min buffers\n\n---\n\n## Quick Reference\n\n| Task | Excel/Sheets | Word/Docs | PowerPoint/Slides |\n|------|-------------|-----------|-------------------|\n| Find value | VLOOKUP/XLOOKUP | Find & Replace | Find & Replace |\n| Conditional format | Home → Conditional | N/A | N/A |\n| Auto-update content | Formulas | Fields | Links |\n| Export to PDF | File → Save As | File → Save As | File → Save As |\n","tags":{"latest":"1.0.0"},"stats":{"comments":0,"downloads":14400,"installsAllTime":162,"installsCurrent":162,"stars":21,"versions":1},"createdAt":1770926628761,"updatedAt":1778488085397},"latestVersion":{"version":"1.0.0","createdAt":1770926628761,"changelog":"Initial release","license":null},"metadata":null,"owner":{"handle":"ivangdavila","userId":"s178jdk12x4qj3gs2se3etxf3h83h7ft","displayName":"Iván","image":"https://avatars.githubusercontent.com/u/81719670?v=4"},"moderation":null}