VLOOKUP, XLOOKUP, SUMIFS, INDEX-MATCH
Handling large data imports (CSV, SQL)
Formula optimization techniques
Workarounds for missing Excel functions
Dynamic ranges in reports, Python (Data Cleaning – Jupyter):
Using pandas for cleaning (missing, duplicates, outliers)
Merge/join datasets
Date formatting & text categorization