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

Excel custom functions can also be created as Excel add-ins so that they are available for use in all workbooks. To create a function, open a new Excel workbook and create a small worksheet as shown ...

Combine an Excel custom format with data validation and remove the pressure for input perfection from personnel by letting Excel do the work.

Helen Bradley demonstrates Excel formatting tricks that will help you when things don't work as planned. Learn her methods now.

Excel filters help you find exactly what you want, no matter how big your spreadsheet database is. Here's how to set number, text and data filters.