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

Microsoft Excel comes with a lot of built-in functionality that doesn't restrict you to comparing data in two columns using only one method.

How to compare Microsoft Excel columns with the IF function The IF Excel formula is a logical function that checks conditions and returns a value based on the outcome.

Compare Excel Sheets with Excel Compare Tool xc Excel Compare Tools is an add-in for Excel which allows the comparison of values and formulas between two excel spreadsheets to deal better with data.

How to use Excel formulas to compare multi-column lists Your email has been sent Duplicates in the same column are easy to find by sorting, filtering, and using conditional formatting. When none ...

If you want to compare data in a side-by-side fashion, then we suggest using the Scenario Manager feature in Excel. You can also use it to swap multiple sets of data within a single worksheet.

How to Make a Two Column Spread Sheet on Microsoft Excel. Unless someone's calculator needs an upgrade, one plus one usually adds up to two. With Microsoft Excel, you can put that math to work ...

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 .

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.