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 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.

This article looks at how to use Excel’s auditing tools to audit formulas and ensure the accuracy of data.

Find the data you need in an Excel sheet more easily with these functions.