Advanced Operational Data Excel Analysis

I need my raw operational data transformed into clear, insight-rich Excel workbooks. The task is strictly analytical: no VBA or heavy dashboard design—just solid data analysis built on powerful formulas.

Here’s what I’m after:

• Clean master data tab with data-validation rules so new records import without errors
• Pivot tables that summarise service levels, throughput, and any other efficiency metrics we identify together
• Pivot charts linked to slicers for quick, visual trend exploration
• Conditional formatting that flags exceptions and bottlenecks at a glance
• A concise “how-to” sheet outlining refresh steps and any custom formulas you add

Acceptance criteria
• All calculations update correctly when I replace the source file with next month’s extract
• No broken references or manual copy-paste steps required
• Visuals remain readable and print-ready on A4

The workbook should be lightweight, easy for non-technical managers to navigate, and built entirely with standard Excel functions, pivot tables, and conditional formatting. If you routinely deliver this kind of operational insight, I’m ready to share the dataset and get started.