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

Learn how to use the VLOOKUP formula to compare a maximum of two columns to have common values returned or to locate missing data.

How to highlight values Excel has a built-in conditional rule that highlights unique values. You don’t have to come up with a special formula—you just run though a few clicks.

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.

You can freeze columns in Excel with a few clicks, and then unfreeze them when you no longer need to view them statically.

How to Use Excel to Calculate a Bond's Yield to Call. Bonds are investment vehicles that make regular coupon payments until maturity, at which time the bond's face value is paid.