Excel Data Analysis, Manipulation & Advanced Formulas Expert Needed

I have a set of Excel workbooks that need a smarter layer of automation. Your job is to weave in solid, intermediate-level formulas—VLOOKUP, nested IF statements, and similar functions—to turn raw data into information I can slice and present quickly. Alongside the formulas, I need reliable data sorting and filtering controls as well as conditional formatting rules that instantly flag exceptions and trends.

The focus is on clear, maintainable solutions; no VBA or complex array formulas are necessary.

Deliverables:
• Updated .xlsx file(s) with all new formulas, sorting/filtering views, and conditional formats in place
• A concise in-sheet note or README explaining the logic so I can update it later

I’ll share the current workbook as soon as we start and will be available for quick clarification whenever you need it.