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.

In each case, it's easy to compute the final value in Excel. The one-year final value for the investment should equal 100 x 1.04. This can be otherwise written as "= (100 x 1.04)" in Excel.

When you need to see the last value in an Excel Table or data range, these formulas will get the job done. This walk-through details the necessary formulas and some VBA code that performs the same ...

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

which feels especially powerful when you're calculating separate values in a table. You can use Excel's COUNT function to find how many items there are in a table. COUNTIF, on the other hand, delivers ...

Excel is a powerful tool that can be used to analyze various time-value-of-money applications. Though this article primarily focuses on personal financial planning use cases, accountants can apply the ...

Highlighting the minimum or maximum value within an Excel row or column takes a bit more work. You might consider using the built-in Top 10 Items and Bottom 10 Items rules and changing 10 to 1, but it ...

That value needs to be posted to K3 but only if more than '0'. If A3 returns a value of '0' then any value greater than '0' that was previously posted in K3 would be left alone. I have been easily ...

How to Isolate a Value in Excel. Isolating values in an Excel 2007/2010 worksheet or workbook is common in both error-checking and data analysis tasks. While appropriate even for a small worksheet ...

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 .