How to Calculate a Trimmed Mean in Excel. A trimmed mean is much like a standard mean, which you can derive in Excel using the AVERAGE function. However, instead of using all of the data points to ...

Excel provides built-in tools to help you to find discrepancies like Filters, Conditional Formatting, advanced functions (If and IS, VLookUp, etc.), and Add-ins.

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

The article How to Calculate the Regression of 2 Stocks Using Excel originally appeared on Fool.com. Try any of our Foolish newsletter services free for 30 days .

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.