5 Claude Skills Every Office Job Needs: We Built Them Live With No Code
Every Monday you open Claude and explain your job again. Your format, your tone, your boss's pet peeves. The fix is a Claude skill: you explain the chore once, Claude saves it, and from then on one sentence does the whole job.
We built five of them live, in the normal Claude app, with no code, for the five chores almost every office job has: the weekly report, email replies, meeting notes, messy spreadsheets and slide decks. Claude picked the right skill on its own every time. Two skills needed a one-sentence fix, and the slide deck still needs a human touch. Here is what happened with each one.
What a Claude skill is
Think of the sticky note a good coworker leaves for a new hire. Reports go out Friday. Risks at the top. Never more than one page.
A skill is that note, saved inside Claude. You don't paste it in every time. Claude knows every skill you have, and when your request matches one, it opens that skill and follows it.
Setup (works on the free plan)
Setup takes thirty seconds.
- Open Settings, go to Capabilities, and make sure "Create and edit files" is switched on. Skills need this setting.
- Open Customize, hit Add, and pick "Create with Claude".
- That opens a chat where Claude writes the skill for you. Describe the chore, and it hands you a card. Press Save.
Skill 1: the weekly status report
We told Claude the sections we wanted: Risks, Done, In progress, Next week. Risks first. One page, short bullets. Then came the most important part: we pasted in one report our manager actually liked.
That's rule one: paste one real example. Describing a format gets you close. An example gets you your format, exactly.
For the test we opened a brand new chat and never mentioned the skill. We pasted messy notes and typed "do my weekly update." Claude spotted the skill on its own and loaded it. The forklift lease and a late customer order went straight to the top, under Risks.
One miss. The supplier's 4% price increase landed in the Done section. For our boss, a price going up is always a risk. So we typed one sentence: "Update the skill: any cost increase goes in Risks." Claude gave us an Update card, we pressed it, and the price rise moved up. Fixed, for every Friday from now on.
Skill 2: replies in my voice
Most AI emails sound the same, because nobody tells the AI how they actually write. So we gave it rules. Short sentences. A fixed sign-off. A never-say list: no "I hope this email finds you well", no "circle back". And if it doesn't know a fact, it has to write [CHECK] instead of making one up.
The test was three emails: an angry customer with a late order, a bulk pricing question, and a supplier quote. The drafts sounded like a person. One apology, the exact delivery date. And it left [CHECK] marks where it refused to invent a discount we never gave it. Good. But we answer these same questions every week.
So we gave the skill our standard answers. Late order: 10% credit. Fifty cases a month: 8% off. A supplier increase under 5%: approve it. We ran it again, and all three drafts were ready to send, with zero [CHECK] marks.
That's rule two: give it your standard answers. And it only drafts. You still read it, and you press send.
Skill 3: meeting notes to actions
Most meeting notes are a list of good intentions. Our rule for this skill: an action only counts if it has an owner and a date. Anything without both goes in a list called "Needs an owner". That's rule three: no owner, no date, no action.
We pasted the transcript from an ops meeting. Three real actions came out, each with a name and a date. Then three more landed in "Needs an owner": update the FAQ, decide on a customer credit, and cover the Saturday shifts. Everyone said good idea, and nobody took them. Those are exactly the tasks that quietly die.
The skill also wrote a follow-up email asking someone to claim them. This one worked first try. No fix needed.
Skill 4: the messy spreadsheet fixer
Exports from any system come out ugly. Dates in three formats, duplicates, blank rows, random spaces. We told the skill: one date format. Remove duplicates and empty rows. Fix spacing and capitals. Flag missing values, but never delete them. And give back a real Excel file with a "What I changed" tab.
Then we uploaded a 306-row export and typed three words: "Clean this export." This one takes about five minutes to run.
| What we checked | Result |
|---|---|
| Rows in | 306 |
| Empty rows removed | 6 |
| Duplicates removed | 18 |
| Rows out | 282 |
| Rows with no customer, highlighted yellow and kept | 15 |
We checked those numbers by hand. All correct. Every single fix is listed on the "What I changed" tab. That's rule four: make it show what it changed. Never trust a cleanup you can't check.
Then it did something we didn't ask for. It noticed the totals don't match the quantities, and it flagged that instead of quietly changing anything.
One miss here too. The chart it added was "rows by status", which tells a boss nothing. One sentence, and the skill now builds a weekly chart instead.
Skill 5: the on-brand slide deck
Ask any AI for slides and you get purple gradients. So we gave the skill our colors, our fonts, our logo, and two rules: five bullets max, and the last slide is always Next steps. That's rule five: your template wins. Claude even built a sample deck to prove the style works.
For the real test we attached a one-page project brief and asked for a deck for Finance and the Head of Sales. Back came eight slides in our navy, with our logo on every one and a Next steps table with owners and dates. It also warned us that Finance might ask for a number the brief doesn't have.
All five at a glance
| Skill | What it did in the test | Fix needed | Verdict |
|---|---|---|---|
| Weekly status report | Put the right items under Risks, in our format | One sentence: cost increases go in Risks | Works |
| Replies in my voice | 3 drafts, wrote [CHECK] instead of inventing a discount | Added our standard answers, then zero gaps | Works |
| Meeting notes to actions | 3 actions with owners and dates, 3 unowned tasks flagged | None | Works |
| Messy spreadsheet fixer | 306 rows in, 282 out, every change listed | One sentence: a weekly chart instead | Works |
| On-brand slide deck | 8 slides in our colors with our logo | A couple of slides need tightening by hand | Half |
To be fair
Is the deck designer level? No. A couple of slides have big empty boxes we'd tighten. Is it a solid first draft in two minutes instead of an hour? Yes.
Two of the five skills were wrong on the first run, and each took one sentence to correct. The email skill only drafts, so you still read every reply before it goes out. The spreadsheet run is slow, about five minutes. And all the demo data comes from a made-up company, so your own files may behave differently.
The 5 rules
- Paste one real example.
- Give it your standard answers.
- No owner, no date, no action.
- Make it show what it changed.
- Your template wins.
Monday, replayed
Do my weekly update. Done. Reply to these. Three drafts, ready. Actions from this meeting. Table and email. Clean this export. Clean file. Make this a deck. Eight slides.
Five sentences. You explained your job once, and now Claude remembers it.
Get all 5 skills free
Want all five without building them? The Office Skills Pack has all 5 skills ready to upload, plus a 1-page guide to install them and swap in your own details. Comment OFFICE5 on the video, or grab it below.
How we tested: five skills built and tested live in the normal Claude app in November 2026, each in a brand new chat without naming the skill. All demo data is a made-up company. Skills need Settings, then Capabilities, then "Create and edit files" switched on. One small test, not a study. Independent, not sponsored by or affiliated with Anthropic.
Free PDF: The Office Skills Pack
The Office Skills Pack: all 5 skills ready to upload, plus a 1-page guide to install them and swap in your own details.
Join 26,000+ readers of the Hyperautomation AI Report
Quick answers
What is a Claude skill?
A skill is a set of instructions Claude keeps on file and uses on its own when your request matches. Think of the sticky note a good coworker leaves for a new hire: reports go out Friday, risks at the top, never more than one page. You write it once and stop pasting it into every chat.
Do Claude skills work on the free plan?
Yes, the video says skills work on the free plan. They need one setting switched on: open Settings, go to Capabilities, and turn on "Create and edit files". Setup takes about thirty seconds.
Do I need to code to make a Claude skill?
No. In the normal Claude app, open Customize, hit Add, and pick "Create with Claude". That opens a chat where Claude writes the skill for you. You describe the chore, it hands you a card, and you press Save.
Do I have to tell Claude which skill to use?
No. In our tests Claude picked the right skill on its own every time, and we never named it. We opened a brand new chat, pasted messy notes and typed "do my weekly update". Claude spotted the skill and loaded it.
Can Claude clean a messy Excel or CSV export?
In our test, yes. We uploaded a 306-row export and got back a real Excel file with 282 rows. It removed 6 empty rows and 18 duplicates, and highlighted 15 rows with no customer instead of deleting them. We checked every number by hand, and it took about five minutes to run.
How do I fix a Claude skill that gets something wrong?
Type one sentence. Our weekly report skill put a 4% supplier price rise under Done. We typed "Update the skill: any cost increase goes in Risks", pressed the Update card Claude gave us, and it was fixed for every Friday from then on.