If you've ever had a list of first and last names that you wanted to separate Excel and Google Sheets make it easy. Here's how to do it in each application.

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

Microsoft Excel is ubiquitous, but it's far more than a simple spreadsheet app — a huge array of powerful features lay within its cells.