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

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.

Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on ...

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

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

Microsoft Excel's Month and Weekday functions output numeric values for a given date. The Month function results in the month numbers, such as "3" for March or "12" for December.