Here are nine advanced Excel skills that can prove valuable in various professional setting
PivotTables
Power Query
Power Pivot
Advanced Formulas
Data Validation and Advanced Filter
Conditional Formatting
Dynamic Dashboard
Scenario Manager and What-If Analysi
Excel Macros and VBA (Visual Basic for Applications)