I tried these 6 new Excel functions and they saved me a ton of time
https://www.makeuseof.com/new-excel-functions-worth-learning-this-year/
- Regular expression (regex) functions
Find, extract, and clean data without endless text formulas- regexreplace
REGEXREPLACE Function | Microsoft Support
https://support.microsoft.com/en-us/excel/regexreplace-function - regextest
REGEXTEST Function | Microsoft Support
https://support.microsoft.com/en-us/excel/regextest-function - regexextract
REGEXEXTRACT Function | Microsoft Support
https://support.microsoft.com/en-us/excel/regexextract-function
- regexreplace
- IMPORTTEXT and IMPORTCSV
Bring in CSV and text files without touching Power Query- importcsv
IMPORTCSV function | Microsoft Support
https://support.microsoft.com/en-us/excel/importcsv-function - importtext
IMPORTTEXT function | Microsoft Support
https://support.microsoft.com/en-us/excel/importtext-function
- importcsv
- LAMBDA Function
Build formulas once and reuse them everywhere- lambda
LAMBDA function | Microsoft Support
https://support.microsoft.com/en-us/excel/lambda-function
- lambda
- IMAGE Function
Pull logos, flags, and photos directly into cells- image
IMAGE function | Microsoft Support
https://support.microsoft.com/en-us/excel/image-function
- image
- TRIMRANGE Function
Trim away empty rows and columns before they cause problems- trimrange
TRIMRANGE function | Microsoft Support
https://support.microsoft.com/en-us/Excel/trimrange-function
- trimrange
- DETECTLANGUAGE and TRANSLATE functions
Break language barriers- detectlanguage
DETECTLANGUAGE function | Microsoft Support
https://support.microsoft.com/en-us/Excel/detectlanguage-function - translate
TRANSLATE function | Microsoft Support
https://support.microsoft.com/en-us/excel/translate-function
- detectlanguage