Which advanced Excel skills are still valuable for data analysts?

Excel remains useful for fast ad-hoc work. High-value skills: - Pivot tables and pivot charts - XLOOKUP/INDEX-MATCH - Power Query for cleaning - Basic statistics and what-if analysis Use Excel for exploration, but move production logic into SQL/BI models to avoid “spreadsheet drift.”