Job Title Required Skillset - Advanced Excel & Data Analysis Proficiency Mastery of formulas and functions: VLOOKUP, XLOOKUP, INDEX/MATCH, IF/IFS, SUMIF(S), COUNTIF(S), and text functions. Strong experience with PivotTables, Power Query, and Power Pivot. Ability to design dynamic reporting tools using modern Excel functions (UNIQUE, FILTER, SORT). Data validation, conditional formatting, and advanced charting capabilities.