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.

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.

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

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 what Value at Risk is, what it indicates about a portfolio, its pros and cons, and how to calculate the VaR of a portfolio using Microsoft Excel.

The easiest way to spot a unique value is to format it, and Microsoft Excel offers two ways to do so.

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.

Microsoft Excel has dozens of preset formulas for many types of mathematical calculations, but compounding interest isn't one of them. To calculate the future value of a single amount compounded ...

Thanks -- and Fool on! The article How to Calculate Intrinsic Values of Shares in Excel originally appeared on Fool.com. Try any of our Foolish newsletter services free for 30 days .