Excel Purchase Data Analysis

I have a collection of purchase-related records stored in Excel and need a clear, actionable analysis of that data. The raw sheets are already compiled; what I’m missing is the insight—trends, patterns, and concise metrics that will help guide spending decisions.

The work will revolve around:
• Cleaning any irregular entries so formulas run without errors.
• Building pivot tables or similar summaries that spotlight totals, averages, and month-over-month changes.
• Creating easy-to-read charts inside the workbook so the findings jump out at a glance.

Please keep everything inside a single Excel file, using separate tabs for the cleaned data, calculations, and visual outputs. All formulas should remain visible so I can update the workbook with new records later.

If you’ve done purchase or expense analysis in Excel—especially using functions like SUMIFS, POWER QUERY, or simple VBA automation to streamline repetitive tasks—your experience will be directly relevant here. I’ll share the dataset once we agree on the approach, and I’m happy to clarify any specifics you need before getting started.