Applying advanced formulas (nested-ifs, LOOKUP functions, pivot tables) to transform raw data into actionable insights