How to analyse data in Excel using Claude Opus 4
Kling video prompt by Awa K. Penn · original post
the prompt
Categorise every transaction into groups: income, business expenses, personal spending, subscriptions, taxes, and transfers. Flag any recurring charges I might have forgotten about. Calculate my total income, total spend, and profit margin for each month. Highlight my top 5 spending categories. Spot any unusual or duplicate charges. Then give me everything into a clean Excel spreadsheet with a summary tab and a breakdown tab with charts.
Made this? Fix the credit or remove it.









