5 hidden functions in Google Sheets that Excel still doesn’t have
www.makeuseof.com/hidden-functions-in-google-sheets-not-in-excel/
ISEMAIL and ISURL – Data validation made simple
COUNTUNIQUE – Instant unique value counting
IMPORTFEED, IMPORTHTML, IMPORTRANGE, and IMPORTXML – Live data at your fingertips
ARRAYFORMULA – Dynamic arrays that actually adapt