Excel's UNIQUE function returns a list of unique values in a range, while the FILTER function lets you filter a range based on conditions you set. Let's start with the FILTER function.

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

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

The final function calculates the differences in months and days without the years and shows the date with “d.” Now you know how to calculate age in Excel. Please only use your powers for good.