Jimmy | Reporting & Automation (@JimmyAutomates) header
Jimmy | Reporting & Automation (@JimmyAutomates) profile picture

I look at repetitive work and ask: does this really need to be manual?Fixing broken spreadsheets & automating recurring reporting so your team saves hours.

Remote
Joined October 2024
Photo by Jimmy | Reporting & Automation (@JimmyAutomates)Photo by Jimmy | Reporting & Automation (@JimmyAutomates)Photo by Jimmy | Reporting & Automation (@JimmyAutomates)Photo by Jimmy | Reporting & Automation (@JimmyAutomates)Photo by Jimmy | Reporting & Automation (@JimmyAutomates)Photo by Jimmy | Reporting & Automation (@JimmyAutomates)Photo by Jimmy | Reporting & Automation (@JimmyAutomates)Photo by Jimmy | Reporting & Automation (@JimmyAutomates)Photo by Jimmy | Reporting & Automation (@JimmyAutomates)Photo by Jimmy | Reporting & Automation (@JimmyAutomates)
A lot of our time isn't spent doing difficult work. It's spent repeating work we've already done. Updating reports. Consolidating files. Checking numbers. Cleaning data. That's why I keep asking: Does this really need to be done manually every time? I share what I'm learning and building around reporting, Excel and practical automation. Better reports. Less manual work.
1
1
4
180
Before redesigning a slow weekly report, list the 5 steps that happen before you touch the summary tab. Usually 80% of the friction lives in file collection and column cleanup—not the final chart.
2
16
When a weekly report takes hours to build, the problem usually isn't the report. It's everything happening upstream: chasing files, standardizing names, and fixing broken links before the summary even opens. Trace the data backward before redesigning the layout.
7
Three signs a spreadsheet task is ready to automate: • You follow the exact same click sequence every week • A single stray space or blank cell breaks your lookup • You dread doing it before a deadline
24
Jimmy | Reporting & Automation retweeted
Replying to @JimmyAutomates
the filter I add is stable, a 15 minute task that changes shape every month costs more to maintain automated than done by hand
1
1
9
A manual task that takes 15 minutes doesn't feel worth fixing. Until you realize you've done it 50 times this year—and every time it breaks your concentration on real work. Small, boring, repeating tasks are the highest-ROI things to automate first.
1
3
67
Jimmy | Reporting & Automation retweeted
Replying to @JimmyAutomates
Exactly. It's easy to stay busy building, but real progress starts when you put the product in front of people and learn from their response.
1
1
13
How many separate files, tabs, or emails do you have to open just to answer one basic status question?
41
Stop emailing master Excel workbooks around for updates. Keep separate, locked-structure input sheets per owner and pull them together automatically via Power Query. Zero overwritten formulas, zero version chaos.
30
Most teams don't have a lack-of-data problem. ​They have a "data is scattered across 4 Excel files, an email thread, and someone's desktop folder" problem. ​Before anyone can answer one basic question, someone has to stitch it together by hand.
25
Jimmy | Reporting & Automation retweeted
Replying to @JimmyAutomates
formatting eats it for me whenever the source columns change without warning
1
1
1
13
Jimmy | Reporting & Automation retweeted
Replying to @JimmyAutomates
bucket two only works if the report says what changed, most automated reports still hand you the same 40 rows and make you find it
1
1
13
Jimmy | Reporting & Automation retweeted
Replying to @JimmyAutomates
Humans in the loop improve efficiency.
1
1
1
14
How much of your weekly reporting time goes into cleaning and formatting vs. actually analyzing the numbers?
1
1
50
If your Monday morning starts with copying rows from 4 different trackers into one master sheet, you don't have an analysis problem. You have a consolidation bottleneck. Automate the merge so your week starts at the review step.
1
30
Look at your weekly reporting routine and split the hours into two buckets: 1. Collecting, cleaning, and formatting files. 2. Spotting what changed and deciding what to do next. Automation shouldn't replace your judgment. It should buy back the time to use it.
2
3
74
If you're the 'Excel person' on your team, what's the one broken formula or messy export people ask you to fix every single week?
2
40
Every time you fix a recurring spreadsheet error manually, ask one question: "What input rule or Power Query step would stop this error from entering the file next week?" Fix the intake once instead of patching the output forever.
1
23
If you're good at Excel, you know how this goes: "Can you fix this formula?" "Can you clean this file?" "Can you combine these sheets?" Solving it once is helpful. Solving the exact same broken file every week means the process needs fixing, not the formula.
1
32
Jimmy | Reporting & Automation retweeted
Replying to @JimmyAutomates
Whether the totals still line up with last week's row count, a sudden jump usually means a join duplicated something.
1
1
1
19
Jimmy | Reporting & Automation retweeted
Replying to @JimmyAutomates
the row count against the source before anything else, a total can look right while a whole week of rows is missing
1
1
1
19