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 .

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 calculate the intrinsic value of a stock using Warren Buffett's proven method! Intrinsic value is the foundation of successful investing, helping you determine whether a stock is ...

Filters are great tools, but you can't remove specific items from the results. When you need to do this, try Find All in Excel instead.

Regression statistics will typically include an R-squared value. The closer to 1 this is, the stronger the correlation between the returns of the two stocks.

You can search in Excel with the Search Sheet bar, and use Find and Replace to swap out terms or values. Here's how to do it.