In Excel spreadsheets, complex formulas are difficult to enter without making mistakes. Microsoft Excel’s LAMBDA() function can make such errors easier to find.

Most function-key shortcuts also work in Google Sheets, but you may need to enable compatible spreadsheet shortcuts from the Help menu to access some familiar Excel shortcuts.