Boolean logic: The method used to evaluate conditions, returning either TRUE or FALSE. Logical functions: The primary logical ...

You can sum cells across multiple sheets in Excel. This article presents steps for Adding single-cell values or Adding values in the range of cells.

Averaging in Microsoft Excel is easy, until you start excluding specific values. Here are three ways to average a data set when giving special consideration to the highest and lowest values.

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.

How to Highlight Values When They Change in Microsoft Excel. When multiple people work on the same Excel spreadsheet, it can be difficult to keep track of changes. As an example, a balance sheet ...

If you wish to count the same or duplicate values in a column only once in Excel or the count of occurances of duplicate values, read this article.

Learn how to add a highlight to expose groups in your Microsoft Excel data using a helper column and Excel’s conditional formatting feature.