Before LAMBDA was introduced to Excel, you'd need to know how to use VBA or macros to create your own function. However, today, Excel's LAMBDA tool lets you do this using familiar Excel language ...

Regular expressions aren't just for use in Excel. In fact, you can use REGEX to automate other tasks on your computer, like fixing copy-pasted PDF text, bulk-renaming downloaded files, formatting ...

Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.