Microsoft Excel is the go-to if you want to calculate a lot of data all at once, but even outside of basic math, you can use the app to find specific info.

You can calculate the T-Value in Excel with the mean, standard deviation and degrees of freedom. Since the T-Value is a comparison between sample mean and population mean, both values need to be ...

Learn how to count the number of unique and distinct values in a column based on data in another column using array in Microsof Excel.

Duplicates aren't bad, but you may need to know how many times a value is repeated or how many unique values are in a data range. Here's how to tackle these tasks in Excel.

How to use the UNIQUE() function to return a count of unique values in Excel Your email has been sent The TechRepublic article How to create a sorted unique list in an Excel spreadsheet shows you how ...

The UNIQUE function in Excel 365 is designed to extract distinct values from a given range of data.

Calculating Nonadjacent Values in Excel Even if you have values that are not in an adjacent cell, you can still calculate them.

Daniel Jassy, CFA, is an Investopedia Academy instructor and the founder of SPYderCRusher Research. He contributes to Excel and Algorithmic Trading. Robert Kelly is managing director of XTS Energy LLC ...

Learn what present value (PV) and future value (FV) are and how to calculate present value in Excel given the future value, interest rate, and period.