Microsoft Excel's new dynamic array functions make complex calculations easier than ever before.

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

When you think of double quotation marks, you probably remember your English lessons in school. However, in Microsoft Excel, ...

Learn how to use the TEXTJOIN function in Excel. The TEXTJOIN function can be used to combine data from a range of cells using one or more delimiters.

Excel has a versatile If, Then function built right into it. We’ll show you how to use the IF function in Excel with a number of helpful examples.

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.