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.