When counting unique values in Microsoft Excel, use UNIQUE() as a helper function and avoid more complicated expressions.

Excel ROW function will return the row number of a reference. ROWS will return the number of rows in a column. Learn how to use the Row and Rows function in Excel.

Microsoft Excel's new FILTER() function is a great tool for reporting and dashboards. We'll show you how to use it to get more done.

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

For many, the INDEX-XMATCH combination in Excel is the go-to method for retrieving a value from a dataset. However, you can also use this dynamic duo to perform two-way lookups, returning a value at ...

If your business makes investments in equipment and employee benefit contributions, you may need to track the average annual rate of return over a span of time for financial reporting obligations.

How to Determine the Future Value of Salaries in Excel. The future value function capability in Microsoft Excel helps business owners easily assemble data for projects such as budgeting and ...

This Technology Workshop illustrates how to leverage a number of functions to perform calculations in Excel involving the time value of money.