Microsoft Excel is a computer program that users across the globe use to calculate their spreadsheets or arrange their data. Excel provides over 300 functions that can assist individuals to make ...

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

Figure E Use Excel’s BYROW () to evaluate by rows. As with Excel’s BYCOL (), you could do this with several MAX () functions, but that would require 11 functions and would return 11 result values.

Freezing the top row of your spreadsheet is a good place to start. This function allows users to scroll through the remaining data and keep headers or important columns in their line of vision.

For this purpose, we’ll use a validation control. Select F3. Click the Data tab and then click Data Validation in the Data Tools group. If necessary, choose Data Validation from the dropdown.

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 .