I didn’t know these Excel functions existed, but now I can’t live without them
www.makeuseof.com/i-cant-live-without-these-excel-functions/
5 TEXTSPLIT – Breaks apart text that’s stuck together
4 TEXTJOIN – Combines multiple cells into one
3 CHOOSECOLS – Selects specific columns from your data
2 TAKE and DROP – Extracts portions of your data
1 AGGREGATE – Powerful calculations that handle messy data