Discover why Excel's INDIRECT function is outdated and learn smarter alternatives like Power Query, FILTER, and LAMBDA for ...

Excel's PIVOTBY function allows you to group your figures without needing to recreate your data in a PivotTable. What's more, ...

Learn how to sum and count Excel cells by color with 3 easy methods. Save time, reduce errors, and boost your data analysis ...

This article originally published October 20, 2015, and has been updated to the current Excel version, plus we’ve added more useful functions.

Excel’s UNIQUE function allows users to extract unique values from a dataset, making it easier to identify and remove duplicates.

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

Kinds of Functions Used in Excel. Microsoft's Excel program, widely used in business, comes with many built-in functions that perform mathematical and logical operations on spreadsheet data.

Here are the 17 most useful accounting functions in Microsoft Excel to make financial data monitoring and reporting easier and faster.

Excel’s Text functions are a major time saver if your job entails managing massive data, especially data that’s imported from other sources. Fortunately, all ASCII data is easily imported, but ...

Q. Could you explain how the AGGREGATE function works in Excel? A. AGGREGATE is possibly the most versatile function in Excel. Think of it as an advanced version of the SUBTOTAL function that offers ...