Learn to use AI at work, with Claude. Yes, at your 9-to-5 desk job. Free in the 9-5 Survivors Lab

Ask Flex / Automating repetitive tasks

Ask Flex

How do you automate Excel reports?

"How do I automate Excel reports? I rebuild the same one every month and I know there's a better way."You asked Google. Flex answered.
Flex the robot at his sunny office desk pressing one big teal button while the printer beside him fires out a neat stack of identical memos, feet up, coffee in hand, and little Clawd peeking out of the printer's paper tray
Flex's short answer

Make one clean copy of the report with the totals and lookups already built in as formulas, so next month you paste in the new numbers and everything updates on its own. For the clicks that still repeat, Excel can record them once and replay them, and a chat AI can walk you through either step for your exact file.

✱ Flex's tips

Build it once. Refresh it monthly.

1

Keep one clean copy

A blank version you copy each month.

2

Let formulas do the math

Totals, lookups and dates update alone.

3

Record the repeat clicks

Excel's recorder replays them. Ask AI how.

4

Write the steps down

Every click, in order. That's the hard part.

Try this in your own Claude or ChatGPT

Every month I build the same Excel report. Here are the steps I do by hand, in order: [list them, messy is fine]. Here's what the sheet looks like, with private numbers removed: [paste the headings and a few sample rows]. Tell me which steps can become formulas that update on their own, which ones Excel could record and replay, and which ones still need me. Then give me the formulas, one at a time, in plain words.

Before you paste work stuff into any AI, check what your company allows.

If the same report comes back every month, that's work that keeps coming back. The free Lab shows you how to hand that work to Claude.

Free tool

Hand It Off or Keep It

Ten everyday office tasks, one at a time. Tap whether you'd hand it to AI or keep it. See Flex's call and why. A two-minute game.

Play a round
Flex the robot at his sunny office desk pressing one big teal button while the printer beside him fires out a neat stack of identical memos, feet up, coffee in hand, and little Clawd peeking out of the printer's paper tray
Inside the Lab

Learn this in the Lab, free

A free group where you learn to use Claude for the repeat parts of your job: email, reports, forms. Start with a 15-minute chat that maps what Claude can do in your job.

  • Free
  • No coding
  • Works in Claude
Start free on Skool
✱ What people ask
How do I automate a monthly report in Excel?

One clean template with the formulas built in, a tab where the new numbers get pasted, and the clicks that still repeat recorded once.

How does automation in Excel using macros work?

A macro is Excel recording your clicks so it can replay them. Flex's plain-words page. Flex has a page on it.

How do I automate Excel reports using AI?

Describe your steps and your sheet to a chat AI, and ask for the formulas one at a time. Test each one on a row you did by hand.

✱ More from this pile: Automating repetitive tasks
How do you use AI to write a memo?How do you write a memo?Can you use AI to write your report?How do you automate Excel reports using macros?Can I automate my job?How do you automate your job with AI?Should you automate your job?How do you automate administrative tasks?What does "automate repetitive tasks" mean?How do you work smarter, not harder?How do you be more efficient at work?How do you automate using Power Automate? Hand It Off or Keep It
From Nikki's blogFlex tells you how. Nikki tells you what it felt like. Read it on Clawd and Me. Read it →

Want to hand this to Claude?

Start in the Lab with the free 9-to-5 Job Triage: a 15-minute chat that maps what Claude can do in your job. Everything inside is free.

Start free on Skool